Skip to content

Is there a limit to the number of rows retrieved with DELPHI API? #1

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
nickreich opened this issue Jun 14, 2017 · 2 comments
Closed
Labels
Engineering Used to filter issues when synching with Asana

Comments

@nickreich
Copy link

I am trying to retrieve a lot of data from the DELPHI API, but am having trouble getting all the data I am requesting. Is there a limit that I am running into? For example, I run

source("https://raw.githubusercontent.com/cmu-delphi/delphi-epidata/master/src/client/delphi_epidata.R")
res <- Epidata$fluview(regions = list("nat", "hhs1", "hhs2", "hhs3", "hhs4", "hhs5", "hhs6", "hhs7", "hhs8", "hhs9", "hhs10"), 
                       epiweeks = list(Epidata$range(199740, 201653)),
                       issues = list(Epidata$range(199740, 201653)))
df <- do.call(rbind, lapply(res$epidata, rbind)) 

And I end up with data from only regions "nat" and "hhs1" and only until epiweek 200450. The total number of rows in the resulting dataframe is 3650.

@undefx
Copy link
Member

undefx commented Jun 14, 2017

Yes, the limit is 3650 rows per request as you noted - sorry that's not in the documentation. To get all the data, you'll have to query the regions individually, or use smaller batches of epiweeks.

I'll leave this issue open until I have a chance to make a note of this in the documentation.

(BTW, the limit is implemented here.)

undefx pushed a commit that referenced this issue Apr 9, 2020
Merge pull request #32 from dfarrow0/master
krivard pushed a commit that referenced this issue Aug 5, 2020
krivard pushed a commit that referenced this issue Oct 12, 2020
krivard pushed a commit that referenced this issue Nov 5, 2020
@SumitDELPHI SumitDELPHI added the Engineering Used to filter issues when synching with Asana label Dec 2, 2020
krivard pushed a commit that referenced this issue Jan 7, 2021
@sgratzl
Copy link
Member

sgratzl commented May 14, 2021

the new endpoints of the server (e.g., /api.php?endpoint=covidcast -> /covidcast/ is streaming the results back to the client. Thus, we could increase the limit to right now 1M rows.

see also https://github.com/cmu-delphi/delphi-epidata/blob/main/src/server/_config.py#L9

@krivard krivard closed this as completed May 14, 2021
rzats added a commit that referenced this issue May 19, 2023
rzats added a commit that referenced this issue Jun 21, 2023
rzats added a commit that referenced this issue Jun 21, 2023
melange396 added a commit that referenced this issue Oct 11, 2023
melange396 added a commit that referenced this issue May 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Engineering Used to filter issues when synching with Asana
Projects
None yet
Development

No branches or pull requests

5 participants