Forum Discussion

PierreHamy's avatar
PierreHamy
Qrew Member
4 years ago

Bulk Upsert From Sharepoint

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