Skip to main content
Question

Load a .csv file from SharePoint

  • April 7, 2021
  • 0 replies
  • 252 views

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 file that I'd like to ingest, but I don't know what to do next.  The Fetch Linked File step doesn't seem to offer me what I need.  The CSV Handler channel can't authenticate to SharePoint (HTTP 403 error) when trying to pass the URL the Search Files step returns. 

Curious if anybody else has been successful with this...

Thanks!

------------------------------
Jonathan Bigelow
------------------------------
This topic has been closed for replies.

@Jonathan Bigelow

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/
------------------------------