Open chubbuch opened 3 years ago
I'm trying to use the API to import the current data as a csv file into a google sheet but am only getting 1000 rows.
This is the formula I used to filter by date:
=importdata(concatenate("https://data.cdc.gov/resource/8xkx-amqh.csv?date=",text(today()-1,"yyyy-mm-dd"),"T00:00:00.000"))
However I run up against the same 1000-row limit even with no filter. What am I doing wrong?
API Docs: https://dev.socrata.com/foundry/data.cdc.gov/8xkx-amqh
You need to add ?$limit={number} behind the API, like this: https://data.cdc.gov/resource/8xkx-amqh.json?$limit=5000
I'm trying to use the API to import the current data as a csv file into a google sheet but am only getting 1000 rows.
This is the formula I used to filter by date:
=importdata(concatenate("https://data.cdc.gov/resource/8xkx-amqh.csv?date=",text(today()-1,"yyyy-mm-dd"),"T00:00:00.000"))
However I run up against the same 1000-row limit even with no filter. What am I doing wrong?
API Docs: https://dev.socrata.com/foundry/data.cdc.gov/8xkx-amqh