Workday SaaS connector unable to fetch correct Address attributes

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

:bangbang: Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.

Please consider addressing the following when creating your topic:

  • What have you tried?
  • What errors did you face (share screenshots)?
  • Share the details of your efforts (code / search query, workflow json etc.)?
  • What is the result you are getting and what were you expecting?

I have an requirement, can some one assist me if the below required xpath schema for the Workday Connector to pull the correct Business title if user two available in workay system:

Current xpath for Business title: ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Business_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Title

Requirement I need but this is not working: ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[0]/ns1:Position_Data/ns1:Business_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[1]/ns1:Position_Data/ns1:Business_Title |ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Title

For some use case, multiple users are having dual job assignment in Workday. For users having single work assignment the business title is updated in the Workday API section Worker_Job_Data[1] and if user has dual work assignment, then they will have business title in two places in Workday API on Worker_Job_Data[1]/Worker_Job_Data[0].

Here, my requirement is the xpath need to validate whether the business title is available on the section “Worker_Job_Data[0]”, then it need to pick this title else it need to pick the title under the section “Worker_Job_Data[1]”.

Could you please check and assist me how can I update xpath schema for this requirement

2

Using [last] index will get you what you want, but pretty sure WD flags positions as primary or not, depending on the api version, which would be a cleaner solution.

3

To use the primary job Business Title:

ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=1]/ns1:Position_Data/ns1:Business_Title/text()

To get the last job in the list Business Title:

ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[last()]/ns1:Position_Data/ns1:Business_Title/text()

4

Hi Jeremy,

We have enabled the Workday attribute “JOBTITLE” as Multi Valued and tried the below xpath schemas from the result of getworker API result whereas it is still not working:

Job Title (Existing):
ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Business_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Title

Job Title (Required which is not working):
ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=‘0’]/ns1:Position_Data/ns1:Business_Title|ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=‘1’]/ns1:Position_Data/ns1:Business_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Title

ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[Primary_Job=‘0’]/ns1:Position_Data/ns1:Business_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[Primary_Job=‘1’]/ns1:Position_Data/ns1:Business_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Title

ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[Primary_Job=‘0’]/ns1:Position_Data/ns1:Business_Title/text() | ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=1]/ns1:Position_Data/ns1:Business_Title/text()

5

Hi @vsekar7 Couple of things:

  • Multi-valued account schema attribute schema doesn’t mean anything in Identity Profile context as Identity Schema does not support multi-valued attributes
  • Did you try either of my suggested fixes?
6

Hi Jeremy,

I have tried both but it is not working

7

Did you copy exactly my XPath, coz I notice in yours you have predicates such as

2 issues:

  • Quotes indicate a string compare, which won’t work
  • You haven’t included a namespace, which won’t work
8

Hi @j_place ,

I have tried with below values and it is not showing the result to me:

ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[@ns1:Primary_Job=1]/ns1:Position_Data/ns1:Business_Title/text()

ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data[last()]/ns1:Position_Data/ns1:Business_Title/text()

9

Hi @vsekar7 Can you check the namespace against other XPath schema mappings? Not sure, but there may be a mismatch with the SaaS connector expecting wd: where the VA connector expects ns1:

10

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