Forum Discussion

Jay's avatar
Jay
Qrew Member
2 months ago

How to Bulk Upload File Attachments from Tables to SharePoint via. Pipeline

Hi all,

I have a very large table that I want to clean up, and I'm not sure how to automatically export all these file attachments into SharePoint. Any pointers would be appreciated! 

Jay

  • There is a native Chanel in Pipelines to connect to Sharepoint.

    So you would set up a Pipeline to search your files table and then inside the For Each loop you would upload the file to Sharepoint.  If the goal is to save Quickbase file space and delete either the record or just the file attached to the record, then that can also be in the For Each loop as well.  If you are just deleting the file there is syntax I can provide to have the Pipeline delete just the file attachment, but leave the record in place.

    When you are testing, FOR SURE, you would limit the Pipeline do just limit its search to a particular test [Record ID#].  ie you don't want a Pipeline running amok on you full source table with thousands of records.  You can also limit the search step to just stop after 1 record or say 10 records during your testing phase.