DOMO API - Upsert a Datasert
We are on a process of starting to use DOMO's API to upload data to DOMO. Is there any way to Upsert a dataset using the API's?
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"**You can say "Thank you" by clicking the thumbs up in the post that helped you.
Comments
-
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.
2 -
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
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive