技术参考

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.
   
   

   

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

   

   
   
   
   

   

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

   

   
   
4. This action generates a list of output fields.
   
   

   

   
   

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.

需要考虑的重要事项

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:

   
   

   

   
   

   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.

      
      

      

      
      

HTTP 请求

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.