Skip to main content
Question

Bulk Upsert From Sharepoint

  • November 17, 2021
  • 0 replies
  • 98 views

Hey all,

I replicate a SharePoint list in a Quickbase Table, using pipelines. For each of the lines from SharePoint list, I look in my QuickBase table if the record exists. If it does, I update the QB record, otherwise it creates a new record.

This sounds very similar to what the 'upsert' method does, but until now I haven't been able to make it work. Is it because the bulk upsert works only from QB, to QB ?

Thanks for your help!

------------------------------
Pierre Hamy
------------------------------
This topic has been closed for replies.

  • Author
  • Quickbase Alumni
  • November 22, 2021
Answer I got from the Technical Support Team : 

"The Bulk Upsert step is best used for Quickbase Table to Table actions. If the file that is hosted on Sharepoint is in CSV format, and you were able to get the file into the Fetch CSV action you could search the CSV and perform a Bulk Upsert."

------------------------------
Pierre Hamy
------------------------------