Appending Data from a Custom Connector
I'm building a custom connector, not yet published. When I select the Send to DOMO/Create /Update Dataset and run my script the data in the dataset is completely replaced.
The docs indicate that a custom connector can be used to update OR append data, but I'm not seeing how to do that. Is it something that's not available till after I publish?
Best Answer
-
Hi @mprcic, I am a Product Manager here at Domo.
When you code up a custom connector in connector builder you need to use the addColumn, addCell and other methods to create the table schema and insert data into the table.
Every time you run the connector it will look like a full replace. This is normal and expected.
The connector builder itself does not support Append mode, so every run will look like a replace, and you cannot currently simulate Append mode in anyway.
After you finish coding and are satisfied with how the data looks within Connector Builder, go ahead and proceed with publishing. Our Engineers will review the code for any issues and it will be converted into a full-fledged connector. At this time, support for Append Mode will automatically be added to the connector that you built. When it is finally published and available in Data Center for you to use, you will see both the Replace and Append modes available to you on the connector configuration screen as you would normally expect for any other connector.
1
Answers
-
Hi @mprcic, I am a Product Manager here at Domo.
When you code up a custom connector in connector builder you need to use the addColumn, addCell and other methods to create the table schema and insert data into the table.
Every time you run the connector it will look like a full replace. This is normal and expected.
The connector builder itself does not support Append mode, so every run will look like a replace, and you cannot currently simulate Append mode in anyway.
After you finish coding and are satisfied with how the data looks within Connector Builder, go ahead and proceed with publishing. Our Engineers will review the code for any issues and it will be converted into a full-fledged connector. At this time, support for Append Mode will automatically be added to the connector that you built. When it is finally published and available in Data Center for you to use, you will see both the Replace and Append modes available to you on the connector configuration screen as you would normally expect for any other connector.
1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive