convert json data to text/xml format using logic apps

Question

The sample json data i had in my source file

{ "name": "pari ", "age": 30, "email": "[email protected]",
"address": { "street": "123 Main St", "city": "xyz", "state": "CA", "zip": "12345" }, "phoneNumbers": [ { "type": "home", "number": "112-234-1234" }, { "type": "work", "number": "222-332-5678" } ] }

Now i am trying to convert this into either text/xml format by using compose action. Then after data formation i want to migrate it to sql.

I have tried http request trigger and blob trigger and then blob and compose actions but i am facing issues. As i am new to this please some one help me to create azure logic app workflow in my case .

Skin · Accepted Answer · 2023-09-12 00:09:05Z

1

You should just be able to use the xml() expression.

The second step has this expression ...

xml(json(concat('{ "root": ', variables('JSON'), '}')))

Result

answered Sep 12, 2023 at 0:09

Skin

11.7k3 gold badges16 silver badges37 bronze badges

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

3 Comments

frezsha Over a year ago

Thank you. I will give it a try but i am asking about converting and then moving it to sql. You answered half of my question thanks for that.

Skin Over a year ago

First things first, the SQL side should be another question IMO.

frezsha Over a year ago

Thank you . It would be great if you can provide that

Collectives™ on Stack Overflow

convert json data to text/xml format using logic apps

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related