Logic Apps Data Mapper Loop
PABITRA KUMAR PATRA
0
Reputation points
I'm currently working with the new Logic Apps Data Mapper and I'm trying to replicate functionality similar to the old Looping Functoid from the BizTalk Mapper.
In my scenario:
- The source schema is JSON and contains a single array.
- The destination schema has an array that contains a nested array, which is where I need to map the values from the source.
However, I'm facing a challenge: Logic Apps Data Mapper doesn't seem to support a direct equivalent of the Looping Functoid, and when I try to map the source array directly to the nested destination array, it results in duplicated values or incorrect nesting.
Input Json Structure:
{
"Materials": [
{
"MaterialNo": "MAT001",
"Price": 100
},
{
"MaterialNo": "MAT002",
"Price": 200
}
]
}
Expected Output Json Structure:
{
"Materials": [
{
"Material": "MAT001",
"PriceSet": [
{
"Price": 100
}
]
},
{
"Material": "MAT002",
"PriceSet": [
{
"Price": 200
}
]
}
]
}
But Getting output as below:
{
"Materials": [
{
"Material": "MAT001",
"PriceSet": [
{
"Price": 100
},
{
"Price": 200
}
]
},
{
"Material": "MAT002",
"PriceSet": [
{
"Price": 100
},
{
"Price": 200
}
]
}
]
}
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
Sign in to answer