How to read an XML and JSON using the xpath ?

pavanshalgar

Hello,

I have a requirement where I have to read XML's using the xpath meta data, is there any way in Alteryx by which I do ?

XML Example :

<Names>

<Name>

<Student-Name>Anything</Student-Name>

<RollNo>1234</RollNo>

</Name>

</Names>

xpath : "Names/Name/Student-Name" should return me "Anything"

JSON Example:

{
"Name": {
"Student-Name": "Anything",
"RollNo": 1234
}
}

xpath : "Name.Student-Name" should return me "Anything"

Felipe_Ribeir0

Hi @pavanshalgar 

You wont have exactly the xpath here without using some programming language, but by parsing the JSON and filtering Student-Name you will get what you need, right?

How to read an XML and JSON using the xpath.yxmd