---
category: [Administration & Integrations, Platform and Product Extensions, Platform and Product Extensions/Integration, Administration & Integrations/Custom Integrations & Apps, Platform and Product Extensions/Workday Extend]
keyword: [Extend, Workday Query Language, WQL]
nav: wcp_docs
parent_url: /wcp_docs/
title: >- 
  Concept: Pagination of WQL Query Results
layout: subsection
---

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.

<b>Note:</b> WQL caches page limitation requests for only the length of a user session, up to a maximum of 30 minutes.

To view any remaining results, use these parameters:

<table><thead><tr><th>Parameter</th><th>Description</th></tr></thead><tbody><tr><td><code>limit</code></td><td>Specifies the number of rows in 1 page of results. Values must be between zero and 10,000.</td></tr><tr><td><code>offset</code></td><td>Specifies the starting row for the result set. Used by the <code>limit</code> parameter. <p>In the initial request for the first page of results, omit the <code>offset</code> parameter or set it to zero.</p></td></tr></tbody></table><br/>

<b>Note:</b> 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.


## <a id="d459e369"></a>Examples

Depending on where you make WQL requests from, the base URL that you use differs.

<table><thead><tr><th><b>WQL Request Source</b></th><th><b>Base URL to Use</b></th></tr></thead><tbody><tr><td>Workday tenanted host</td><td><code>https://{hostname}/api/wql/{version}/{tenant}</code></td></tr><tr><td>WCP API Gateway</td><td><code>https://api.workday.com/wql/{version}</code></td></tr></tbody></table><br/>

To return 1,000 rows starting with the first row of the result set:

```
{baseURL}/data?limit=1000&offset=0&query=select worker, location from allWorkers
```

To return the next 1,000 rows, increase the offset to 1,000:

```
{baseURL}/data?limit=1000&offset=1000&query=select worker, location from allWorkers
```