get-data
Retrieve and query data from Coupler.io data flow runs using SQL to extract specific information for analysis and visualization.
Instructions
Get data from a Coupler.io data flow run. Make sure to first query a sample of 5 rows from data table, e.g. SELECT * from data LIMIT 5, and then run the get-schema tool, to better understand the structure. The get-schema tool will return the JSON-encoded schema of the data table. When visualizing the data, do not try to read any files or fetch any URLs, just generate a static page and use the data you get from the tools.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataflowId | Yes | The ID of the data flow with a successful run | |
| executionId | Yes | The ID of the last successful run (execution) of the data flow. | |
| query | Yes | The SQL query to run on the data flow sqlite file. |