---
title: "Workday RaaS vs WQL vs REST API: which to use, with limits"
description: "RaaS, WQL or REST for Workday data extraction, with a decision table of row limits, page sizes and timeouts, each tied to Workday documentation."
url: https://kiweely.com/guides/workday-raas-wql-rest
---

# Should I use RaaS, WQL or the REST API to extract data from Workday?

Use RaaS for a saved report’s output, WQL for a filtered, grouped or paged extract of up to 1 million rows, and REST for small, low-latency reads of one resource. Limits and sources are in the table.

-   **Checked** against Workday on November 19
-   Applies to **Workday RaaS, WQL, REST and SOAP APIs**
-   7 min read
-   Published September 22
-   By Kiweely

Use RaaS when you need the output of a report that already exists, as CSV, JSON or XML. Use WQL when you need a filtered, grouped or paged extract straight from a data source, up to 1 million rows. Use a REST API when an app needs a small, fast read or write against one known resource.

**Kiweely Vine** is a desktop AI agent for Workday consultants and developers (Mac and Windows) that does the Workday work in the tenant you connect: it builds the report or the query and runs it in your tenant. See how it works below.

All three run under the calling account’s Workday security. None of them returns data the account cannot see.

## RaaS, WQL or REST: which has which limit?

|  | RaaS | WQL (REST `/data`) | Workday REST resource APIs |
| --- | --- | --- | --- |
| Rows per extract | Up to 1 million | Up to 1 million | Not for bulk; page with `limit` and `offset` |
| Page size | No pagination | `limit` 0 to 10,000 | Default 20, maximum 100; 1000 on some endpoints |
| Timeout, tenanted host | 6 hours | 30 minutes | Not stated in the pagination or fundamentals pages |
| Timeout, gateway (`api.workday.com`) | 5 minutes | 5 minutes | Not stated in the pagination or fundamentals pages |
| Group and aggregate | No | Yes, `GROUP BY` | No |
| Output formats | CSV, GData, JSON, RSS, Simple XML, Workday XML | JSON | JSON |
| Transport | REST and SOAP | REST | REST |
| Definition kept and audited in Workday | Yes | No, the query is text you own | No |
| Same request in another tenant | Report must be migrated | Change the URL | Change the URL |
| Fields from a Global business object | Yes | No | Per endpoint |
| Securing permission | Report’s data source and fields | Workday Query Language domain, System functional area, plus the fields | Report/Task permissions on the endpoint’s domain |

