Veeva Vault - Search records action

The Search records action searches records, such as products, in Veeva Vault. The action uses a Vault Query Language (VQL) query to run the search.

Input

Input fieldDescription
ObjectSelect the Vault object. For example, Product. This list is populated dynamically from your Vault.
Fields to retrieveSelect one or more fields to include in the VQL SELECT. Defaults to id, name__v when left blank.
WHERE clauseEnter a VQL WHERE clause, without the WHERE keyword.
ORDER BY clauseEnter a VQL ORDER BY clause, without the ORDER BY keyword.
Page sizeNumber of records per page. Defaults to 200, with a maximum of 1000.
Page tokenTo fetch the next or previous page, map the Next page token or Previous page token from a prior call. All other inputs are ignored when provided.

Output

Output fieldDescription
Total recordsThe total number of records matching the query.
Records on this pageThe number of records returned on this page.
Page sizeThe page size used for this query.
Next page tokenMap this into Page token on a subsequent call to fetch the next page.
Previous page tokenMap this into Page token on a subsequent call to fetch the previous page.
RecordsAn array of records for the selected object. Output fields are dynamically generated based on the object you select. Refer to the Veeva Vault documentation for more information.

Last updated: