Extract Workday attributes using Hybrid connector

[RakeshMG]

Question

We're trying to extract the ISO fields (below) in Workday as a part of user's record.

The connector used is the Workday_Hybrid_Basic connector.  According to the guide, the syntax we're using is 

"COUNTRY": "wd:Location_Country.wd:type:ISO_3166-1_Alpha-2_Code~#~string"

this doesn't work, are there any other formats we could try to import XMl sub-nodes? 

Answer

Please try using :

"COUNTRY": "wd:Location_Country.wd:type=ISO_3166-1_Alpha-2_Code~#~string"

For more information please refer to following document :

https://docs.saviyntcloud.com/bundle/WD2-v2020x/page/Content/Default-Payloads-for-Connection-Paramet...

[vivek_kotagiri]

<wd:Location_Country wd:Descriptor="United States of America">

<wd:ID wd:type="WID">bc33aa3152ec42d4995f4791a106ed09</wd:ID>

<wd:ID wd:type="ISO_3166-1_Alpha-2_Code">US</wd:ID>

<wd:ID wd:type="ISO_3166-1_Alpha-3_Code">USA</wd:ID>

<wd:ID wd:type="ISO_3166-1_Numeric-3_Code">840</wd:ID>

</wd:Location_Country>

for getting the ISO_3166-1_Alpha-2_Code

Please use : "wd:Location_Country.wd:ID[1].content~#~char"