Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,094 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I want to convert this:
{
"firstName": "John",
"lastName": "Smith",
"fullName": "John Smith",
"age": "32",
"emailAddress": "smith1234@hotmail.com",
"dob": "1988-12-06",
"billingAddress__streetAddress": "21 2nd Street",
"billingAddress__city": "New York",
"billingAddress__state": "NY",
"billingAddress__postalCode": "10021",
"shippingAdress__streetAddress": "21 2nd Street",
"shippingAdress__city": "New York",
"shippingAdress__state": "NY",
"shippingAdress__postalCode": "10021",
"phoneNumber": [
{
"type": "home",
"number": "212 555-1234"
},
{
"type": "fax",
"number": "646 555-4567"
},
{
"type": "mobile",
"number": "212 555-1299"
}
]
}
To this:
{
"firstName": "John",
"lastName": "Smith",
"fullName": "John Smith",
"age": "32",
"emailAddress": "smith1234@hotmail.com",
"dob": "1988-12-06",
"billingAddress__streetAddress": "21 2nd Street",
"billingAddress__city": "New York",
"billingAddress__state": "NY",
"billingAddress__postalCode": "10021",
"shippingAdress__streetAddress": "21 2nd Street",
"shippingAdress__city": "New York",
"shippingAdress__state": "NY",
"shippingAdress__postalCode": "10021",
"phoneNumber__home": "212 555-1234",
"phoneNumber__fax": "646 555-4567",
"phoneNumber__mobile": "212 555-1299"
}
Got the answer:
{
"firstName": "{{content.firstName}}",
"lastName": "{{content.lastName}}",
"fullName": "{{content.fullName}}",
"age": "{{content.age}}",
"emailAddress": "{{content.emailAddress}}",
"dob": "{{content.dob}}",
"billingAddress__StreetAddress": "{{content.billingAddress.streetAddress}}",
"billingAddress__City": "{{content.billingAddress.city}}",
"billingAddress__State": "{{content.billingAddress.state}}",
"billingAddress__PostalCode": "{{content.billingAddress.postalCode}}",
"shippingAddress__StreetAddress": "{{content.shippingAddress.streetAddress}}",
"shippingAddress__City": "{{content.shippingAddress.city}}",
"shippingAddress__State": "{{content.shippingAddress.state}}",
"shippingAddress__PostalCode": "{{content.shippingAddress.postalCode}}",
"phoneNumber__Home": "{{content.phoneNumber[0].number}}",
"phoneNumber__Mobile": "{{content.phoneNumber[1].number}}",
"phoneNumber__Fax": "{{content.phoneNumber[2].number}}"
}