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.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
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 656 Automate
- 170 Apps
- 439 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive