DOMO API - Upsert a Datasert

Upsert is a really useful approach to updating datasets. It is already feature of some datasets, but not all; and it currently varies connector by connector. We do not yet publish an upsert approach via API for Domo datasets, but when that feature becomes available you will find it here:

https://developer.domo.com/docs/domo-apis/data

We'd suggest you reach out to your Domo Account Executive and describe the specific upsert needs you have. From there, your Account Executive will help promote your need to the developer team and get you a roadmap for upsert on your specific dataset needs.

Hi Matthew,

The closest we've seen in SQL is to determine what makes a row unique and check against the existing dataset for matches. If you are able to find matches then you delete those rows from the existing dataset and replace those rows with their updated entries from the new dataset. Additionally, any net new rows not found in the existing dataset will also be appended. 

An example of this could be if your file contained all entries for a day. You could check if your existing dataset has entries for that day (or days), delete those rows, and append the new dataset. This works if the new dataset contains all records for a day so you don't lose data. Combinations of entries can also be used if your data is more complicated than simply the date.

Here is a link that may help you out: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow

Thanks,

Rich