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
To use WQL from an external system you need 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 or Orchestration 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
Integration developers with security access to the
Manage: All Custom Reports
domain in the System functional area 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. The report uses the WQL/RaaS Usage Metrics
report data source.You can only view report results in your Production tenant.