socrata
Socrata API missing fields
A Socrata API call is missing fields that show up through the Socrata dataset web interface. Here's a sample API call: https://opendata.fcc.gov/resource/sr6c-syda.json?id=860970
Notice that the returned JSON doesn't include the ticket_created datetime field. But you can see that field via filtering the Ticket Id by 860970 on the web data interface here:
https://opendata.fcc.gov/Consumer-and-Government-Affairs/CGB-Consumer-Complaints-Data/3xyp-aqkj
What explains this discrepancy?
Solution
Sorry for missing this question earlier!
Can you double-check your output results? I just tried that same query and I see the ticket_created field in the output:
- Socrata: Find all datasets from a domain
- Socrata API not returning most recent data (only up to 2 year old)
- Latest Nursing Home Compare data-set returning no data
- Socrata API deep scrolling in R
- Trying to sort an API set by date range
- Using $limit and $offset to get more than 1,000 rows on a SODA API
- Socrata get data types of dataset columns
- Use a python list in a Socrata Request
- System.ArgumentOutOfRangeException: 'The provided resourceId is not a valid Socrata (4x4) resource identifier
- SODA API not returning all fields in data set
- soda-js Group By returns "Invalid SoQL query"
- Need help pulling JSON data with RSocrata from a website API
- CMS Open Payments Data Limitation
- Q: How to remove the limit of 1000 records per request
- How to determine number of records on a socrata table
- How to use SODA.net and App Token in asp.net-core MVC
- SODA between operator does not work with some datasets
- do some public Socrata data sets require login for programmatic access?
- how to download .csv file using API Endpoint in pandas
- How to construct a SoQL where clause on a text column using <= operation?
- case-insensitive queries for a Socrata SoQL
- Socrata, SODA, REST, JS: How to query number of rows?
- Socrata - Is there any way to get list of cities whose crime data is available on Open Data?
- Chicago Data Portal API format for filter with multiple conditions
- SOQL Socrata query datetime between
- Display error message when api call comes back empty in Shiny?
- Socrata SODA and Python
- Socrata nodejs - convert floating time stamp to a date time format
- How to query between floating dates?
- Socrata, find all available datasets