Download error with URL

[leewa007]

We used the generate rows icon to create the Annual_Transaction_Date as follows:

We created this URL based on the information we are pulling from our database. We had to create the Annual_Transaction_Date to reflect one year because our data was on days rather than years. After creating this URL the data we received was as follows:

Once we run the URLs created, we get an error message:

We are unsure as to how to correct this or where we made the mistake. Can someone help????

[Felipe_Ribeir0]

Hi @leewa007 

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.

 

[leewa007]

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

[Felipe_Ribeir0]

@leewa007 

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

[leewa007]

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 :(

[Felipe_Ribeir0]

@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.

[leewa007]

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?

[Felipe_Ribeir0]

Hi @leewa007 

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:

[leewa007]

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. :)

[Felipe_Ribeir0]

Hi @leewa007 

Try like this