powershell_module_workdayapi icon indicating copy to clipboard operation
powershell_module_workdayapi copied to clipboard

Need Worker's Formatted_Address and ADDRESS_LINE_1

Open emanent opened this issue 5 years ago • 1 comments

Hello community it's not really an issue i'm trying to get data for Workday XML returned fields not in the initial api list

  1. wd:Formatted_Address in <wd:Address_Data wd:Effective_Date="2015-06-01-07:00" wd:Address_Format_Type="Extended" wd:Formatted_Address="my_adress_XXX&#xa;ZZZ&#xa;WWW" wd:Defaulted_Business_Site_Address="0">
  2. ADDRESS_LINE_1 <wd:Address_Line_Data wd:Type="ADDRESS_LINE_1" wd:Descriptor="Street Name and Type">my_adressXXX</wd:Address_Line_Data> i undestand not everybody is interested by this fields so if anybody can help me with the correct xml calls for this fields

i've tried many without returns and/or errors such as for 1) $o.Adr=$workerJobData.SelectNodes('./wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Data/wd:ID@wd:Formatted_Address]]', $NM).InnerText and for 2) $o.Adrl1=$workerJobData.SelectNodes('./wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:ID[@wd:type="ADDRESS_LINE_1" and .Descriptor="Street Name and Type"]]', $NM).InnerText but i can't get the data read from XML... if anybody can help me with this cases.. regards Emmanuel

emanent avatar Mar 01 '20 07:03 emanent

hello after long searches i finally find out answers - for those interested : for 1 $o.Adr=$workerJobData.Position_Data.Business_Site_Summary_Data.Address_Data.Formatted_Address for 2 $temp=$workerJobData.Position_Data.Business_Site_Summary_Data.Address_Data.Address_Line_Data | Where-Object {$_.type -eq 'ADDRESS_LINE_1'}
$o.Adrl1=$temp.Innertext

emanent avatar Mar 09 '20 09:03 emanent