We use the JSON aggregator to create a JSON file that is used as body in a API request. The JSON aggregator is adding “[” at the beginning and “]” at the end of the string. This is causing an error in the API request. How can we prevent the JSON aggregator from doing this?
You can use the substring function in order to get rid of the unwanted
[ ] brackets generated by the JSON aggregator.
How to configure the function:
The function ‘translated’ into words:
From the text (in this case a JSON string), give me only characters 1 till the end of the string minus one character (length -1)
The code to copy:
; 1; length(211.JSON String
) - 1)}}