loading data by using URL of the confluence page..but not working in Alteryx server

[Raj_007]

Hi, Thanks a lot for your time, I have this scenario could someone please help if i am doing something wrong... or iam missing something....

I have a confluence page and there is an excel file in it (.xlsx) - we dont need any access to that page - internally it can be accessed if someone has the URL so there is no specific access

I am trying to download using the URL of that excel file in my Alteryx designer.. I use the following tools and the configuration to get the data downloaded to a temp file locally and it is working fine.

What is the issue? When i upload the Alteryx workflow into Alteryx server it is throwing an errror  - attaching the screenshot starting from the error on server

why the alteryx server is not able to save a local copy in my shared drive is not able to understand? does this related to alteryx service account having access to the shared drive

1)

2).I take the text input and i specify the URL along with the FileName and Sheet names -- screenshot is below

3).calculated field to get the file name and sheet name

4).Download tool configuration is very straightforward

4).Dynamic Input  tool configuration  - i have specified my shared drive location with the file name and the file is in this location. this is my input data source template. 

5)run time 

5).run time - temporary local file folder - here also i have specified my shared drive location as the temporary files location folder

When I upload the workflow with these settings i am getting that error. When I run in my PC i see that temporarry file location folder as soemthing different like C:\N789789\App\Data\.....

any help please... got stuck with this for few days

[christine_assaad]

Hello @Raj_007 

In step # 3, have you tried to replace the ".\" by your Shared Folder path?

[Raj_007]

Hi Christine, Thank you so much. I am so stupid...  i did not think about that ".\"  - I removed this and replaced it with my shared drive folder where the ,xlsx file is sitting

"\\Confidential_Removed\Alteryx\Jira Release Project\In\" +[FileName]+"|||"+[Sheet]

and I also changed the temporary file location folder in run time settings with the shared drive folder location

User Specific Folder

\\Confidential_Removed\Alteryx\Jira Release Project\In\

I also tested with "use Global Default" option in run time settings which includes the location something like c:\UserName123\AppData\temp\  .....something like this

with this setting also i got the same error message on server

Then saved into my alteryx server - i still see the same exact message... Now the last one could be alteryx service account needs to have acccess to shared drive folder?

do you think that could be the issue

[Raj_007]

Hi Christina, i dont think i have any issue with reading from shared drive from alteryx server because we have been using the workflows on the server that read data from the shared drive... i think i am missing something in the download tool or dynamic tool....

R