How to Transform from xml to json in Azure Logic apps using Liquid

Question

I am using the Transform XML to JSON. This is my request body in XML

<Root>
<test>
    <column1>value1</column1>
    <column2>value2</column2>
</test>
<test>
    <column1>value1</column1>
    <column2>value2</column2>
</test>
</Root>

and this is my liquid map

{
    "test": [
        {% for data in Root.test %}
        {
            "column1": "{{data.column1}}",
            "column2": "{{data.column2}}",
        }
        {% endfor %}
    ]
}

while running the logic app i am getting parsing error:

{
  "Code": "IncorrectLiquidTransformOutputType",
  "Message": "An error occurred while converting the transformed value to JSON. The transformed value is not a valid JSON. 'After parsing a value an unexpected character was encountered: {. Path 'test[0]'"
}

But while I run the same code in the liquid sandbox is working fine. may I know? what is the issue here with logic apps.

Do you need a comma after the closing '}' inside the for loop? — Joel Cochran
– Joel Cochran, Commented Apr 28, 2020 at 19:36
I want the response to be in json. That's why tried like that — Jegan Raj
– Jegan Raj, Commented Apr 28, 2020 at 19:38
And array elements are separated by commas in JSON, which doesn't appear to be present in this example. — Joel Cochran
– Joel Cochran, Commented Apr 28, 2020 at 19:41
Hi @JeganRaj May I know if the solution I provided works ? If it helps your problem, could you please mark my answer as accepted, thanks in advance~ — Hury Shen
– Hury Shen, Commented Apr 29, 2020 at 5:26

Hury Shen · Accepted Answer · 2020-04-29 01:44:05Z

4

I test it in my side and provide my liquid map below for your reference:

{
    "test": [
        {% for data in content.Root %}
        {
            "column1": "{{data.column1}}",
            "column2": "{{data.column2}}"
        },
        {% endfor %}
    ]
}

Run this liquid map and it works fine(shown as below screenshot)

Hope it helps~

answered Apr 29, 2020 at 1:44

Hury Shen

15.8k1 gold badge11 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris Halcrow · Accepted Answer · 2021-10-27 02:38:39Z

0

I'll summarise the answers/comments already provided as I didn't see the issue when I first checked the accepted answer!

This type of error can be caused by missing out a comma at the end of a JSON object literal that you want to be repeated as elements in the array, in the transformed output.

Fails

[
    {% for data in Root.test %}
    {
        "column1": "{{data.column1}}",
        "column2": "{{data.column2}}",
    }
    {% endfor %}
]

Works

[
    {% for data in Root.test %}
    {
        "column1": "{{data.column1}}",
        "column2": "{{data.column2}}",
    },
    {% endfor %}
]

answered Oct 27, 2021 at 2:38

Chris Halcrow

32.5k19 gold badges202 silver badges235 bronze badges

Comments

Rakesh Suryawanshi · Accepted Answer · 2022-08-04 09:44:54Z

0

You should use if condition to add "," {% if forloop.last == false %},{% endif %}

{
"test": [
    {% for data in content.Root %}
    {
        "column1": "{{data.column1}}",
        "column2": "{{data.column2}}"
    }{% if forloop.last == false %},{% endif %}
    {% endfor %}
]}

answered Aug 4, 2022 at 9:44

Rakesh Suryawanshi

5401 gold badge8 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to Transform from xml to json in Azure Logic apps using Liquid

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related