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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 368 Beast Mode
- 19 Variables
- 483 Automate
- 101 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive