---
category: [Administration & Integrations, Platform and Product Extensions, Platform and Product Extensions/Integration, Administration & Integrations/Custom Integrations & Apps, Platform and Product Extensions/Workday Extend]
keyword: [Extend, Workday Query Language, WQL]
nav: wcp_docs
parent_url: /wcp_docs/
title: Convert Reports to WQL Queries
layout: subsection
---

### Prerequisites

<a id="d100e285"></a>
Security: <i>Workday Query Language</i> domain in the System functional area.

### Context

<a id="d100e294"></a>
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.

### Steps

1.  <a id="d100e302"></a>Access the <b>Convert Report to WQL</b> report.
2.  <a id="d100e311"></a>Select a report to convert.

    You can only select reports you have access to.

3.  <a id="d100e320"></a>Complete any prompts that the report contains, as required.


### Result

<a id="d100e327"></a>
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 <b>Column Heading Override</b> 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 <b>Group Column Heading</b> 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.

### Next Steps

<a id="d100e345"></a>
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.

### Related Information

[Reference: WQL REST API](/wcp_docs/GUID-5c940864-7651-4e28-a9d2-79b45292e66a-enHYPHENus.html)