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 SOAP connector not importing all users

MahimaMahajan
New Contributor
New Contributor

We are using a Workday SOAP connection and have configured a full user import job. Here is a description of the problem:

  • The full import job is not importing all users from Workday.
  • We have verified specific users which are present in Workday but are missing from the Saviynt import.
  • We are however able to Import these missing users individually using the single employee import filter in HR import json
  • We are also able to retrieve the missing users through Postman, indicating the issue is likely isolated to the full import job.



    Below is the HR import JSON for reference

    {
    "REQUESTXML1": "<soapenv:Envelope xmlns:soapenv=\"xxx/\" xmlns:bsvc=\"urn:com.workday/bsvc\"> <soapenv:Header> <wsse:Security soapenv:mustUnderstand=\"1\" xmlns:wsse=\"xxx\" xmlns:wsu=\"xxx\"> <wsse:UsernameToken wsu:Id=\"UsernameToken-xxx"> <wsse:Username>${USERNAME}</wsse:Username> <wsse:Password Type=\"xxx">${PASSWORD}</wsse:Password> <wsse:Nonce EncodingType=\"xxx</wsse:Nonce></wsse:UsernameToken> </wsse:Security> </soapenv:Header> <soapenv:Body> <bsvc:Get_Workers_Request bsvc:version=\"v40.2\"><bsvc:Request_Criteria> <bsvc:Exclude_Inactive_Workers>false</bsvc:Exclude_Inactive_Workers> <bsvc:Exclude_Employees>false</bsvc:Exclude_Employees> <bsvc:Exclude_Contingent_Workers>false</bsvc:Exclude_Contingent_Workers><bsvc:Field_And_Parameter_Criteria_Data><bsvc:Provider_Reference><bsvc:ID bsvc:type=\"Integration_System_ID\">INT0003CCWFieldoverrides</bsvc:ID></bsvc:Provider_Reference></bsvc:Field_And_Parameter_Criteria_Data></bsvc:Request_Criteria> <bsvc:Response_Filter> <bsvc:Page>${PAGE_NUMBER}</bsvc:Page><bsvc:Count>${PAGE_SIZE}</bsvc:Count> </bsvc:Response_Filter> <bsvc:Response_Group> <bsvc:Include_Reference>true</bsvc:Include_Reference> <bsvc:Include_Personal_Information>true</bsvc:Include_Personal_Information> <bsvc:Include_Additional_Jobs>true</bsvc:Include_Additional_Jobs> <bsvc:Include_Employment_Information>true</bsvc:Include_Employment_Information> <bsvc:Include_Compensation>true</bsvc:Include_Compensation> <bsvc:Include_Organizations>true</bsvc:Include_Organizations> <bsvc:Exclude_Organization_Support_Role_Data>false</bsvc:Exclude_Organization_Support_Role_Data> <bsvc:Exclude_Location_Hierarchies>false</bsvc:Exclude_Location_Hierarchies> <bsvc:Exclude_Cost_Centers>false</bsvc:Exclude_Cost_Centers> <bsvc:Exclude_Cost_Center_Hierarchies>false</bsvc:Exclude_Cost_Center_Hierarchies> <bsvc:Exclude_Companies>false</bsvc:Exclude_Companies> <bsvc:Exclude_Company_Hierarchies>false</bsvc:Exclude_Company_Hierarchies> <bsvc:Exclude_Matrix_Organizations>false</bsvc:Exclude_Matrix_Organizations> <bsvc:Exclude_Pay_Groups>false</bsvc:Exclude_Pay_Groups> <bsvc:Exclude_Regions>false</bsvc:Exclude_Regions> <bsvc:Exclude_Region_Hierarchies>false</bsvc:Exclude_Region_Hierarchies> <bsvc:Exclude_Supervisory_Organizations>false</bsvc:Exclude_Supervisory_Organizations> <bsvc:Exclude_Teams>false</bsvc:Exclude_Teams> <bsvc:Exclude_Custom_Organizations>false</bsvc:Exclude_Custom_Organizations> <bsvc:Include_Roles>true</bsvc:Include_Roles> <bsvc:Include_Management_Chain_Data>true</bsvc:Include_Management_Chain_Data> <bsvc:Include_Multiple_Managers_in_Management_Chain_Data>false</bsvc:Include_Multiple_Managers_in_Management_Chain_Data> <bsvc:Include_Benefit_Enrollments>true</bsvc:Include_Benefit_Enrollments> <bsvc:Include_Benefit_Eligibility>true</bsvc:Include_Benefit_Eligibility> <bsvc:Include_Related_Persons>true</bsvc:Include_Related_Persons> <bsvc:Include_Qualifications>true</bsvc:Include_Qualifications> <bsvc:Include_Employee_Review>true</bsvc:Include_Employee_Review> <bsvc:Include_Goals>true</bsvc:Include_Goals> <bsvc:Include_Development_Items>true</bsvc:Include_Development_Items> <bsvc:Include_Skills>true</bsvc:Include_Skills> <bsvc:Include_Photo>true</bsvc:Include_Photo> <bsvc:Include_Worker_Documents>true</bsvc:Include_Worker_Documents> <bsvc:Include_Transaction_Log_Data>true</bsvc:Include_Transaction_Log_Data> <bsvc:Include_Subevents_for_Corrected_Transaction>true</bsvc:Include_Subevents_for_Corrected_Transaction> <bsvc:Include_Subevents_for_Rescinded_Transaction>true</bsvc:Include_Subevents_for_Rescinded_Transaction> <bsvc:Include_Succession_Profile>true</bsvc:Include_Succession_Profile> <bsvc:Include_Talent_Assessment>true</bsvc:Include_Talent_Assessment> <bsvc:Include_Employee_Contract_Data>true</bsvc:Include_Employee_Contract_Data> <bsvc:Include_Collective_Agreement_Data>true</bsvc:Include_Collective_Agreement_Data> <bsvc:Include_Probation_Period_Data>true</bsvc:Include_Probation_Period_Data> <bsvc:Include_Feedback_Received>true</bsvc:Include_Feedback_Received> <bsvc:Include_User_Account>true</bsvc:Include_User_Account> <bsvc:Include_Career>true</bsvc:Include_Career> <bsvc:Include_Account_Provisioning>true</bsvc:Include_Account_Provisioning> <bsvc:Include_Background_Check_Data>true</bsvc:Include_Background_Check_Data> <bsvc:Include_Contingent_Worker_Tax_Authority_Form_Information>true</bsvc:Include_Contingent_Worker_Tax_Authority_Form_Information> <bsvc:Exclude_Funds>false</bsvc:Exclude_Funds> <bsvc:Exclude_Fund_Hierarchies>false</bsvc:Exclude_Fund_Hierarchies> <bsvc:Exclude_Grants>false</bsvc:Exclude_Grants> <bsvc:Exclude_Grant_Hierarchies>false</bsvc:Exclude_Grant_Hierarchies> <bsvc:Exclude_Business_Units>false</bsvc:Exclude_Business_Units> <bsvc:Exclude_Business_Unit_Hierarchies>false</bsvc:Exclude_Business_Unit_Hierarchies> <bsvc:Exclude_Programs>false</bsvc:Exclude_Programs> <bsvc:Exclude_Program_Hierarchies>false</bsvc:Exclude_Program_Hierarchies> <bsvc:Exclude_Gifts>false</bsvc:Exclude_Gifts> <bsvc:Exclude_Gift_Hierarchies>false</bsvc:Exclude_Gift_Hierarchies> </bsvc:Response_Group> </bsvc:Get_Workers_Request> </soapenv:Body> </soapenv:Envelope>",
    "USERMAPPING1": "COUNTRY:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Address_Data.Country_Reference.ID(@type=='ISO_3166-1_Alpha-2_Code'),USERNAME:Worker_Data.Worker_ID,EMPLOYEEID:Worker_Data.Worker_ID,STATUSKEY:Worker_Data.Employment_Data.Worker_Status_Data.Active,FIRSTNAME:Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.First_Name,STARTDATE:Worker_Data.Employment_Data.Worker_Status_Data.Hire_Date,JOBDESCRIPTION:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Job_Family_Reference.ID(@type=='Job_Family_ID'),JOB_FUNCTION:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Job_Profile_Name,LASTNAME:Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Last_Name,DEPARTMENTNAME:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Location_Type_Reference.ID(@type=='Location_Type_ID'),CITY:Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='HOME').Municipality,CUSTOMPROPERTY9:Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Municipality,COMPANYNAME:Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Company').Organization_Name,COSTCENTER:Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Cost_Center').Organization_Name,REGIONCODE:Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Postal_Code,REGION:Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Country_Region_Descriptor,TERMDATE:Worker_Data.Employment_Data.Worker_Status_Data.Termination_Date,PHONENUMBER:Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='HOME').@International_Formatted_Phone,SECONDARYEMAIL:Worker_Data.Personal_Data.Contact_Data.Email_Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='HOME').Email_Address,CUSTOMPROPERTY1:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Name,CUSTOMPROPERTY2:Worker_Data.Employee_Contracts_Data.Employee_Contract_Data.Contract_Status_Reference.ID(@type=='Employee_Contract_Status_ID'),CUSTOMPROPERTY3:Worker_Data.Employee_Contracts_Data.Employee_Contract_Data.Contract_Type_Reference.ID(@type=='Employee_Contract_Type_ID'),CUSTOMPROPERTY4:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Management_Level_Reference.ID(@type=='Management_Level_ID'),CUSTOMPROPERTY6:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Manager_as_of_last_detected_manager_change_Reference.ID(@type=='Employee_ID'),LOCATION:Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Location_Hierarchy').Organization_Name,CUSTOMPROPERTY5:Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Supervisory').Organization_Name,CUSTOMPROPERTY7:Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Area').Organization_Name,CUSTOMPROPERTY20:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Start_Date,EMPLOYEETYPE:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.ID(@type=='Employee_Type_ID'),CUSTOMPROPERTY12:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.ID(@type=='Contingent_Worker_Type_ID'),TITLE:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Title,JOBCODE:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Job_Profile_Reference.ID(@type=='Job_Profile_ID'),ENDDATE:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.End_Date,CUSTOMPROPERTY36:Worker_Data.Personal_Data.Contact_Data.Email_Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Email_Address,CUSTOMPROPERTY21:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Manager_as_of_last_detected_manager_change_Reference.ID(@type=='Contingent_Worker_ID'),CUSTOMPROPERTY10:Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='Computer').Value,CUSTOMPROPERTY11:Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='Notebook').Value,CUSTOMPROPERTY8:Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='Phone').Value,CUSTOMPROPERTY13:Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='Cordless').Value,CUSTOMPROPERTY14:Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='MS Office Pack').Value,CUSTOMPROPERTY18:Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='Manager_Single_Assignment').Value",
    "PREFIX1": "wd",
    "RESPONSETOTALRESULTS1": "Body.Get_Workers_Response.Response_Results.Total_Results",
    "RESPONSEPAGERESULTS1": "Body.Get_Workers_Response.Response_Results.Page_Results",
    "RESPONSEDATAPATH1": "Body.Get_Workers_Response.Response_Data.Worker"
    }

Kindly help us understand how to resolve this issue.

 

1 REPLY 1

Dhruv_S
Saviynt Employee
Saviynt Employee

Hi @MahimaMahajan 

Are those user ids present in the logs?

Regards,

Dhruv Sharma