how to transform xml file to json without integration account in azure logic app

Rashmiramchandra Prabhu 66

I am getting xml file as input in service bus and want to transform it to json with specified mapping format and then drop json file to sftp.Dont want to used integration account any other connector or way appriciated

Thanks!!

Shah, Khyati 0 Reputation points

2024-06-03T10:43:34.29+00:00

I have the same query. Don't want the default conversion either. Any inputs?

Accepted answer

Pramod Valavala 20,636 Reputation points Microsoft Employee

2023-07-28T09:50:22.1066667+00:00
@Rashmiramchandra Prabhu You can directly use the xml and json functions to make such a conversion.

Use the compose action with the following expression and use its output in the SFTP action.

json(xml('<xml-as-string>'))
Please sign in to rate this answer.
Rashmiramchandra Prabhu 66 Reputation points

2023-08-02T05:58:27.2+00:00

I have used this and then select operator but select giving json response feild in alphabetical order any way by which we can make it in the order customer want in logic app

Pramod Valavala 20,636 Reputation points Microsoft Employee

2023-08-09T15:38:00.7733333+00:00

@Rashmiramchandra Prabhu By convention, the order of properties in a JSON Object are not guaranteed and should not be expected to be so as well.

Unfortunately, there is no way to change the default behavior but instead you could build the final stringified JSON object manually using the Compose Action.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer

Share via

how to transform xml file to json without integration account in azure logic app

0 additional answers

Your answer