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]
