Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Workday response

ag420
New Contributor II
New Contributor II

All,

This is a snapshot of the response from workday soap API - 

<wd:Worker_Type_Reference wd:Descriptor="General Service category">
<wd:ID wd:type="WID">66f7f9e77ce410127f87048eb7fc0000</wd:ID>
<wd:ID wd:type="Employee_Type_ID">GS</wd:ID>

and in user mapping this value is mapped as - 

"EMPLOYEETYPE": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference..ID(@type=='Employee_Type_ID')"

This saves GS in the employeetype user type but i want General Service category in the same. How to achieve this?

there are several other such response where i want descriptor value.

 

Many Thanks 🙂

3 REPLIES 3

Raghu
Honored Contributor
Honored Contributor

@ag420  try like below

 

For example:

if exists(Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.Employee_Type_ID) then "Employee"

elseif exists(Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.Contingent_Worker_Type_ID) then "Contingent Worker"


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

ag420
New Contributor II
New Contributor II

this is soap connection, i put this in the user import mapping but job fails now with error in the body -

userimport - 

{
  "ImportType": "SOAP",
  "ResponsePath": "Body.Get_Workers_Response.Response_Data.Worker",
  "ImportMapping": {  
    "EMAIL": "abc@dum",
    "USERNAME": "Worker_Data.User_ID",
    "CUSTOMPROPERTY2": "Worker_Data.Universal_ID",
    "SYSTEMUSERNAME": "Worker_Data.User_ID",
    "FIRSTNAME": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.First_Name",
    "MIDDLENAME": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.Middle_Name",
    "LASTNAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Last_Name",
    "DISPLAYNAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.@Formatted_Name",
    "LOCATION": "Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Municipality",
    "TITLE": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Title",
    "EMPLOYEEID": "Worker_Data.Worker_ID",
    "PREFEREDFIRSTNAME": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.First_Name",
    "PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Phone_Number",
    "CITY": "Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Municipality",
    "STATUSKEY": "Worker_Data.Employment_Data.Worker_Status_Data.Active",
    "CUSTOMPROPERTY1": "Worker_Reference.ID(@type=='WID')",
    "COUNTRY": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Country_Reference.ID(@type=='ISO_3166-1_Alpha-3_Code')",
    if exists(Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.Employee_Type_ID) then "Employee"
 
elseif exists(Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.Contingent_Worker_Type_ID) then "Contingent Worker",
    "COMPANYNAME": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data.Organization_Name",
    "COSTCENTER": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data.Organization_Code",
    "CUSTOMPROPERTY3": "Worker_Data.Worker_Employment_Information_Data.Hire_Date",
"CUSTOMPROPERTY4": "Worker_Data.Worker_Employment_Information_Data.End_Employment_Date",
"CUSTOMPROPERTY5": "Worker_Data.Worker_Employment_Information_Data.Hire_Rescinded",
"CUSTOMPROPERTY6": "Worker_Data.Worker_Employment_Information_Data.Termination_Date",
    "OWNER": "Worker_Data.Worker_Management_Chain_Data.Worker_Supervisory_Management_Chain_Data.Management_Chain_Data.Manager",
"MANAGER":"Worker_Data.Worker_Management_Chain_Data.Worker_Supervisory_Management_Chain_Data.Management_Chain_Data.Manager_Reference"
  }
}
Error - Error in doUsersImport - Unexpected character ('i' (code 105)): was expecting double-quote to start field name at [Source: { "ImportType": "SOAP", "ResponsePath": "Body.Get_Workers_Response.Response_Data.Worker", "ImportMapping": { "EMAIL": "abc@dum", "USERNAME": "Worker_Data.User_ID", "CUSTOMPROPERTY2": "Worker_Data.Universal_ID", "SYSTEMUSERNAME": "Worker_Data.User_ID", "FIRSTNAME": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.First_Name", "MIDDLENAME": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.Middle_Name", "LASTNAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Last_Name", "DISPLAYNAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.@Formatted_Name", "LOCATION": "Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Municipality", "TITLE": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Title", "EMPLOYEEID": "Worker_Data.Worker_ID", "PREFEREDFIRSTNAME": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.First_Name", "PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Phone_Number", "CITY": "Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Municipality", "STATUSKEY": "Worker_Data.Employment_Data.Worker_Status_Data.Active", "CUSTOMPROPERTY1": "Worker_Reference.ID(@type=='WID')", "COUNTRY": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Country_Reference.ID(@type=='ISO_3166-1_Alpha-3_Code')", if exists(Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.Employee_Type_ID) then "Employee" elseif exists(Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.Contingent_Worker_Type_ID) then "Contingent Worker", "COMPANYNAME": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data.Organization_Name", "COSTCENTER": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data.Organization_Code", "CUSTOMPROPERTY3": "Worker_Data.Worker_Employment_Information_Data.Hire_Date", "CUSTOMPROPERTY4": "Worker_Data.Worker_Employment_Information_Data.End_Employment_Date", "CUSTOMPROPERTY5": "Worker_Data.Worker_Employment_Information_Data.Hire_Rescinded", "CUSTOMPROPERTY6": "Worker_Data.Worker_Employment_Information_Data.Termination_Date", "OWNER": "Worker_Data.Worker_Management_Chain_Data.Worker_Supervisory_Management_Chain_Data.Management_Chain_Data.Manager", "MANAGER":"Worker_Data.Worker_Management_Chain_Data.Worker_Supervisory_Management_Chain_Data.Management_Chain_Data.Manager_Reference" } }; line: 22, column: 6]

ag420
New Contributor II
New Contributor II

Any ways of handling this?