We Are Here To Help

Follow

How to query more than 1000 rows of a dataset

Right now our API has a limit of returning 1000 rows of data at a time when querying the dataset. To query more than 1000 rows, there are two ways to go about this.

Using the off set parameter

Use the '$offset=' parameter by setting it to 1000 increments which will allow you to page through the entire dataset 1000 rows at a time. 

Using the limit parameter

Another way is to use the '$limit=' parameter which will set a limit on how much you query from a dataset. SODA 2.0 API endpoints have a max limit of 50,000 records while SODA 2.1 endpoints have no upper limit.

Pro tip: You can also use both together, for example, to retrieve the “4th page” of records (records 151 - 200) where you are using $limit to page 50 records at a time, you’d ask for an $offset of 150:

https://soda.demo.socrata.com/resource/4tka-6guv.json?$limit=50&$offset=150

 

For more information on limits, please follow this link on the Socrata Developer site.

For more information on off sets, please follow this link.

For more information on paging through data, please follow this link.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk