Download CSV data from online

[sislam11]

Hi,

1. I am trying to download exchange rate data from here: https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2022-monthly

For example I am trying to download the first file for November 2022 (attached) and link here: https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1112... 

Please help me solve the error in the workflow attached

I would like to save the data into the same folder as that which the workflow is saved.

2. Additional question: would anything within the workflow need to be changed if the workflow were to be run on Alteryx Gallery?

Many thanks in advance!

[Felipe_Ribeir0 · Accepted solution]

Hi @sislam11 

Here it works fine, have you tried with another internet connection? Maybe the current one that you are using (vpn/proxy/firewall settings probably) is blocking it.

You could try to follow these suggestions to pass by this error in your company network: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-transferring-data-Failure-when-r...

About running it on the gallery, i would just output the result as string and parse it, or save it to a network shared folder. But it does run on gallery without any issues, i have one workflow on gallery here doing the same job for a different csv file.

[sislam11]

Thanks for the quick response!

Is there anyway to manipulate the data within Alteryx without first outputting the file and then inputting again?

I have tried using dynamic input tool but I am not sure how it will work as in the "input Data Source Template" the temporary file path will keep on changing so cannot get the input template

Is there any method without using dynamic input?

Perhaps creating an output file and then adding this as another input into Alteryx? However this will require manual intervention and requires running the workflow twice so is not ideal

[Felipe_Ribeir0 · Accepted solution]

Hi @sislam11 

Take a look at the attached workflow. The first container is doing the job saving the temp file and using the dynamic input to open it, the second one is doing it parsing the string directly.

[sislam11]

Thanks this works perfectly as I needed it! 

Would the solution be any different if it were a different types of file such as xls or xlsx?