How to write a liquid template for SOAP XML to Custom JSON conversion.

Question

Hi,

My Goal: convert the SOAP XML response into a JSON response.

SOAP XML:

JSON Response I want to get it to:

My Liquid Template For This (XML to JSON):

Problem
Currently I am not getting output for the ProductId—I just get a "" return back. I can't figure out why this is happening. Not sure if this is a syntax issue in anyway. Using liquid templates, for XML to JSON conversion, how should the ".liquid" file be written in order to achieve the expected JSON response?

Please note, this ".liquid" file is added through "Maps" in an integration account connected to a logic app. The logic app is using the XML to JSON conversion action.

Thank you a lot for the help. Looking forward.

Reference/Credits (for XML):
https://www.mikaelsand.se/2019/06/accessing-soap-envelope-and-body-properties-in-liquid-templates/

Answer 1

Solution

I have resolved this issue. For people referring to this in the future, here is the solution: simply ignore the prefix. That is, the templating will be:

{<!-- -->{ content.Envelope.Body.PriceList_Response.PriceList.prices.price.productId }}

This will work.

Summary
Suppose you have soapenv:Envelope, just do Envelope by itself. Ignore prefix.

P.S. I recommend the MS team to leave this question publicly available as there are very limited resources regarding liquid templates.