How to fetch Time Zone attribute value from Workday

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

Hi Team,

We are trying to fetch the timezone attribute value from workday to sailpoint but we are not able to fetch the value.

Can anyone please let me know the correct format for the XPath that should be used, and also confirm whether this is a custom or standard attribute?

Thanks,

Priyanka

2

What’s the path you currently have?

3

@PRIYANKALINGALA Have you checked if this would work?
New Capability - Availability of new Identity Attributes, Default Identity Profile Mapping and Transforms - Announcements / Product News - SailPoint Developer Community
Timezone attribute is called “Time_Profile_ID“ and looks like it’s predefined automatically, so you could try to map it directly to “timezone“ identity attribute.

4

Hi Eberth Gamarra,

We attempted to use the two xpaths below, but we were unable to retrieve the time zone value.

option1: wd:Location/wd:Location_Data/wd:Time_Zone_Reference

option2: wd:Worker_Preferred_Time_Zone/wd:Worker_Preferred_Time_Zone_Data/wd:Time_Zone_Data

Thanks,

Priyanka.

5

Hey @PRIYANKALINGALA,

For timezone, you don’t need a custom XPath: it’s a standard Workday attribute exposed as Time_Profile_ID in the connector schema.

Try mapping Time_Profile_ID → to the Identity attribute “Time Zone”. And reaggregate. If you must use Time_Zone_Reference, pull the ID under it:wd:Time_Zone_Reference/wd:ID

2 Likes
6

Hi Eberth Gamarra,

We are using Workday saas connector.

As we don’t have Time_Profile_ID as a default in workday saas connector we have create a new xpath for Time_Profile_ID but it is fetching the value as “Standard_Hours_37_5” for all the users. Below is the xpath we have used.
wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Time_Profile_Reference/wd:ID[@wd:type=‘Time_Profile_ID’]

To fetch the time zone value we have used below xpath but not able to fetch any value.
wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Time_Zone_Reference/wd:ID

We gave the schema attribute name as Time_Zone_ID.

Thanks,
Priyanka.