This is how I'd go about building the flow, based on the following assumptions.
- "EXENAME=FXDEAL" only appears once (first item in the array).
- Each block of data contains 19 rows.
- The order of the properties are always the same $DoMenu, ticket, sectype, Cparty, etc.
See full flow below. I'll go into each of the actions.
Compose contains your array data (including two blocks of data).
Filter array uses the output from the Compose and removes the first row (EXENAME=FXDEAL) plus any empty rows.
//From (remove the first row)
skip(outputs('Compose'), 1)
//Condition
item()
Apply to each uses the chunk expression to retrieve 19 rows of data at a time (each of our blocks of data contains 19 rows). So, the first time through the loop it will use the first 19 rows, then the next 19 rows, and so on.
chunk(body('Filter_array'), 19)
In this example, I'm just output each of the Cparty values. Compose Cparty contains the following expression.
//Get the forth item (index 3) and remove the 'Cparty=' text.
replace(item()[3], 'Cparty=', '')
When we run the flow, the Apply to each will iterate over our two block of rows in our array (in this example) and output the Cparty name for the current block of data.
----------
Another option, if you wanted an array of objects (key/value pairs) for each block of data, you could use a Select directly after your Filter array using the following expressions. Note that you would do this for all the properties you want to use.
//From
chunk(body('Filter_array'), 19)
//Map (Keys)
first(split(item()[0], '='))
first(split(item()[1], '='))
first(split(item()[2], '='))
...
//Map (Values)
last(split(item()[0], '='))
last(split(item()[1], '='))
last(split(item()[2], '='))
...
After running the flow you would get the following output from the Select. You could then just iterate over the Select in your Apply to each and use the key/value pairs to extract the data you need.
And the actual data. Note that I only added the first 5 properties for this example. You could map all 19 properties, or just the ones you want to use.
[
{
"$DoMenu": "mfnew",
"ticket": "12345",
"sectype": "XXX",
"Cparty": "SN02-COFFEE 1031127215",
"Entity": "XXX"
},
{
"$DoMenu": "mfnew",
"ticket": "12345",
"sectype": "XXX",
"Cparty": "SN02-COFFEE 1031103124",
"Entity": "XXX"
}
]
