Veeva Vault - Run VQL query action

The Run VQL query action submits a raw Vault Query Language (VQL) query against documents, objects, or system tables in Veeva Vault.

Input

Input fieldDescription
VQL queryEnter the VQL query to run.
Include query describe metadataSelect Yes or No to set the X-VaultAPI-DescribeQuery: true header on the request. Defaults to No.
Record propertiesSelect All, Hidden, Redacted, or Weblink to indicate how to apply the X-VaultAPI-RecordProperties header. Omit to skip the header.
Record schemaOptional. Enter the schema for the records returned by the query. Define fields to expose them as typed datapills downstream. Leave blank to return the records as raw JSON objects.

Output

Output fieldDescription
TotalThe total number of records matching the query.
SizeThe number of records returned.
Page sizeThe page size used for this query.
Page offsetThe page offset used for this query.
Next pageThe URL to fetch the next page of results, if any.
Previous pageThe URL to fetch the previous page of results, if any.
RecordsAn array of records. If you defined a Record schema, each record has the fields you defined. Otherwise, each record is returned as raw JSON.

Last updated: