Remove Square brackets [] from a string of output from a!tojson

Question

I was sending a data in json format like { a!tojson("fruit": "apple") } but the output i was getting { "fruit": ["apple"] }but i need without square brackets . Could anyone please help me on this and thanks for advance

Stefan Helzle · Answer

You could also use the extract() function. 
 extract("[""12hg""]", "[""", """]")

Anna P · Answer

Try this 
 a!localVariables( local!text: "[""12hg""]", stripwith( local!text,"["" ""]") )

Mike Schmitt · Answer

vemasani vishnu vardhan said: inside the a!tojson function 
 What do you mean by this exactly? 
 The string "["12hg"]" (or "[""12hg""]" in escape-quoted appian expression notation) is a valid JSON string containing the value "12hg". Passing it through a!fromJson() results in the value you're looking for. I'm not sure what other complication there is here. Your original JSON message would still be untouched, since that's how Appian variables work.

nilanshum810650 · Answer

To extract this value from JSON, first you need to parse the JSON using a!fromJson() to convert it into a dictionary. After that you can access the specific key to retrieve the value.

Remove Square brackets [] from a string of output from a!tojson

Top Replies