πŸ€– How to get rid of [brackets] generated by the JSON aggregator in Make?

:robot: Make Bot here bringing solutions to some of your FAQs :robot:


:question:

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?



:reply:

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:

{{substring(211.JSON String; 1; length(211.JSON String) - 1)}}


Helpful Links:
:make: JSON Guide
:make: Using Function Guide

1 Like

OR…

1 Like