Workday to IDN Custom Values Contain Reference Field Data

Identity Security Cloud (ISC) ISC Discussion and Questions
1

We are trying to pull custom attributes from Workday to our IDN sandbox environment. We can get the data to populate however it is importing in as a concatenated value. For example we are trying to pull Employee Status.

The xpath we are using is:

ns1:Worker_Data/ns1:Integration_Field_Override_Data[ns1:Field_Reference[ns1:ID[@ns1:type=‘Integration_Document_Field_Name’]=‘Status’]]

When we look at the data in an identity record it shows this:

Status C WD 7c3f91f3247401248b1de002560ae1a4StatusA

We are only looking for the value ‘A’.

This is happening with other custom values. The expected data is returned, but unfortunately has the reference information. Any suggestions?

2

Do you have an example of what the raw XML data looks like? If so then you can use an xpath tester tool to fine tune the xpath to extract just the desired data. If not then maybe you can get setup with SOAPUI to get a sample using the getWorkers api.

3

Is this the information you are referring to? Also, do you have an xpath tester tool you would recommend? This is all new to me. Thanks!

<wd:Integration_Field_Override_Data>
                 <wd:Field_Reference wd:Descriptor="SailPoint Extra Fields / Status">
                    <wd:ID wd:type="WID">7c3f91f3247401248b1de002560ae1a4</wd:ID>
                    <wd:ID wd:type="Integration_Document_Field_Name" wd:parent_type="Integration_Document_Name" wd:parent_id="SailPoint Extra Fields">Status</wd:ID>
                 </wd:Field_Reference>
                 <wd:Value>A</wd:Value>
              </wd:Integration_Field_Override_Data>
4

Based on the xml you posted it looks like you might need to add /ns1:Value to the end of your xpath.

As for xpath testers I personally use Free Online XPath Tester / Evaluator - FreeFormatter.com. But there are probably better ones, that’s just the first one I found and ended up sticking with.
I usually copy content into a text editor and do a find replace to remove things like ns1: or wd: since they aren’t compatible with the tester.

1 Like
5

@jburrell were you able to solve your issue using Stephen’s suggestion?

6

Hello!

Just realized I didn’t reply back. The solution worked and the values were returned as expected.

Thanks!!

1 Like