Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Feature

Description

Mapping fields for Workday system triggers

When using Workday system trigger, users can select which fields to pull from the system when creating the Trigger issue. The format for the Workday Mapping Configuration is:

key:Worker_ID=customfield_10121

map:First_Name=customfield_10122

map:Last_Name=customfield_10123

map:Start_Date=customfield_10124

The “key” prefix identifies the ID field (Worker_ID, EmployeeID, CandidateID). This is also used to run a duplicate check and ensure that a new hire workflow is not triggered for the same employee twice. Only one key should be specified.

Apart from simple fields (string, date, number), OnRamp also supports complex fields like Single Select and User Select. Add the type after the “|” delimiter. This will create the fields in the specific type when creating the Trigger issue.

map:First_Name=customfield_10159|single_select

map:Email_Address=customfield_10158|user_select

map:Business_Site_Summary_Data/Country_Region_Reference/ID[Country_Region_ID]=customfield_10123 (specify complex mapping)

Workday supports Integration Field Overrides to pull custom fields from their API. To configure field overrides, set up the below parameters:

fo_intsys:workday_intsys_id (the Integration System ID of the integration in Workday that has the field overrides)

map:Integration_Field_Override_Data[manager_name]=customfield_10122 (retrieve calculated fields in API response, where manager_name is the name of the field. Note - only string, number or date fields are supported for field override values so any single/multi-instance fields will need to first be transformed.)

To configure Field Overrides in Workday, follow these steps:

  1. Create an integration system (can be of type generic) in Workday. Capture the Integration System ID.

  2. Add a field override service to this integration system. Add a field for every custom field you want to capture.

  3. Make sure your Integration System User has access to those calculated fields.

Max records that can be processed in each scheduled run is 100. If you need to process more than 100, please use Workday Custom Report trigger that has a limit of 500.

Mapping fields for Workday Custom Report trigger

OnRamp supports pulling data from Workday Custom Reports that are exposed as RaaS web services. To get the custom report URL in your tenant, go to View URLs Web Service action on your report, in the JSON section, right-click JSON, then Copy URL. The URL format will be something like below:

https://wd2-impl-services1.workday.com/ccx/service/customreport2/mytenant/reportuser/reportname?format=json&Last_Updated=2023-10-01&Department=Sales

Use the above highlighted information in the trigger mapping configuration field. The reportuser and reportname combination should be provided in the “report_name” property. Filter values can also be setup as shown below.

Code Block
report_name:reportuser/reportname
filter:Last_Updated={last_successful_date_time}
filter:Department=Sales
key:WorkerID=customfield_10128
map:Worker=customfield_10122
map:Title=customfield_10123
map:Cost_Center[0].Reference_ID=customfield_10010

For more information see Workday Custom Report

If your mappings are different for updates and insert flows then use these two configurations: update_for_flow and disable_updates. Set update_for_flow to the name of the flow used for inserts.

Max records that can be processed in each scheduled run is 500.

Mapping fields for Greenhouse system triggers

OnRamp pulls all recent applications that are in a status of Hired. It then pulls the candidates associated with those hired applicants. You can specify fields from the Candidate object to be mapped. Here is the example mapping configuration for Greenhouse.

key:id=customfield_10121
map:first_name=customfield_10122
map:last_name=customfield_10123
map:title=customfield_10133
map:company=customfield_10132
map:email_address=customfield_10085
map:phone_number=customfield_10086
map:job_name=customfield_10134 (job_name pulls the name of the job on the application with status=hired)

All other Greenhouse API fields can be pulled too. Here are a few examples:

map:addresses[0].value=customfield_10063
map:phone_numbers[0].value=customfield_10064
map:email_addresses[0].value=customfield_10065
map:applications[0].prospective_department=customfield_10066
map:applications[0].jobs[0].custom_fields.employment_type=customfield_10070
map:applications[0].jobs[0].keyed_custom_fields.employment_type.value=customfield_10071

Since OnRamp pulls only hired candidates, it expects only one application and one job tied to the hired candidate.

Max records that can be processed in each scheduled run is 250.

Mapping fields for Personio system triggers

See this link for connecting to Personio. OnRamp supports both hires and terminations triggers from Personio. Choose the appropriate trigger when configuring your flow.

image-20240116-183600.png

Here is the example mapping configuration for Personio.

image-20240116-183356.png

Mapping configuration:

key:id=customfield_10121
map:first_name=customfield_10122
map:last_name=customfield_10123
map:email=customfield_10085
map:position=customfield_10134

Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse