Can I trigger a connector data pull with an API?
Hi,
We want to do a regular pull of data from our mysql data into domo. As the table in mysql grows, we want the table in domo to grow - i.e. we want to sync them.
The way we would like to do this is:
1. Upload the latest data batch to our mysql database
2. Call the connector API to update the details to say "select * from mytable where timestamp > '2017-04-20'" or whatever the time of the last pull was
3. Call the connector API to do a pull, in append mode, so that the domo table grows with the new data.
But I cannot find an API that we can call to do that? There is the dataset API, but you can only use it to replace data, and it doesn't interact with connector-created datasets. There is the streams API, but you can only use it with streams and it is quite complicated to use (we will use this if we have to, but we think our simple 'come and get the latest rows from our table' solution is much simpler and neater if there is a way to do it.
Thanks for your help!
Comments
-
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive