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
jtorrence@jaybirdtechnologies.com
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
------------------------------
This is going to sound very hacky, but hear me out:
- Create an application where Everyone on the internet has a role with access to a table.
- That table would have one Attachment field.
- As part of your loop after finding the files in SharePoint
- Create a new record in that table
- Use the upload an Attachment action to upload the document
- Use the Browser URL variable that is returned from the upload an Attachment action (Now a public URL) in the Fetch CSV action.
- Delete the Quickbase record you created
- Do whatever processing you intended to do in the first place.
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/
------------------------------- I like hacky and that's very creative. I'll give a shot and let you know how it goes. Thanks for the help, @Justin Torrence!
------------------------------
Jonathan Bigelow
------------------------------