How to fetch xml attribute value in liquid template - XML to JSON Liquid

asked 2020-06-10T09:17:56.097+00:00
Suraj Revankar 11 Reputation points

Hi,

I am trying to fetch the xml attribute value using liquid template. Examples are as below.

XML example:

    <ns0:root xmlns:ns0="http://customnamespace.com" xmlns:ns1="http://customnamespace2.com">
  <ns1:product>
  <ns1:name QualifierID="std.lang.all" >TV</ns1:name>
  <ns1:price>499.9</ns1:price>
 </ns1:product>
 </ns0:root>

Liquid Template used:

{
"name": "{{content.product.name['QualifierID']}}",
"price": "{{content.product.price}}",
}

Output expecting :

  {
"name": "std.lang.all",
"price": "499.9"
}

I tried couple of ways but not able to fetch the xml attribute value. it gives me empty value for name.

Best regards,
Suraj

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,802 questions
Azure Maps
Azure Maps
An Azure service that provides geospatial APIs to add maps, spatial analytics, and mobility solutions to apps.
337 questions
No comments
1 vote

1 answer

Sort by: Most helpful
  1. answered 2020-06-10T15:41:22.38+00:00
    Tarun Garg 1 Reputation point

    I tried few options but nothing seems to work. One other approach is convert this XML to JSON and then use liquid map