Parse XML to return first node

[acrespo]

Any ideas on how to extract the first node or category of an XML file? I assume xpath is the way to go but not sure what to put in the expression:

For the example below, I wish to extract the value: ShipmentProfileReport

Possibly something like: xpath(xml(outputs('XML File')), '??????')

<?xml version="1.0" encoding="utf-8"?>
</ShipmentProfileReport>
  <ShipmentProfileReportItem>
    <JobOperator>John Doe</JobOperator>
     <Master>17231888581</Master>
  </ShipmentProfileReportItem>
  <ShipmentProfileReportItem>
    <JobOperator>Jane Doe</JobOperator>
    <Master>78423082032</Master>
  </ShipmentProfileReportItem>
</ShipmentProfileReport>

Thanks

[v-litu-msft · Accepted solution]

Hi @acrespo,

xml() function and xpath() function neither of them can do it.

As a workaround, you could use split() function and index to approach that:

split(split(outputs('XML'),'<')[2],'>')[0]

Run result:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.