Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Convert Reports to WQL Queries

Convert Reports to WQL Queries

Security:
Workday Query Language
 domain in the System functional area.
You can convert advanced and matrix reports to Workday Query Language (WQL) and use the resulting WQL query in integrations to extract data from Workday.
  1. Access the
    Convert Report to WQL
     report.
  2. Select a report to convert.
    You can only select reports you have access to.
  3. Complete any prompts that the report contains, as required.
Workday displays the WQL query and indicates whether the query is valid. Some report definitions might have configurations that prevent the report from creating a valid WQL query.
When advanced or matrix reports contain values in the
Column Heading Override
 column, Workday includes the value as an alias in the converted WQL query. When a report contains fields from related business objects, Workday uses the value in the
Group Column Heading
 column as the alias in the converted WQL query.
Workday displays a table listing any components of the report that you can't convert to WQL.
Insert the WQL query into the
query
 parameter of the WQL
GET /data
 API call.
When your query exceeds 2,048 characters, insert the query into the request body of the
POST /data
 API call.