Answered

Remove value in each key of JSON object

(0) Share

Report

Posted on by PR001

Hi all - i am looking to remove any spaces that may be a value in a JSON object. Would anyone know the most efficient way to do this without having to declare each key in a Compose statement? Perhaps by looping through each key? Thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@PR001

You should be able to do this is one action that runs in under a second.

Use a Select action on the JSON array.

Switch the Select Map input to a single input box instead of a table.

Use a setProperty( ) expression on the item() https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#setProperty

Use the name of the key for the property name, then for the value use a replace(item()?[‘InsertKeyName’], ‘ ‘, ‘’)

The Select has an internal looping that will go over each object in the JSON array & set that key property value to the new value without spaces.

Was this reply helpful? Yes No
PR001 28 on at

Like (0)

Report
Copy link

Link copied!

Thank you Takolota. What if i have to replace the value for all the keys in the JSON array? Specifically, I would like to remove all special characters from the JSON array. Thanks again!

Was this reply helpful? Yes No
Verified answer

takolota1 4,980 Moderator on at

Like (1)

Report
Copy link

Link copied!

@PR001

For all keys/values, as long as the special characters do not include the JSON array structure characters like “ , : { } [ ] then I would just use a single Compose &…

Use string( ) on the entire JSON array

Outside the string expression add multiple replace( ) expressions, one for each special character to remove.

Outside all the replace( ) expressions use a json( ) expression to return it back from a string to JSON.

Was this reply helpful? Yes No
PR001 28 on at

Like (1)

Report
Copy link

Link copied!

Great makes sense. Thank you sir!

Was this reply helpful? Yes No