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

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 2

More complex values can be returned using the @json or @key annotations.