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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 692 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive