This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to create an input where I can upload excel documents to the sharepoint folder, where Alteryx can then run its workflow for the most recently uploaded excel doc. When I try to copy and paste the URL for data connections, I have gotten "Could not connect to the server, please try again." I have tried doing simpler URL to the main document URL of our companies sharepoint, yet still have the same error.
We use Sharepoint often and it gets pretty finicky. I have had most success by opening the Sharepoint site where the files are located using Internet Explorer. There should be a tab at the top left corner of the page called 'LIBRARY', click on that tab and then click 'Open with Explorer'. This should open the sharepoint site of files like you would expect in your normal windows explorer. In windows explorer, right click on the file name and select 'Properties'. You should see a file path located after 'Location'. Copy and paste that file path to use as your input (or output). If you are connecting directly to a single file, you would obviously have to append the file name after the path you just copied and pasted.
It sounds like you want to use the directory tool though and sort on the latest Write time and sample the top record. You can then use the dynamic input tool to read the contents of your file(s).
I'd be glad to help you out if you'd like to set up a webex.