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
<?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
Solved! Go to 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.
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
26 | |
25 | |
24 | |
23 | |
21 |
User | Count |
---|---|
62 | |
45 | |
40 | |
29 | |
27 |