activities
latest
false
Integration Service Activities
Last updated Nov 5, 2024

Technical references

This section includes useful information you may require when interacting with Workday REST activities.

Using the Execute WQL Query activity

Important: To use the Execute WQL Query activity, you must configure the System - Workday Query Language scope. For more information, see Workday authentication.
Workday Query Language or WQL is an SQL-like query language that provides enhanced capabilities to query Workday data. Since it resembles SQL, you can manually create queries within Workday or convert an existing report to WQL using the Execute WQL Query activity.

You can convert advanced and matrix reports to Workday Query Language (WQL), then use the resulting query in the Execute WQL Query activity to extract data from Workday.

Use the example below for reference:

  1. In Workday, search for the Convert Report to WQL task.

    docs image

  2. Select the report you want to convert and select the Converted WQL Query String.

    docs image


    docs image

  3. Next, input the copied query in the Execute WQL Query activity and select the Generate output schema button.

    docs image

  4. This action generates a list of output fields.

    docs image

You can also explore Workday tables using the Data sources object and create your own queries. You can access table columns through the Data source fields object, and filterable fields are available in the Data source filters object. For more information, refer to the Workday REST documentation on dataSources.

Important things to consider

  1. You must first generate the output schema of your query results, and then replace any column values with variables afterwards, at design time.

  2. You can use LIMIT and OFFSET parameters to paginate through large sets of data.

  3. You may encounter the following error message if:


    Error message: It seems the provided input is either incorrectly structured or contains a variable.

    1. The System scope is absent from the API client. Check your API client's Scopes (Functional Area).

    2. Your query is incorrect or contains variables. Make sure you successfully run the View WQL Query Result task in Workday and use the correct query in the Execute WQL Query activity.


      docs image

HTTP Request

You can use the HTTP Request activity to call any Workday REST API, as long as you assign the required permissions to the API client used. For more information, see the Workday REST connector Authentication guide.

  • Using the Execute WQL Query activity
  • HTTP Request

Was this page helpful?

Support and Services
Get The Help You Need
UiPath Academy
Learning RPA - Automation Courses
UiPath Forum
UiPath Community Forum
Uipath Logo White
Trust and Security
Terms of Use
Privacy Policy
Cookies Policy
© 2005-2024 UiPath. All rights reserved.