search

socdataR / wonderapi

Assists in making queries to CDC Wonder API
https://socdatar.github.io/wonderapi/
23 stars 14 forks source link

Unable to Use Locations in D76 #24

Closed CIOData closed 1 month ago

CIOData commented 2 months ago

I am attempting to make a pull from table D76 that includes restrictions on the location by county. These include selections to the F parameter F_D76.V9. When I run send_query() for this I get the following error:

Message from query:
Selections were made to location variable D76.V9.
Error in send_query("D76", "Underlying Cause of Death, 1999-2020_1721649898996-req.xml") : 
  Internal Server Error (HTTP 500).

Please advise.

jtr13 commented 1 month ago

Thanks for letting me know. The CDC makes a lot of changes and it's hard to keep up with them. @brendensm no pressure but if you get a chance could you see what's going on here? Thanks!

brendensm commented 1 month ago

@CIOData Restrictions based on location are not allowed by the API.

From the README:

NOTE, HOWEVER, THAT THE CDC DOES NOT ALLOW QUERIES WITH LOCATION FIELDS THROUGH THE API. If you wish to limit or group results by Region, Division, State or County, or Urbanization, use the CDC Wonder web interface rather than the API – either with or without this package. For more information on this limitation, see: https://wonder.cdc.gov/wonder/help/WONDER-API.html.

CIOData commented 1 month ago

Thank you for looking into this. That's frustrating, but not the first time I've encountered the CDC putting up additional barriers to automating data gathering.

-Todd

From: B @.> Sent: Monday, August 5, 2024 1:01 PM To: socdataR/wonderapi @.> Cc: CIO Data @.>; Mention @.> Subject: Re: [socdataR/wonderapi] Unable to Use Locations in D76 (Issue #24)

CAUTION: External Sender

@CIODatahttps://github.com/CIOData Restrictions based on location are not allowed by the API.

From the README:

NOTE, HOWEVER, THAT THE CDC DOES NOT ALLOW QUERIES WITH LOCATION FIELDS THROUGH THE API. If you wish to limit or group results by Region, Division, State or County, or Urbanization, use the CDC Wonderhttps://wonder.cdc.gov/ web interface rather than the API – either with or without this package. For more information on this limitation, see: https://wonder.cdc.gov/wonder/help/WONDER-API.html.

— Reply to this email directly, view it on GitHubhttps://github.com/socdataR/wonderapi/issues/24#issuecomment-2269517565, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AV63IT6KCQJXYZTINWAP4STZP6VWVAVCNFSM6AAAAABLIG3I5WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENRZGUYTONJWGU. You are receiving this because you were mentioned.Message ID: @.***>

jtr13 commented 1 month ago

Agree, it's frustrating especially since those variables are available on the CDC WONDER web interface.