Alteryx Weather Call - Null Rows

[jkov05]

Hello,

I'm using Alteryx, an R-based data analytical tool, to pull monthly weather data from US counties.

While most rows provide a proper JSON value output, some do not. When I re-run the remaining rows, I see they all output null rows and columns after the JSON Parse tool. Then, the corresponding data my team expects to have is showing all 0s.

I'm confused why this is happening? Is there no weather data for that selection or is it a different issue? No link/connection errors display. I have a valid key and I accept via application/Id+json.

Here is a sample URL for Autauga County, AL for July 2021:

https://www.ncdc.noaa.gov/cdo-web/api/v2/data?datasetid=GSOM&datatypeid=TMIN&units=standard&locationid=FIPS:01001&startdate=2021-06-01&enddate=2021-06-30

Any help is appreciated, thank you!

[StephenClouse]

To offer any help we would need to know what URL/endpoint you are accessing.

[jkov05]

Ah apologies. I've updated the post to include the URL for a row. It does not include the key or accept because that's input via the alteryx tool.

[StephenClouse]

Sorry, this is strictly for support of api.weather.gov. You would need to contact NCDC for help with this.