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

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

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.
2,828 questions
Azure Maps
Azure Maps
An Azure service that provides geospatial APIs to add maps, spatial analytics, and mobility solutions to apps.
587 questions
0 comments No comments
{count} vote

1 answer

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

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