ISC - Workday Connector xPath issue

Identity Security Cloud (ISC) ISC Discussion and Questions
,
22

Ah-ha - final one from me: Remove the quotes around the 1:

ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=1]/ns1:Position_Data/ns1:Position_Reference/ns1:ID[@ns1:type='Position_ID']
23

I tried that xPath again, with no luck.

Is there a particular log, such as ccg.log to look at? If so, what/how would I look for error/issue. NOTE: I am use to OpenText IDM logs/traces with are 1000x easier to read.

24

I’m feeling confident about removing the quotes about the 1. Can’t say it was my idea: Workday attribute reference for Microsoft Entra ID - Microsoft Entra ID | Microsoft Learn

25

I just tried the following with no luck:

"PRIMARY_POSITION_ID": "ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=1]/ns1:Position_Data/ns1:Position_Reference/ns1:ID[@ns1:type='Position_ID']",
26

Ok, I’m stumped, sorry.

27

Jeremy,

I appreciate your help and everyone else’s help. It is just odd because I can pull ALL positions via below and it will pull all positions.

"POSITION_ID": "ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[*]/ns1:Position_Data/ns1:Position_Reference/ns1:ID[@ns1:type='Position_ID']",

Any variation of this xPath to just pull the Primary_Job=1 does not work.

28

@ScottTanselle,

I am using it as follows. The Primary_Job should be true or false

<entry key="POSITION_ID" value="ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=&apos;true&apos;]/ns1:Position_Data/ns1:Position_ID"/>

Please consider this as a solution if it has worked for you.

Thanks,
Siva

29

Hi Siva,

I tried the following without any luck. NOTE: I tried with Primary_Job=true and also Primary_Job=‘true’

"PRIMARY_POSITION_ID": "ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[ns1:Primary_Job=true]/ns1:Position_Data/ns1:Position_Reference/ns1:ID[@ns1:type='Position_ID']",
30

@ScottTanselle , I notice that the two xpaths are different. Let’s follow the exact instructions I provided in my previous reply. Additionally, ensure that the Configure_Response_Group is set to true in order to receive the desired response from the service.

I also recommend testing the service using SOAP to get the desired results, which will help construct the XPath correctly.

Thanks,
Siva

31

After looking at it further and a teammate looking at it, it is working.

"PRIMARY_POSITION_ID": "ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job='true']/ns1:Position_Data/ns1:Position_ID",

We just didn’t expected it to work like this based upon how other of the xPath are working.

Thanks again for all of those that had input on this.

1 Like
32

Thank you so much for the update, @ScottTanselle! I’m really happy to hear that the proposed solution worked. It would mean a lot to me if my solution could be accepted as the final one—it would definitely give my confidence a nice boost!

33

Ah, so it looks like the Position_ID had a separate element

From the WSDL:

        <wd:Employment_Data>
          <wd:Worker_Job_Data wd:Primary_Job="true">
            <wd:Position_Data wd:Effective_Date="2025-01-30Z">
              <wd:Position_Reference wd:Descriptor="string">
                <wd:ID wd:type="string"/>
              </wd:Position_Reference>
              <wd:Headcount_Reference wd:Descriptor="string">
                <wd:ID wd:type="string"/>
              </wd:Headcount_Reference>
              <wd:Position_ID>string</wd:Position_ID>
34

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.