Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Concept: Pagination of WQL Query Results

Concept: Pagination of WQL Query Results

When you first execute a query, the Workday Query Language (WQL) in the query parameter runs and builds a cache that returns a maximum of 10,000 rows. You can access additional rows by paginating through the result set using the
limit
 and
offset
 parameters in the REST API call for your WQL query.
To view any remaining results, use these parameters:
Parameter
Description
limit
Specifies the number of rows in 1 page of results. Values must be between zero and 10,000.
offset
Specifies the starting row for the result set. Used by the
limit
 parameter.
In the initial request for the first page of results, omit the
offset
 parameter or set it to zero.
Workday reserves the keyword
LIMIT
 for both a clause and a pagination parameter. The LIMIT keyword isn't case-sensitive.
  • Use the
    LIMIT
     clause to limit the number of total rows returned in a query response.
  • Use the
    limit
     parameter to specify how many rows to display per page of query response.

Examples

To return 1,000 rows starting with the first row of the result set:
https://{hostname}/ccx/api/wql/v1/{tenant}/data?limit=1000&offset=0&query=select worker, location from allWorkers
To return the next 1,000 rows, increase the offset to 1,000:
https://{hostname}/ccx/api/wql/v1/{tenant}/data?limit=1000&offset=1000&query=select worker, location from allWorkers