Concept: Workday Query Language (WQL)
Workday Query Language (WQL) enables you to use SQL-like syntax to access Workday data
using data sources and fields instead of reports. WQL enables you to query Workday for
data and explore:
- Data sources.
- Data source filters.
- Fields.
Enabling WQL
WQL requires you to register an API client for your tenant. Register it in
your tenant using the
Register API Client for Integrations
task. You don't have to register an API client when you're using WQL in a Workday
Extend app.When you register the API client for WQL, select
System
from the
Scope (Functional Areas)
prompt.When you manage the refresh token, select a Workday account that has access to
execute reports. The API calls use this account.
Security
To use WQL, you need access to the
Workday Query Language
domain in
the System functional area. You can only view and use data sources and fields that
you have security access to within a WQL query.WQL and RaaS Usage Metrics Report
You can use this report to monitor usage trends for API requests over time. The
report displays WQL and Reports as a Service (RaaS) executions for outbound
integrations. It returns counts for a rolling 90 days by dimensions, such as time
and source of request.
You can only view report results in your
Production tenant.