Remove [ ] Brackets from single object array

(1) Share

Report

Posted on 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:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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

Try the following

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

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@abm

Thanks a lot, I learned something new.

Was this reply helpful? Yes No
letsflow 4 on at

Like (1)

Report
Copy link

Link copied!

Hello,
I am running into the same issue.
I am trying to avoid using substring as it converts the array to a string and adds additional \ which I am unable to remove when using an append-to-string action.
Is there a way to:
A) remove the array [] without converting to string, OR
B) remove \ from a string? (I have tried the following:
replace(output('actionname'),'\','')
replace(output('actionname'),'\\','')
replace(output('actionname'),'\"','"')
but none of the worked.
Thanks in advance.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I am having the same issue. Need a way to remove the square brackets without it adding backslashes. I've tried this into an array variable, which works but it cuts the dataset to a single array (from multiple): array(json(replace(replace(string(outputs('Merged_Data')),'[',''),']',''))). I think I need a way to convert it back to Json without cutting the dataset.

Was this reply helpful? Yes No