The TL;DR version of this is there a way to download an individual file with the Sharepoint Input tool by feeding the file URL rather than using the Tool Configuration File Picker UI?
More details:
Does anyone know if there is a way to download a specific file using the Sharepoint Input tool that the file name changes (so can't be picked with the tool configuration UI) - since it doesn't have it's own input anchor to feed parameters in? Or another Sharepoint add-on I haven't found that can do this?
Ideally I'd be able to use a Sharepoint Input tool and read only the list of full file paths, use formula and filter tools to pick the file/s I wanted to download, and pass the URL for that file/s into a 2nd Sharepoint Input tool that only downloaded that specific file/s
To set a few organizational limitations that have prevented using suggestions I've found on the forum so far, I must get this data from Sharepoint. Our organization requires using the Sharepoint 365/Cloud OAuth (or equivalent DCM setup of it). Due to Server Admin limitations I can't do any Sharepoint file syncing like you can on Desktop as a workaround.
I successfully have the Sharepoint Input tool connecting and getting a list of available files with URLs in a folder (about 400). I also used it to download all 400 xlsx files (which I can have Server store to a file share). The problem is that the business process adds one file per day that I need to download and/or read and take further action based on the contents. I don't want to download over 400 files every day that will eventually grow to thousands to repetitively download every day, just to get the file I need. I tried doing a re-download with the Sharepoint Input Tool to see if (long shot) it was smart enough to skip files that exist and haven't changed, but it is not. It downloaded all 400 files again.
I don't think passing the file URL that I want to the Download Tool will work since it can't use the same Sharepoint OAuth or DCM connection.
Are there other options I've missed? It seems like this would be a common use case for the Sharepoint Input tool that isn't addressed for large organizations with tightly controlled Sharepoint and Alteryx server configurations.
Thanks.
