Is it possible to retrieve multiple values from a Workday Calculated Field in ISC?

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi everyone,

I’ve run into a limitation with Workday Calculated Fields. I’m trying to retrieve multiple values (e.g., a list or array) from a single Workday Calculated Field and pass them into ISC during aggregation. I have tried to set the string as multi-valued but it didn’t work.

Question:
Is there any supported method or workaround in ISC to:

  • Extract multiple values from a single Workday Calculated Field (e.g., a multi-select field)?
  • We have some custom attributes in Workday which we are bringing in as calculated fields for instance(“Branch” attribute) a user with two jobs within the Org can have multiple Branches but calculated field is only allowing one?

I’d like to know if there’s a native way in ISC to process such fields during aggregation.

Any insights or best practices would be appreciated!

Thanks in advance,

2

do you see any xpaths?

4

Can we use xpaths for calculated fields? but the issue I’m running into is with custom organization types. The XPath differs depending on the value under the same attribute. For example:

  • For ITS, the XPath might look like CUSTOM_ORG_347
  • For Administrator, it could be CUSTOM_ORG_852

Since these identifiers are system-generated and vary per organization type, it’s difficult to build a reusable or dynamic XPath expression to handle all possible values.

5

using or(|) we can acheive this and you can have __c attribute that holds this.

6

We are using the __c attribute already which only retrieves only one value from the attribute for xpaths there are multiple values which is hard to achieve this using or(|) and they might add more down the line.

7

Hi Sai, Could you do us a favour and if you have XML handy for this particular query, can you drop that in here. Seems like a intresting query.

8

Hey Neeraj, here is a xml for a workers data from Workday:

image
image877×551 35.9 KB

As shown in the XML response, the attribute is labeled “Division”, and the value in this case is “ITS”. This is a custom field, and the corresponding integration type is “ORGANIZATION_TYPE-3-60” for ITS. However, this identifier varies depending on the Division—for example, for “Administrator”, the integration type is “ORGANIZATION_TYPE-3-81”. Each Division has its own unique organization type ID if a user holds multiple jobs within the organization, they may be associated with multiple Divisions, As of now we are only able we have this as a custom field which only retrieves only single value, Just want to know if it’s possible to bring this values in ISC as a multivalued by the calculated field or using Xpaths.

1 Like
9

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