DataSet API: APPEND failure behavior?
Background
I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.
Question
How do people manage APPEND to avoid duplicates and gaps? We've got a custom concurrency ID (sequence number) system in place for a custom sync tool, so we're able to track what we have and have not posted. But this assumes that we can get accurate feedback from the API about success and failure. For example, if we push 200 rows and 1 fails, is there a ROLLBACK, or does Domo insert 199 rows?
Thank you.
Comments
-
Hi,
Anyone help out with this request?Thanks,
0 -
Hey DataSquirrel,
Thank you for reaching out to Domo Support in regard to data update methods. In order to assist you as much as possible, could you please elaborate on the type of dataset you are referring to, or possibly provide a direct URL to it within your Domo environment? Each connector type may vary in the ways that they retrieve data, so I'd like to make sure that we get you well taken care of here.
If this is considered a high priority, then please call our number and reference the following ticket number:
Ticket: 05665907
1-801-805-9505
Have you been looking for a 1-stop shop for all your support cases? This message and all updates to this case can be tracked in the Customer Portal at support.domo.com. This portal makes it easy for you to track, update, and create all your support cases!
- Domo Technical Support
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@DataSquirrel
Here are the Knowledge Base articles on the Dataset API and Streams API. These will be your best resources on the topic. Outside of the details provided there, your advanced requests may most likely require help from your Client Success Manager as a consulting engagement.
https://developer.domo.com/docs/dataset/overview-50
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive