Workday custum/calculated attribute values

bhoyars_1 · July 10, 2024, 6:29pm

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

Hi all,

We are facing an issue while aggregating custom/calculated fields from Workday to SailPoint. In Workday, the calculated field’s value is ‘F’, but in SailPoint, it is showing as ‘A’. All other calculated field values are coming through properly except for this one field. Any help would be greatly appreciated."

enistri_devo · July 10, 2024, 6:44pm

Hi @bhoyars_1,

I am thinking on 2 reason.

1.you have a mapping in workday like for employee/contract type(low probability)
2.the xpath is wrong(most probability)

can you share the xpath that you have for this attribute in SP and an example hf the response for this attribute from workday(in SoapUI for example).

Also,If you are using a customization rule for calculate this attribute, can you share the rule?

bhoyars_1 · July 11, 2024, 6:41am

@enistri_devo
"We defined the calculated field directly as ‘Status_Flag_New__c’; we are not using any XPath for this. For other calculated fields, we are receiving the correct value. Please find the response tag below from the WD system. We are not using any customization rule for this.

Workday Response:

<wd:Integration_Field_Override_Data>
<wd:Field_Reference>
<wd:ID wd:type="WID">12344d455667</wd:ID>
<wd:ID wd:type="Integration_Document_Field_Name" wd:parent_type="Integration_Document_Name" wd:parent_id="###_Sailpoint_Integration_FieldOverride">Status_Flag_New</wd:ID>
</wd:Field_Reference>
<wd:Value>F</wd:Value>
</wd:Integration_Field_Override_Data>
<wd:Integration_Field_Override_Data>
<wd:Field_Reference>

Thanks

enistri_devo · July 11, 2024, 6:58am

ok., thanks.
All the other attributes are in the Integration_Field_Override_Data?
and I suppose you have set an integration ID into connetor.

For understaning what happening, can you print into the logs those attribute? In a aggregation rule for example or in a customization

bhoyars_1 · July 12, 2024, 7:40am

@enistri_devo
We tried at using connectorDebug and below is the result.

enistri_devo · July 12, 2024, 8:02am

so, we have the confirmation that connector are reading other things.
I prefer to use xpath, because if workday is not done well, it becomes a problem with custom attribute.

try to add this in xpath schema:

<entry key="Status_Flag" value="ns1:Worker_Data/ns1:Integration_Field_Override_Data/ns1:Value"/>

and this in attribute schema
<AttributeDefinition name="Status_Flag" remediationModificationType="None" required="true" type="string"> <Description>Department description</Description> </AttributeDefinition>

and retry with aggregation.

PS check if your Integration_Field_Override_Data is in Worker_Data in soap response

bhoyars_1 · July 12, 2024, 1:00pm

@enistri_devo
Thanks for the response.
We have added the xpath as you mentioned but we are not getting status_flag value. In output its showing as Businet unit tag value. Please find the below workday response.
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb467f32a0001</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Business_Unit</wd:ID>
</wd:Field_Reference>
</wd:>
<wd:ID wd:type=“WID”>19bfc6e9ec
wd:Field_ReferenceIntegration_Field_Override_Data>
<wd:Integration_Field_Override_Data50101b923eb467f32a0002</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Is_Manager</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb467f32a0003</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Scheduled_Working_Hours</wd:ID>
</wd:Field_Reference>
wd:Value0</wd:Value>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb467f32a0004</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Job_Profile_Start_Date</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb50263690000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Job_Name</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb50263690001</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Time_Zone</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb50263690002</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>International_Assignment</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb50263690003</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Assignment_Start_Date</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb50263690004</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Host_Location_IA</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>19bfc6e9ec50101b923eb50263690005</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Leave_Type</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>0b7e8bbd452a1011d984a6b863f00000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Preferred_First_Name</wd:ID>
</wd:Field_Reference>
wd:ValueJohn</wd:Value>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>1194deff4418101635beca5af7850000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Status_Flag_New</wd:ID>
</wd:Field_Reference>
wd:ValueF</wd:Value>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>1b3bf5b15289100de45f7508478a0000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Region</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>ffd564011c92101c5c2a12ecf2160000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Cost_Segment</wd:ID>
</wd:Field_Reference>
wd:Value…</wd:Value>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>47d401e20790101678d9e5a004d00000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT067_Sailpoint_Integration_FieldOverride”>Sub_Entity</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
</wd:Worker_Data>
</wd:Worker>
</wd:Response_Data>
</wd:Get_Workers_Response>
</env:Body>
</env:Envelope>

Thanks

enistri_devo · July 12, 2024, 1:15pm

Ok, I understand.
You have more than one field.

Try those xpath:

<entry key="Status_Flag" value="ns1:Worker_Data/ns1:Integration_Field_Override_Data[ns1:Field_Reference[ns1:ID[@ns1:type='Integration_Document_Field_Name']='Status_Flag_New']]"/>

<entry key="Status_Flag" value="ns1:Worker_Data/ns1:Integration_Field_Override_Data[ns1:Field_Reference[ns1:ID[@ns1:type='Integration_Document_Field_Name']='Status_Flag_New']]/ns1:Value"/>

I am not sure with Value at end or without, try both

system · September 10, 2024, 1:15pm

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

Topic		Replies	Views
Identities not getting aggregated from workday aggregation task IIQ Discussion and Questions identityiq	8	42	August 30, 2024
Workday delta aggregation not working properly IIQ Discussion and Questions aggregation , identityiq	5	226	May 16, 2024
Workday full aggregation is not pulling some attributes value IIQ Discussion and Questions aggregation , identityiq	13	462	January 15, 2024
Workday aggregation failing at different timings IIQ Discussion and Questions aggregation , identityiq	8	368	April 30, 2024
Attempting to bring in Workday data to SailPoint via connector (Issues) IIQ Discussion and Questions apis , identityiq , connectors	3	28	September 15, 2024

Workday custum/calculated attribute values

Which IIQ version are you inquiring about?

Share all details related to your problem, including any error messages you may have received.

Related Topics