Workday REST (WQL) to JSM Assets

OnLink allows you to import data using WQL (Workday Query Language) as an alternative to custom reports. Any WQL can be used as a data source.

To use this option, Workday provides REST API - different from SOAP and RaaS connections. To configure a Workday REST API Client, follow the instructions here - https://workday.my.site.com/customercenter/article?no=000013105. At a high level, here are the steps you need to take within your Workday tenant.

Create an Integration System User
Register API Client for Integrations
Add relevant security groups to int sys user
Ensure Workday Query Language security group permission is given to int sys user

Once above is complete you need to configure a Workday REST connection in OnLink. To do this, go to Connections tab, click on Add System and select “Other Asset Sources”, then select system “Workday REST”. Here you need to provide the below information - OAuth Token URL, Client ID, Client Secret and Refresh Token in the Connection Attribute field. Once saved, please use More - Test menu item to ensure connection is successful.

Follow instructions for setting up a new Assets Import. Here are additional config items you will need to configure:

Key or Map	Description

Key or Map

Description

config:api

Set to the WQL API - for example, this to below for most worker WQLs.

config:api=ccx/api/wql/v1/<your_tenant_name>/data

config:data_source

Set to the WQL Query - for example:

config:data_source=SELECT employeeID as id, firstName as fn, lastName as ln FROM indexedAllWorkers (dataSourceFilter = indexedAllWorkersFilter, includeSubordinateOrganizations = false, isActive = false)

Use instructions here to convert your custom report to WQL.

config:max_loops=1

Optional parameter to limit the number of users to pull from Workday. This can be used for initial testing.

OnLink Documentation

Workday REST (WQL) to JSM Assets

Related content