Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Reference: WQL Result Limits

Reference: WQL Result Limits

WQL Result Limits

WQL queries return a maximum of 1 million rows. Both tenanted hosts and the Workday Cloud Platform (WCP) API Gateway (api.workday.com) support WQL requests, with these response timeout limits:
  • Tenanted hosts: 30-minute timeout.
  • WCP API Gateway: 5-minute timeout.
Refer to this table for query and
LIMIT
 clause behavior.
Rows Returned By Query
LIMIT Clause in WQL Query
Query Behavior
>1 million
None
Query fails.
>1 million
<=1 million
Query succeeds and returns a maximum of 1 million rows. You can view 10,000 rows at a time.
<=1 million
None or <=1 million
Query succeeds and returns all rows. You can view 10,000 rows at a time.
Workday reserves the keyword
LIMIT
 for both a clause and a pagination parameter. The LIMIT keyword isn't case-sensitive. We use uppercase and lowercase to help differentiate between clauses and pagination parameters.
  • 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.