---
title: "Turn Existing Workday RaaS Reports into AI Tools — Kiweely"
description: "Reuse your vetted Workday custom reports and calculated fields in Claude, ChatGPT, and Gemini by exposing them as RaaS under user-delegated OAuth."
url: https://kiweely.com/blog/exposing-existing-workday-raas-reports-to-claude-and-chatgpt
---

# Turning Your Existing Workday RaaS Reports into Governed AI Tools

HRIS teams spend years perfecting Workday custom reports, calculated fields, and subfilters. Exposing those vetted reports as web services (RaaS) under user-delegated OAuth lets Claude, ChatGPT, and Gemini answer complex tenant-specific questions without rebuilding logic.

-   By Kiweely
-   November 15
-   5 min read

Your HRIS team has already built, audited, and reconciled the custom Workday reports that define how your company counts headcount, attrition, open requisitions, and budget variance. Instead of recreating years of [Workday calculated fields](https://kiweely.com/guides/workday-calculated-fields) from scratch for AI assistants, enabling selected advanced reports as **Reports as a Service (RaaS)** under user-delegated OAuth turns them into live, governed tools inside Claude, ChatGPT, and Gemini.

## Why Raw REST Endpoints Alone Miss Your Real Business Definitions

Out-of-the-box Workday REST endpoints (`/staffing/v7`, `/common/v1`) return raw Workday objects, not your company’s agreed operational definitions. Ask two executives *“What is our active billable headcount in North America?”* and the real answer in your tenant almost certainly depends on custom report logic your HRIS and Finance teams aligned on years ago:

-   Excluding contingent workers in specific vendor types, interns, and workers on long-term unpaid leave via custom **Filter** and **Subfilter** rules.
-   Resolving multi-level cost-center rollups through `Lookup Hierarchy Rollup` or `Lookup Related Value` calculated fields.
-   Pulling contextual constants from a **Global** business object or computing **percentile** bands—two capabilities Workday supports in RaaS custom reports that [WQL explicitly does not support](https://kiweely.com/guides/workday-raas-wql-rest).
-   Maintaining a persisted, audited report definition in Workday so Finance knows nobody silently rewrote the headcount formula inside an AI prompt.

When an AI connector can only call preset self-service skills or generic REST endpoints, every answer diverges slightly from the numbers on the CFO’s Monday dashboard. Exposing the exact custom report as a governed RaaS tool guarantees identical numbers.

## WQL vs. RaaS for AI Tool Calls: Choosing the Right Tool per Prompt

As Workday’s *Reference: WQL and RaaS Comparisons* documents, WQL and RaaS complement each other rather than competing:

| Capability | Live Workday WQL | Custom Report via RaaS (`?format=json`) |
| --- | --- | --- |
|  **Ad-hoc `GROUP BY` dimensions** | Yes (`SELECT location, count(worker) ... GROUP BY`) | Not supported dynamically (requires matrix/summary report definition) |
|  **Result pagination (`LIMIT` / `OFFSET`)** | Yes (paginate up to 10,000 rows per page) | Not supported (returns full filtered extract; narrow via prompts) |
|  **Global business object fields & percentiles** | Not supported | Supported natively |
|  **Workday report definition audit trail** | Query string lives outside Workday | Persisted and audited inside Workday’s audit framework |
|  **Tenant-to-tenant portability** | Works across tenants without migrating a report | Report must exist (or be migrated via Object Transporter) in target tenant |
|  **Issuing-user security enforcement** | Honors object and data-level security of token owner | Honors report sharing + constrained org/field security of token owner |

The best AI architecture uses **both**: WQL for flexible ad-hoc exploration and pagination, and RaaS for curated, calculation-heavy institutional reports.

## How to Prepare a Custom Report for Safe User-Delegated AI Access

Turning an existing Workday advanced or search report into an AI-ready RaaS endpoint takes five deliberate checks in **Edit Custom Report** (secured by the `Custom Report Creation` or `Manage: All Custom Reports` domains in the `System` functional area):

### 1\. Enable Web Service Output on the Advanced Tab

Open the report in `Edit Custom Report`, switch to the **Advanced** tab, and scroll to **Web Services Options**:

-   Check **Enable As Web Service**.
-   Review the generated **Namespace** and keep it stable (changing a RaaS Namespace later breaks callers until refreshed).
-   Keep **Optimized for Performance** checked on indexed data sources wherever non-indexed fields are unnecessary so interactive AI prompts return in milliseconds.

### 2\. Add Targeted Prompts to Bound Payload Size

Because RaaS does not paginate with `LIMIT` and `OFFSET`, never expose an unprompted 50,000-row transaction dump to an LLM context window. On the **Prompts** tab, expose clean filter parameters—such as `Supervisory_Organization`, `Effective_Date`, `Location`, or `Include_Subordinate_Organizations`—and verify each **Label for Prompt XML Alias**.

When invoked as REST JSON, Workday binds single-instance WIDs using `%21WID=` (`!WID=`):

Works

```
GET /ccx/service/customreport2/{tenant}/{owner}/Organization_Headcount?Organization%21WID=cb550da820584750aae8f807882fa79a&Include_Subordinate_Organizations=1&format=json HTTP/1.1
Authorization: Bearer <user_delegated_oauth_token>
```

### 3\. Share the Report with Authorized Constrained Security Groups

Custom reports are private to their owner by default. On the **Share** tab, select **Share with specific authorized groups and users** (for example, `Manager`, `HR Partner`, and `Cost Center Manager`).

Remember Workday’s report-sharing rule from *Security for Administrators*: a security group can only be selected on the Share tab if that group holds domain permissions for **both** the report’s **Data Source** and **Data Source Filter**.

### 4\. Never Call Employee-Facing RaaS Tools Through an ISU

In outbound EIBs or batch data-warehouse pipelines, teams run RaaS URLs under an Integration System User (`ISU`). If you wire an AI assistant to an `ISU`, a line manager asking a question could receive rows from every department unless you reinvent Workday’s entire security model outside Workday.

Instead, authenticate the MCP connector via [Register API Client](https://kiweely.com/guides/workday-register-api-client-vs-api-client-for-integrations) using **Authorization Code Grant with PKCE**. Look at what Workday does automatically when two different employees run the *exact same* RaaS report with their own OAuth tokens:

-   **Constrained `Manager` persona:** Workday returns only the rows inside their assigned Supervisory Organization (for example, 8 direct reports) and omits columns whose security domains the manager lacks (such as `National_ID` or `Emergency_Contacts`) or restricts self-only constrained fields.
-   **Unconstrained `HR Partner` or `Controller` persona:** Workday returns all 450 authorized organization rows—while your MCP governance layer can still strip sensitive PII fields in RAM before passing the JSON summary to Claude or ChatGPT.

### 5\. Watch Filter-Field Security Errors

One classic Workday RaaS pitfall catches teams during rollout: if a custom report’s **Filter** or **Subfilter** tab evaluates a report field that a `Manager` security group has zero domain access to, Workday throws a field-access error when that manager runs the report—even if that field is not on the **Columns** tab! Always test shared RaaS reports across real constrained roles before publishing them to your workforce.

## Publishing RaaS Reports to Claude, ChatGPT, and Gemini with Kiweely Bridge

[Kiweely Bridge](https://kiweely.com/bridge), which is coming next, turns your existing web-service-enabled Workday custom reports into first-class MCP tools alongside Workday REST, live WQL, and SOAP reads:

-   **Zero code wrappers:** Admins pick which RaaS reports to publish in the Bridge policy; the AI admin agent inspects prompt XML aliases, data source permissions, and output columns in Sandbox automatically.
-   **Per-employee OAuth + RAM field redaction:** Every RaaS execution runs under the signed-in employee’s sealed AES-256-GCM Workday token, strips admin-blocked columns in memory, and writes zero report rows to disk or logs (see [Bridge security](https://kiweely.com/bridge/security)).
-   **Role-boundary verification before go-live:** Test how each RaaS tool responds as an Employee, Manager, and HR Partner in Sandbox—catching missing data source filter permissions or filter-field errors before any employee asks in Claude, ChatGPT, or Gemini.
-   **Flat company pricing:** Included with unlimited calls across Production and all Sandbox tenants ($499/mo up to 1,000 employees, $1,499/mo for 1,001–5,000, $3,999/mo for 5,001–20,000, or free for one person on a personal Workday developer tenant). And if you want those same RaaS reports rendered as clean visual dashboards or mobile portals rather than chat answers, [Kiweely Leaf](https://kiweely.com/leaf) (coming next) builds pass-through screens on them without a Workday Extend license.

## Frequently asked questions

### Does enabling a Workday custom report as a web service (RaaS) make it public?

No. Workday restricts external RaaS links strictly to authenticated tenant users who hold both report sharing access and domain permissions for the underlying data source, data source filter, and report fields.

### When should an AI connector call a RaaS report instead of WQL?

Use RaaS when the answer depends on Global business object fields, percentile aggregations, audited persisted report definitions, or multi-layered calculated fields and subfilters your HRIS team has already validated with Finance and HR.

### Why shouldn't RaaS reports for AI chat run under an Integration System User?

Running RaaS as an Integration System User returns unconstrained company-wide rows. Calling RaaS with each employee's user-delegated OAuth token ensures a constrained Manager sees only their own Supervisory Organization's rows and permitted columns.

## Read next

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

-   [November 15 ### Embedding Live Workday Time Off, Pay, and Approvals Inside DingTalk, Feishu, and Lark](https://kiweely.com/blog/embedding-workday-self-service-inside-dingtalk-feishu-lark)
-   [November 15 ### Connecting ChatGPT Enterprise and Team to Workday Without a Shared Service Account](https://kiweely.com/blog/connect-chatgpt-enterprise-to-workday-mcp-without-isu)
-   [November 13 ### Same Report, Different Rows: Why a Workday Custom Report Changes Output When Enabled as RaaS](https://kiweely.com/blog/why-workday-reports-differ-between-run-and-raas)

### More guides on Integrations and APIs

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

-   [Object Transporter or Configuration Change Tracker: which moves Workday config?](https://kiweely.com/guides/workday-object-transporter-vs-configuration-change-tracker)
-   [EIB spreadsheet mapping when an AI assistant drafts the load](https://kiweely.com/guides/ai-workday-eib-mapping-for-consultants)
-   [Custom reports and RaaS when an AI assistant is helping you build them](https://kiweely.com/guides/ai-workday-custom-reports-raas-for-consultants)
-   [Run Workday Studio AUnit Before You Accept AI Edits](https://kiweely.com/guides/workday-studio-aunit-before-ai-edits)
-   [What AI tools can a Workday consultant use to build reports, calculated fields and EIB loads faster?](https://kiweely.com/guides/ai-tools-for-workday-reports-calculated-fields-eib)
-   [Which Workday Integrations May Auto-Remediate](https://kiweely.com/guides/which-workday-integrations-may-auto-remediate)
-   [An Integration Run Book Assistants Can Query](https://kiweely.com/guides/workday-integration-run-book-for-assistants)
-   [When Workday Integrations Should Leave the Tenant](https://kiweely.com/guides/when-workday-integrations-leave-the-tenant)

## Your Workday work, done by AI.

Kiweely Vine is the AI agent that builds, deploys and tests Extend apps as real people, makes changes in any Workday task screen, answers from your real tenant and builds reports.

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

## Get the next one in your inbox.

One email a month for Workday teams: what’s changing in Workday and what to retest, one tip tried in a real tenant, and what’s new at Kiweely.
