download from URL.

[Raj_007]

Hi

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 - 

[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

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

[Assaf_m]

Hi @Raj_007 ,

Did you change the Action shown below? 

if it is still not working, you can specify the sheet in the options menu below.

let me know if it works for you.

[Raj_007]

Hi Assaf,

Yes, i selected the action, when i click on table or query button it throws an error - looks like iam missing something

[Raj_007]

Hi All,

could someone please provide some insight on how this is working... kind of "enlightenment" please

1).I took a input box tool - it looks like below - specified the location to the share point folder; used get the list of sheet names

2)Created an output columns

3.applied a filter to get only the sheet that i want to load

4)I took an example file from the community and this is where i am banging my head to the wall

the workflow example that i took it from the community has the line in the "input datasoruce template" - This i did not modify it or i did not touch it all

how is it working? I do not have E drive on my PC or i have any excel file that is name is File1.xlsx - but when i run it i see the data getting from the SP folder file and it is what i want - this particular line i am not able to get it - i really appreciate your time if someone can explain me this

E:\Test\ExcelLoad\File1.xlsx