Download error with URL

First error: the end date that you are passing to the url is using the yyyy-mm-dd hh:mm:ss format. Format it to be only yyyy-mm-dd (like your start date) and try again.

Second error: activate the throttle and set it to 300 on your download tool and try again.

What command should I use instead if I still want to be able to add the = 363 and the "days"

The only other one I saw is the "todate" but it will not allow me to include the +363 days

@leewa007

Try to replace the last part of your URL formula for this one: todate(datetimeadd(todate([startdate]), 363, "days"))

You are awesome that worked to take the time stamp off. However, lol now after running it this is what we get

Is that what we are supposed to get? What do the red little corner tabs mean?

We get these errors

Also, all of our JSON came back null

@leewa007

Configure the JSON parse tool to parse the DownloadData column and with the first option selected and try again. On your first print, you can see that the data came and it is inside of the DownloadData column.

Thank you so much for the help. We currently have more questions if you are able to help us that would be greatly appreciated.

We need to create a table that will reflect all the results 0 for example in one row rather than having 5 rows.

In doing so we used the formula icon and tried to separate the lines into columns first but we are unable to put in in numbers because it states we have to keep it as a string.

The outcome once I used the CrossTab this is what we did

But I see that it concatenated so many values together it should be 1 item per column and I see in some columns we have 6 or 7 different values added. Why is that?

This data is public? If yes, can you share the workflow if this does not work?

Copy the components from this container/workflow and add after the json parse tool:

Download error with URL.yxmd

Here is our thread and we also noticed there are some other errors. I am at a loss we tried your suggestion above and it is not working

I hope this might help; I was unable to post the thread on here like you did.

Alteryx Project.yxmd

Try like this

Alteryx Project.yxmd

That worked well. We were able to move forward.

We came across another question. If we are trying to combine two zip codes that appear in the URL but have two different numbers in the _station how can I combine the two stations that pertain to the same zip code and get an average in the _value column?