Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/14/2024 03:17 AM
Hi,
We are using below mapping to bring the phonenumber and secondaryphone from workday but in phonenumber and secondaryphone we are getting same value i.e of phonenumber
"PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK')[0].@Tenant_Formatted_Phone",
value:-+** ** **** 5852
"SECONDARYPHONE":"Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK')[1].@Tenant_Formatted_Phone",
value:-+** ** **** 5852
Workday XML:-
<env:Envelope xmlns:env="">
<env:Body>
<wd:Get_Workers_Response wd:version="" xmlns:wd="">
<wd:Worker>
<wd:Worker_Data>
<wd:Personal_Data>
<wd:Contact_Data>
<wd:Phone_Data wd:Area_Code="***" wd:Phone_Number_Without_Area_Code="********" wd:E164_Formatted_Phone="+*********8555" wd:Workday_Traditional_Formatted_Phone="+** (***) ****8555" wd:National_Formatted_Phone="*** **** 8555" wd:International_Formatted_Phone="+** *** **** 8555" wd:Tenant_Formatted_Phone="+** *** **** 8555">
<wd:Country_ISO_Code>*</wd:Country_ISO_Code>
<wd:International_Phone_Code>*</wd:International_Phone_Code>
<wd:Phone_Number>*******8555</wd:Phone_Number>
<wd:Phone_Device_Type_Reference wd:Descriptor="Mobile">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_Device_Type_ID">7_Phone type</wd:ID>
</wd:Phone_Device_Type_Reference>
<wd:Usage_Data wd:Public="0">
<wd:Type_Data wd:Primary="1">
<wd:Type_Reference wd:Descriptor="Home">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Communication_Usage_Type_ID">HOME</wd:ID>
</wd:Type_Reference>
</wd:Type_Data>
</wd:Usage_Data>
<wd:Phone_Reference wd:Descriptor="PHONE_REFERENCE-3-130868">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_ID">PHONE_REFERENCE-3-130868</wd:ID>
</wd:Phone_Reference>
<wd:ID>PHONE_REFERENCE-3-130868</wd:ID>
</wd:Phone_Data>
<wd:Phone_Data wd:Area_Code="**" wd:Phone_Number_Without_Area_Code="****5852" wd:E164_Formatted_Phone="+*******5852" wd:Workday_Traditional_Formatted_Phone="+** (**) 22115852" wd:National_Formatted_Phone="*** **** 5852" wd:International_Formatted_Phone="+** ** **** 5852" wd:Tenant_Formatted_Phone="+** ** **** 5852">
<wd:Country_ISO_Code>***</wd:Country_ISO_Code>
<wd:International_Phone_Code>**</wd:International_Phone_Code>
<wd:Phone_Number>******5852</wd:Phone_Number>
<wd:Phone_Device_Type_Reference wd:Descriptor="Landline">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_Device_Type_ID">1_Phone type</wd:ID>
</wd:Phone_Device_Type_Reference>
<wd:Usage_Data wd:Public="1">
<wd:Type_Data wd:Primary="1">
<wd:Type_Reference wd:Descriptor="Work">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Communication_Usage_Type_ID">WORK</wd:ID>
</wd:Type_Reference>
</wd:Type_Data>
</wd:Usage_Data>
<wd:Phone_Reference wd:Descriptor="PHONE_REFERENCE-3-132718">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_ID">PHONE_REFERENCE-3-132718</wd:ID>
</wd:Phone_Reference>
<wd:ID>PHONE_REFERENCE-3-132718</wd:ID>
</wd:Phone_Data>
<wd:Phone_Data wd:Area_Code="***" wd:Phone_Number_Without_Area_Code="****8555" wd:E164_Formatted_Phone="+*********8555" wd:Workday_Traditional_Formatted_Phone="+** (***) ****8555" wd:National_Formatted_Phone="*** **** 8555" wd:International_Formatted_Phone="+** *** **** 8555" wd:Tenant_Formatted_Phone="+** *** **** 8555">
<wd:Country_ISO_Code>***</wd:Country_ISO_Code>
<wd:International_Phone_Code>**</wd:International_Phone_Code>
<wd:Phone_Number>*******8555</wd:Phone_Number>
<wd:Phone_Device_Type_Reference wd:Descriptor="Mobile">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_Device_Type_ID">7_Phone type</wd:ID>
</wd:Phone_Device_Type_Reference>
<wd:Usage_Data wd:Public="1">
<wd:Type_Data wd:Primary="0">
<wd:Type_Reference wd:Descriptor="Work">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Communication_Usage_Type_ID">WORK</wd:ID>
</wd:Type_Reference>
</wd:Type_Data>
</wd:Usage_Data>
<wd:Phone_Reference wd:Descriptor="PHONE_REFERENCE-3-132763">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_ID">PHONE_REFERENCE-3-132763</wd:ID>
</wd:Phone_Reference>
<wd:ID>PHONE_REFERENCE-3-132763</wd:ID>
</wd:Phone_Data>
<wd:Phone_Data wd:Area_Code="**" wd:Phone_Number_Without_Area_Code="****5500" wd:E164_Formatted_Phone="+********5500" wd:Workday_Traditional_Formatted_Phone="+** (**) ****5500" wd:National_Formatted_Phone="*** **** 5500" wd:International_Formatted_Phone="+** ** **** 5500" wd:Tenant_Formatted_Phone="+** ** **** 5500">
<wd:Country_ISO_Code>*</wd:Country_ISO_Code>
<wd:International_Phone_Code>*</wd:International_Phone_Code>
<wd:Phone_Number>******5500</wd:Phone_Number>
<wd:Phone_Device_Type_Reference wd:Descriptor="Fax">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_Device_Type_ID">3_Phone type</wd:ID>
</wd:Phone_Device_Type_Reference>
<wd:Usage_Data wd:Public="1">
<wd:Type_Data wd:Primary="0">
<wd:Type_Reference wd:Descriptor="Work">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Communication_Usage_Type_ID">WORK</wd:ID>
</wd:Type_Reference>
</wd:Type_Data>
</wd:Usage_Data>
<wd:Phone_Reference wd:Descriptor="PHONE_REFERENCE-3-132764">
<wd:ID wd:type="WID">*</wd:ID>
<wd:ID wd:type="Phone_ID">PHONE_REFERENCE-3-132764</wd:ID>
</wd:Phone_Reference>
<wd:ID>PHONE_REFERENCE-3-132764</wd:ID>
</wd:Phone_Data>
</wd:Contact_Data>
<wd:Tobacco_Use>0</wd:Tobacco_Use>
</wd:Personal_Data>
</wd:Worker_Data>
</wd:Worker>
</wd:Response_Data>
</wd:Get_Workers_Response>
</env:Body>
</env:Envelope>
06/15/2024 10:21 PM
{
"PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK')[0].@Tenant_Formatted_Phone",
"SECONDARYPHONE": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK')[1].@Tenant_Formatted_Phone"
}
06/18/2024 09:26 AM
hi @rushikeshvartak format mentioned by you are the same which i am using .Please refer the description.