Workday user import - SOAP

[ag420]

Team,

I am trying to pull some specific values from workday Organization_Data group. Below is the mapping -

"CUSTOMPROPERTY60": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data(Organization_Subtype_Reference->ID=='Duty_Station').Organization_Name"

and below is the response hierarchy-

in words - worker,Worker_Data,Organization_Data,Worker_Organization_Data,Organization_Data,Organization_Name where Organization_Subtype_Reference is Duty Station

Currently the job is success but cp60 does not get populated. Also, Organization_Name is available as checked from postman response.

Thank you in advanced 🙂

[ag420]

Additionally, inside the lowest block, below is the hierarchy -  

[rushikeshvartak]

Can you paste sample response in text format

[ag420]

send to you in dm, please check

[ag420]

Any update?

[rushikeshvartak]

"CUSTOMPROPERTY60": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data[Organization_Subtype_Reference/ID='DS_Country']/Organization_Name"

[ag420]

@rushikeshvartak i am using the same but neither of them are working - 

"Location": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data(Organization_Subtype_Reference->ID=='Duty_Station').Organization_Name~;~listAsString"

"CUSTOMPROPERTY60": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data[Organization_Subtype_Reference/ID='DS_Country']/Organization_Name"

[ag420]

Any update on this ?

[ag420]

@rushikeshvartak i tried below also - 

"CUSTOMPROPERTY60": "Worker_Data.Organization_Data[?(@.Organization_Type_Reference['@Descriptor']=='Duty Station')].Organization_Name"

This is working in xpather i.e. path is giving the required value-

Why is it not getting populated in saviynt, how is saviynt parsing the response? Is FD ticket required for this?

[rushikeshvartak]

https://forums.saviynt.com/t5/identity-governance/what-is-the-name-of-notation-syntax-used-by-saviyn...

[ag420]

yes, and i have made the expression according to this only then - 

"CUSTOMPROPERTY60": "Worker_Data.Organization_Data[?(@.Organization_Type_Reference['@Descriptor']=='Duty Station')].Organization_Name"

its not populating the value

[ag420]

any update on this?

[ag420 · Accepted solution]

This worked for me. CLosing.

Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Region').Organization_Name~;~listAsString