download from URL.

Raj_007

looked at many solutions that were specified in the community...but could not figure out what is going on

1).I have the URL - which when i copy and paste into the browser it opens the file - i see

2).I use the text input and put the URL - tried by remove %20 with a space

3).download tool - when i run this is how it looks like -

Workflow

Accepted answers

All comments

Assaf_m

Hi,

Since your download file is .xlsx you need to change the output in the download tool to "To a file" | "Temporary File".

Then you need the dynamic input tool to read the file, check the below configuration.

Let me know if works for you.

danilang

Hi @Raj_007

If you look at the DownloadHeaders field from this image

You'll see that the response has the 404 code meaning URL not found. I would suggest that there is an error in the URL. Generally you can directly use a URL that works in Chrome, but there are some cases where you can't. One of those cases is where you're trying to access a dynamically generated URL. The URL generated in this case is only valid within the current browser session. Tabs within Chrome can share the same browser session so you can copy a URL from one tab and paste it into another. To check if this is affecting you, try copying the link from Chrome and pasting into Edge and see if that works. If it does, then the problem comes down to the actual URL that you're using in Alteryx.

You mention space and %20. For your initial post, I'm not sure if you replaced %20 with a space or the other way around. The address must be URL encoded, i.e. any characters other than A-Z, a-z, 0-9, -, ., _, ~, :, /, ?, #, [, ], @, !, $, &, ', (, ), *, +, ,, ;, %, and = must be replaced with the corresponding code. Notice that Space isn't in this list so any spaces that you have will need to leave %20 in the address. If the address works in Chrome it should already be URL encoded and should work directly in Alteryx.

Dan

Raj_007

Hi Assaf, thanks a lot

I exactly followed the same steps

1.copy paste the URL from Chrome - when i enter in chrome it opens the excel file (%20 is included in it)

2. in the download tool - uncheked the encode URL text - selected output as temporary file

3.added the dynamic input tool - %temp%test.xlsx and DownloadTempFile in read list of data sources field

then action to change entire file path - this is the error i get - i have the sheet in that file - but where do i specify the sheet name

Raj_007

Hi Danilang,

thank you so much. When I copy and paste the URL into chrome it opens the excel file (this URL i copied which includes %20 in it)

so something else iam missing

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335