Remove [ ] Brackets from single object array

Like (1) Share

Report

Posted on 7 Jan 2022 11:49:49 by Heartholme

1,278 Super User 2024 Season 1

Hello,

I have the follwing array which I get from a SQL import, filtered and is now a single object array. It is stored like this in a compose action:

[
{
"ShipmentNumber": "1005",
"Analysis1": 23,
"Analysis2": 135655,
"Analysis3": null,
"Analysis4": 0,
"Analysis5": "10",
"Analysis6": "7"
}
]

I would like to remove the brackets [ ] from the start and end of the array, since these are creating some issues and using the values further. I would like to have the array in the exact same format.

I tried the follwing:

replace(replace(outputs('withBrackets'), '["', ''), '"]', '')

But I get the follwing errormsg:

Any help would be really appriciated.

Categories:

Business Process Flows

All responses (4)

Answers (1)

Verified answer

abm abm 32,464 Most Valuable Professional on 07 Jan 2022 at 11:56:47

Like (2)

Report

Re: Remove [ ] Brackets from single object array

Since its an array you need to convert to string()

Try the following

replace(replace(string(outputs('Compose')),'[',''),']','')