data.query
data.query automations generate custom data query results for an automation.invoke data query.
For instance: reading from a resource file, fetching from an external API, post-processing search results, etc.
It's now possible to work with third-party data sources in any feature that supports data queries (sheets, charts, etc).
Inputs
The automation dictionary starts with the following values:
| Key | Type | Notes |
|---|---|---|
inputs |
dictionary | Custom input values from the caller |
query_format |
string | The requested query results format (e.g. format:dictionaries) |
Outputs
return:
| Key | |
|---|---|
data: |
The results of the data query. |
The format of data: will depend on the given query_format.
For instance, the dictionaries format is an array of dictionaries, like:
return:
data:
0:
id: 1
name: Record 1
1:
id: 2
name: Record 2More complex values can be returned using the @json or @key annotations.