Workday Connector to pulling to users with the user import job

[cdavis2]

I established the workday connector within Saviynt. The test was successful but when I do a pull using the "User input via a connection" it is not pulling anything in the identity repository -> Users section. Not sure if its my connection configuration or I'm missing something in the job control. 

[avinashchhetri]

Hello @cdavis2,

Could you share the JSON's and the Logs for this issue ?

[cdavis2]

For the User_import_mapping here is the Json I am using. I would like to also add that the workday side is using a RAAS Report. 

{
"ImportType": "RAAS",
"ResponsePath": "wd:Report_Data.wd:Report_Entry",
"ImportMapping": {
"USERNAME": "wd:User_Name~#~string",
"SYSTEMUSERNAME": "wd:User_Name~#~string",
"FIRSTNAME": "wd:First_Name~#~string",
"MIDDLENAME": "wd:Middle_Name~#~string",
"LASTNAME": "wd:Last_Name~#~string",
"DISPLAYNAME": "wd:Full_Name~#~string",
"LOCATION": "wd:Location.wd:Descriptor~#~string",
"TITLE": "wd:Job_Title~#~string",
"EMPLOYEEID": "wd:Employee_ID~#~string",
"PREFEREDFIRSTNAME": "wd:Preferred_First_Name~#~string",
"PHONENUMBER": "wd:Primary_Work_Phone~#~string",
"CITY": "wd:Location.wd:Descriptor~#~string",
"EMAIL": "wd:Primary_Work_Email~#~string",
"statuskey": "wd:Worker_Status~#~string",
"CUSTOMPROPERTY1": "wd:workdayID~#~string",
"COUNTRY": "wd:Country.wd:Descriptor~#~string",
"EMPLOYEETYPE": "wd:Employee_Type.wd:Descriptor~#~string",
"COMPANYNAME": "wd:Company.wd:Descriptor~#~string",
"COSTCENTER": "wd:Cost_Center.wd:Descriptor~#~string"
}
}

[Sivagami · Accepted solution]

In addition to USER_IMPORT_MAPPING, did you populate RAAS_MAPPING_JSON?

{
  "reportUrlMapping": [
    {
      "accessType": "User",
      "url": "${BASE_URL}/ccx/service/customreport2/${TENANT_NAME}/${REPORT_OWNER}/SAV_Users?format=xml"
    }
  ]
}

Connector Documentation - https://saviynt.freshdesk.com/support/solutions/articles/43000618934-workday-connector-guide-2-0#Wor... 

-Siva

[cdavis2]

I added that information as well. If I am doing a RAAS custom report do I need to exclude the Payload?   

[cdavis2]

I added this along with the SOAP call to import the payload and it worked.

[rushikeshvartak]

Is your connection type is REST ?

Please share ImportUserJSON & logs

Jobs Details -  Below should job name & details

[cdavis2]

[rushikeshvartak]

Validate configuration with documentation :

https://docs.saviyntcloud.com/bundle/WD2-v55x/page/Content/Importing-Users.htm 

[PVoehrs]

Hi, have you configured a custom User_Import_mapping? If so, could you share that as well? I have currently the same challenge somehow, but it's related, that my mapping does not contain a username. 
Do you have these errors in your application log: provisoning.SoapProvisioningService - KEY FIELD VALUE IS NULL OR EMPTY. SKIPPING RECORD.?