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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive