Load a .csv file from SharePoint
Has anyone successfully retrieved data from a .csv file stored on SharePoint using pipelines? I can authenticate to SharePoint using the SharePoint channel and use the Search Files step to find the...
Forum Discussion
Have you tried using the File Transfer handle variable from the Search Files action in the Csv URL field of the Fetch CSV action?
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
[email protected]
https://www.jaybirdtechnologies.com/
------------------------------
@Justin Torrence, interestingly enough, using either File transfer handle or Web url (which I was using originally but I tried File transfer handle at your suggestion) returns an input validation error. When I look at the pipeline activity, I see Auth Schema, Username, and Password being passed in, but no value for the Csv URL (edit: I should clarify, it doesn't look like the parameter is being passed in with a blank value, I don't see the parameter at all). When I try hardcoding the URL to the .csv on SharePoint, I get the HTTP 403 error.
------------------------------
Jonathan Bigelow
------------------------------
------------------------------
Jonathan Bigelow
------------------------------