Query Datastore using SQL. Wrk Action uses SQLite syntax. Note: Supports basic SELECT, WHERE, and GROUP BY statements. Aggregations and JOINs are not supported. To retrieve the row ID, include the _id field in your SELECT clause.
Application
Datastore
Inputs (what you have)
Name | Description | Data Type | Required? | Example |
SQL query | SQL Statement to fetch data from Datastore. Note: Supports basic SELECT, WHERE, and LIMIT statements. Aggregations and JOINs are not supported. To retrieve the row ID, include the _id field in your SELECT clause. | Text (Long) | Yes | SELECT * FROM DataTable1 |
Outputs (what you get)
Name | Description | Data Type | Required? | Example |
Total number of rows | The total number of rows in the output JSON | Number | No | |
Output JSON | JSON output of the query result | Text (Long) | No |
Outcomes
Name | Description |
Success | This status is selected if the job has successfully completed. |
Requirements
N/A