Sources: the first nine rows for RaaS and WQL come from [Reference: WQL and RaaS Comparisons](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/workday-query-language-wql-/jvv1659563380308.html) and [WQL Result Limits](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/workday-query-language-wql-/future--reference--wql-result-limits.html). REST page sizes come from [Workday REST API Pagination](https://developer.workday.com/documentation/lvb1611857200890/ConceptWorkdayRESTAPIPagination). REST security comes from [Workday REST API security](https://developer.workday.com/documentation/dan1370797986071/ConceptWorkdayRESTAPISecurity).

## What does Workday say REST is for?

Workday’s integration guidance favours SOAP for large, scheduled system-to-system transfers. It recommends REST for low-latency requests with small amounts of data and says not to use it for bulk data export or import ([REST APIs in Apps and Integrations](https://developer.workday.com/documentation/GUID-6b063b57-9d85-474b-99b0-734d714652fd-enHYPHENus/RESTAPIsinAppsandIntegrations)).

Workday gives no row ceiling for SOAP in these pages, so this guide states none.

A REST collection endpoint returns `total` in each response, so a caller knows how many pages remain. Pages come back in ascending instance ID order unless the endpoint defines a sort.

## What is the real page limit on a REST API?

The documented default `limit` is 20 and the documented maximum is 100, with an override to 1000 on some endpoints and on nested prompt endpoints. The override is per endpoint, so the limit you can use depends on which one you call.

Workday enforces it with an error. The User Activity Logging endpoint is one that overrides the maximum. Asked for `limit=1001` in the Development tenant, it answered HTTP 400:

```
invalid request: limit parameter invalid: must be between 1 and 1000
```

The tenant call confirms an endpoint-specific maximum of 1000 for that endpoint only. It does not prove the 100 maximum on a worker endpoint: the test client’s scopes did not cover the worker endpoint, which answered `permission denied`.

## What is the real page limit on WQL?

WQL accepts `limit` from 0 to 10,000 per page. Ask for one more and Workday refuses the request. In the Development tenant, `GET .../data?limit=10001&query=SELECT workdayID FROM allWorkers` returned HTTP 500:

```
Error on report query: Limit parameter must be in between 0 and 10000
```

The same query with `limit=10000` returned HTTP 200 and a `total` for the full result.

Four other WQL numbers matter when you design an extract:

-   The `LIMIT` clause caps the whole result. The `limit` parameter sets the page size. They are different things.
-   A query that would return more than 1 million rows and has no `LIMIT` fails.
-   Workday caches a paged result for the user session, up to 30 minutes, and clears the cache after 30 minutes.
-   `GET /data` is for queries under 2,048 characters; `POST /data` takes queries between 2,048 and 16,000 characters in the request body.

The View WQL Query Result report in the tenant shows at most 500 rows. That is a display limit of the report, not of WQL. See [getting more than 500 rows from WQL](https://kiweely.com/guides/wql-more-than-500-rows).

## What does a RaaS call look like?

You enable an advanced or search report as a web service, then call its URL. Workday builds the URL from the tenant, the report owner, the report name with underscores for spaces, and each prompt:

```
https://<host>/ccx/service/customreport2/<tenant>/<owner>/Organization_Headcount?Organization%21WID=<wid>&Include_Subordinate_Organizations=1&format=json
```

Workday’s own example is `Organization_Headcount`, owned by `lmcneil`, in a tenant called `gms`. Read the report’s Prompts tab for the exact parameter names. Valid `format` values are `csv`, `gdata`, `json`, `rss` and `simplexml`; add `&bom=true` to a UTF-8 CSV so Excel reads the characters correctly. The owner’s username must not contain a backslash, or the GET fails ([Concept: Reports as a Service](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/reports-as-a-service-raas-/dan1370796320263.html)).

Copy a standard report to a custom report before enabling it. Workday can change a standard report, and the change would reach every integration that calls it.

## Worked example: headcount by supervisory organization

Task: a nightly file of headcount per supervisory organization for a payroll partner, and a dashboard that needs the same numbers on demand.

For the dashboard, a WQL query returns a few rows however large the tenant is:

```
SELECT supervisoryOrganization, COUNT()
FROM allWorkers
GROUP BY supervisoryOrganization
```

For the nightly file, build `Organization_Headcount` as an advanced report, enable it as a web service and fetch it as `format=csv`. The partner gets a stable, named definition that shows up in Workday’s audit history. WQL cannot give you that audit trail, because a query is just text held by the caller.

If the same extract must also run in a second tenant, the WQL version needs only a new URL. The RaaS version needs the report migrated first.

## When should I choose each one?

-   Choose RaaS when the report already exists or needs Report Writer features such as Global business object fields or percentiles, or when you want the definition audited inside Workday. Use it for small to moderate extracts that one response can carry.
-   Choose WQL for grouped counts, paged extracts, programmatic discovery of data sources and fields, and anything you want to change without signing in to Workday. Workday’s Convert Report to WQL report turns advanced and matrix reports into WQL.
-   Choose a REST resource API for an app that reads or writes one resource and wants Workday’s versioned contract for it.
-   Choose SOAP when the operation or field is not on the REST catalog. Workday’s guidance prefers it for large scheduled transfers.

For delivery on a schedule, an outbound Enterprise Interface Builder wraps a report with scheduling and delivery; see [Workday Data Cloud vs EIB, RaaS and Prism](https://kiweely.com/guides/workday-data-cloud-vs-eib-raas-prism) for that choice.

## What do I need before any of them works?

Each call needs an account with the right security. A REST resource needs Report/Task permissions on its domain, View for GET and Modify for writes, whether the caller is a person or an integration system user. WQL needs the Workday Query Language domain in the System functional area and access to the fields queried. Setup of the user, client and token is in [setting up an integration system user and API client](https://kiweely.com/guides/workday-integration-system-user-api-client).

## Where Kiweely fits

**Kiweely Vine** is a desktop AI agent for Workday consultants and developers (Mac and Windows) that does the Workday work in the tenant you connect. It builds custom reports and WQL queries in your tenant from a plain business question.

In a recorded run in Kiweely’s own Workday Development tenant (with fictional sample data, not a customer result), Vine built a custom report from a plain business question (who works in a supervisory organization and its teams, with years of service and counts), ran it and checked it: **3 of 3 checks passed**, 38 minutes from the question to the checked report. The first result wrongly included an outside manager; Vine corrected it and reran it for a second organization ([watch the film](https://youtu.be/6CQCmhRAtWI)).

Vine Free is $0 on a personal developer tenant with $5 of Kiweely Credits included, and Vine Personal ($99/month) and Vine Team ($149/seat/month) connect to any Workday tenant ([pricing](https://kiweely.com/pricing)). [Start free](https://kiweely.com/download).

## Frequently asked questions

### What is the row limit for RaaS and WQL?

Workday lists up to 1 million rows for both. WQL hands the result back in pages of up to 10,000 rows; RaaS has no pagination, so the whole result arrives in one response.

### How long can a RaaS or WQL request run before Workday cuts it off?

From a tenanted host, a WQL request times out at 30 minutes and a RaaS request at 6 hours. Through the Workday Cloud Platform gateway (api.workday.com) both time out at 5 minutes.

### What is the largest page I can ask for from a Workday REST API?

The default limit is 20 and the maximum is 100. Some endpoints override the maximum with 1000, so read the limit on the endpoint you call.

### Can I run the same RaaS report in another tenant?

Not directly. A RaaS report is a report definition that lives in one tenant, so it must be migrated to the other tenant first. A WQL query is plain text, so you point the same request at the other tenant's URL.

## Sources checked

-   [Reference: WQL and RaaS Comparisons](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/workday-query-language-wql-/jvv1659563380308.html)
-   [Reference: WQL Result Limits](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/workday-query-language-wql-/future--reference--wql-result-limits.html)
-   [Concept: Pagination of WQL Query Results](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/workday-query-language-wql-/sfx1612553126122.html)
-   [Reference: WQL REST API](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/workday-query-language-wql-/srr1614364076622.html)
-   [Concept: Reports as a Service (RaaS)](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/reports-as-a-service-raas-/dan1370796320263.html)
-   [Concept: Accessing RaaS Output](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/reports-as-a-service-raas-/dan1370797813643.html)
-   [Concept: Workday REST API Pagination](https://developer.workday.com/documentation/lvb1611857200890/ConceptWorkdayRESTAPIPagination)
-   [REST APIs in Apps and Integrations](https://developer.workday.com/documentation/GUID-6b063b57-9d85-474b-99b0-734d714652fd-enHYPHENus/RESTAPIsinAppsandIntegrations)
-   [Workday REST API security](https://developer.workday.com/documentation/dan1370797986071/ConceptWorkdayRESTAPISecurity)

## Related guides

[All guides](https://kiweely.com/guides)

-   [### How to Set Up Workday RaaS: Turn a Custom Report into a Web Service, Step by Step To set up Workday Reports as a Service, make an advanced or search report, select Enable As Web Service, then copy the URL from Web Services > View URLs. Prompts, formats, security and common failures.](https://kiweely.com/guides/workday-raas-setup)
-   [### How do I set up an integration system user and API client in Workday so an external app can authenticate? Create the ISU, put it in an Integration System Security Group, grant domain permissions and activate them, register the client for integrations, then generate its refresh token and pick the ISU as the Workday account.](https://kiweely.com/guides/workday-integration-system-user-api-client)
-   [### What is Workday Query Language (WQL), and how do you write and run a query? Workday Query Language (WQL) is Workday’s SQL-like language for reading data from data sources and fields instead of reports. You need the Workday Query Language domain in the System functional area; an external caller also needs an API client with System scope.](https://kiweely.com/guides/workday-wql)
-   [### How do I get more than 500 rows from a Workday WQL query? The 500-row stop belongs to the View WQL Query Result report. The WQL REST API returns up to 10,000 rows per page: pass limit (0 to 10,000) and offset. A worked run pages 48,491 rows in five calls, with Workday’s exact errors for a limit above 10,000 and an offset past the end.](https://kiweely.com/guides/wql-more-than-500-rows)

### More guides on WQL

[All 31 guides](https://kiweely.com/guides#wql)

-   [Why does my Workday WQL query fail? The exact error messages and how to fix each one](https://kiweely.com/guides/wql-error-messages)
-   [Why does WQL return 403 permission denied S22 for an ISU?](https://kiweely.com/guides/workday-wql-403-s22-as-isu)
-   [Why does Convert Report to WQL break after a field rename?](https://kiweely.com/guides/workday-convert-report-to-wql-after-field-rename)
-   [Why does Convert Report to WQL say this field is missing an adhoc alias?](https://kiweely.com/guides/convert-report-to-wql-adhoc-alias)
-   [How do I build a Workday integration inventory report with every integration system, its template, schedule, last run and owner?](https://kiweely.com/guides/workday-integration-inventory-report-wql)
-   [Retrieving Eligible Absence Plans and Live Balances for a Worker via Workday APIs](https://kiweely.com/guides/workday-absence-balances-api-eligible-plans-for-worker)
-   [Querying the Workday Worker Directory, Supervisory Hierarchy, and Cost Centers with WQL](https://kiweely.com/guides/workday-worker-directory-org-chart-search-fields-wql)
-   [Querying Open Job Requisitions and Supervisory Org Headcount via Workday Staffing APIs](https://kiweely.com/guides/workday-staffing-api-job-requisitions-open-positions-managers)

### From the blog on WQL

[All posts](https://kiweely.com/blog)

-   [Build vs. Buy a Workday MCP Server: OAuth 2.1, SOAP, WQL, and Twice-Yearly Releases](https://kiweely.com/blog/build-vs-buy-workday-mcp-server-engineering-cost)
-   [What happens after ChatGPT writes your WQL query](https://kiweely.com/blog/after-chatgpt-writes-your-wql)
-   [Answering Executive Span-of-Control and Headcount Questions Live from Workday](https://kiweely.com/blog/executive-org-span-of-control-attrition-questions-live-workday)

## Let Workday check the work.

Kiweely writes WQL and builds orchestrations in your own tenant, and Workday, not Kiweely, says whether they passed.

[Start for free](https://kiweely.com/download) [See how it works](https://kiweely.com/vine/how-it-works)

## Get the next guide in your inbox.

One email a month with new guides and one Extend tip. Nothing else.
