and more in a single search tool across platforms. Read the announcement here. |
01/29/2024 10:43 AM
Hello
I'm trying to import users from workday using soap connector and using following connector guide:
https://docs.saviyntcloud.com/bundle/WD1_v55x/page/Content/Configuring-a-Connection.htm
It is showing that pagination is supported in this .
but when I'm trying to import , only 100 users are imported , even if I'm giving "page_size" as "1000"
here is import json:-
{
"CONNECTION1":"login",
"REQUESTXML1":"<soapenv:Envelope xmlns:bsvc=\"urn:com.workday/bsvc\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\"><soapenv:Header><wsse:Security soapenv:mustUnderstand=\"1\" xmlns:wsse=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\" xmlns:wsu=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><wsse:UsernameToken wsu:Id=\"UsernameToken-#####\"><wsse:Username>######</wsse:Username><wsse:Password Type=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText\">####</wsse:Password><wsse:Nonce EncodingType=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary\">#####</wsse:Nonce><wsu:Created>2024-01-15T09:56:52.536Z</wsu:Created></wsse:UsernameToken></wsse:Security></soapenv:Header><soapenv:Body><bsvc:Get_Workers_Request bsvc:version=\"v42.0\"><bsvc:Response_Group><bsvc:Include_Personal_Information>true</bsvc:Include_Personal_Information><bsvc:Include_Employment_Information>true</bsvc:Include_Employment_Information><bsvc:Include_Organizations>true</bsvc:Include_Organizations><bsvc:Exclude_Cost_Centers>false</bsvc:Exclude_Cost_Centers><bsvc:Include_Management_Chain_Data>true</bsvc:Include_Management_Chain_Data><bsvc:Include_Organizations>true</bsvc:Include_Organizations><bsvc:Include_Roles>true</bsvc:Include_Roles><bsvc:Include_Transaction_Log_Data>true</bsvc:Include_Transaction_Log_Data></bsvc:Response_Group></bsvc:Get_Workers_Request></soapenv:Body></soapenv:Envelope>",
"USERMAPPING1":"FIRSTNAME:Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.First_Name,LASTNAME:Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.Last_Name,USERNAME:Worker_Data.Worker_ID,SYSTEMUSERNAME:Worker_Data.User_ID,CUSTOMPROPERTY1:Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.@Formatted_Name,ENDDATE:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.End_Date,COSTCENTER:Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Reference.ID(@type=='Cost_Center_Reference_ID'),MIDDLENAME:Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.Middle_Name,EMAIL:Worker_Data.Personal_Data.Contact_Data.Email_Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Email_Address,STATUSKEY:Worker_Data.Employment_Data.Worker_Status_Data.Active ,JOBCODEDESC:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Job_Profile_Name,OWNER:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Manager_as_of_last_detected_manager_change_Reference.ID(@type=='Employee_ID'),LEAVESTATUS:Worker_Data.Employment_Data.Worker_Status_Data.Leave_Status_Data.On_Leave,STARTDATE:Worker_Data.Employment_Data.Worker_Status_Data.Hire_Date ,LOCATION:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Name,CUSTOMPROPERTY9:Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference>ID=='Cost_Center').Organization_Name,TITLE:Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Title,CUSTOMPROPERTY8:Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.First_Name,CUSTOMPROPERTY9:Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Middle_Name,CUSTOMPROPERTY10:Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Last_Name,CUSTOMPROPERTY11:Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.@Formatted_Name",
"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"
}
-------------------------------------------------------------------------------------------------------------------------------------
Even if I'm trying it with soap UI , it is giving always the same 100 records.
Trying with following request:
Giving o/p with same 100 records , even if I'm removing this -
<bsvc:Response_Filter>
<bsvc:Page>2</bsvc:Page>
<bsvc:Count>900</bsvc:Count>
</bsvc:Response_Filter>
Anything else to be added or corrected please let me know .
Thankyou.
01/29/2024 09:21 PM
@aminahasware
You can use this document.
https://docs.saviyntcloud.com/bundle/REST-v24x/page/Content/Developers-Handbook.htm
02/05/2024 03:48 AM
Can you please share the solution if it worked with you? @aminahasware
02/05/2024 06:34 AM
Hi @ray
Sure , here is the solution .
1. Add following tag in "HR_IMPORT_JSON"
<bsvc:Response_Filter><bsvc:Page>${PAGE_NUMBER}</bsvc:Page><bsvc:Count>${PAGE_SIZE}</bsvc:Count></bsvc:Response_Filter>.
2. And set "page_size" as per your requirement .
Hope you find the response useful .
Thankyou,
Amina
02/05/2024 07:24 PM
Since its working you can close the thread by accepting answer