Question:
When users do the VQL query on the Workflows object using API, only 1000 records are returned in the response.
q=select task_assignee__v from workflows
Unlike other objects (shown below), there is no next_page link when querying the Workflows object.
Since the maximum number of results displayed per page is 1000 by default, is there a way to acquire all the records?
Answer:
Generally, users can use the PAGESIZE clause to limit the number of results returned per page and use the PAGEOFFSET clause to display the next and previous pages of results.
The Workflows query target is considered legacy and does not support pagination via next_page. Instead, PAGESIZE and PAGEOFFSET must be used in the query itself:
SELECT workflow_id__v FROM workflows PAGESIZE 1000 PAGEOFFSET 0
SELECT workflow_id__v FROM workflows PAGESIZE 1000 PAGEOFFSET 1000
SELECT workflow_id__v FROM workflows PAGESIZE 1000 PAGEOFFSET 2000
Note: This method is only used when next_page is not provided because it requires querying all the data and does not perform as well.
Related Documentation:
Vault Help Documentation: Submitting a Query