Hello @jvanoy3,
There are multiple ways we can use and apply to create json strings from your dynamic data.
Using Text Aggregator
Check this response from @Bjorn.drivn
At the end the output is a just JSON string so be sure to Parse it if it’s needed in your next steps.
Using JSON Aggregator
Steps need to follow
-
Get data from your sheet. (Most of the time sheet itself supports default iteration within it, If it doesn’t iterate then only add Iterator after the sheet module)
-
Use JSON Aggregator (Need to set basic structure for your JSON data to get)
- Read more about JSON https://www.make.com/en/help/tools/json
- Read more about Data Structure in JSON https://www.make.com/en/help/tools/data-structures#data-structures
-
JSON Aggregator return JSON string and parses it if required.
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution
and
Need expert help or have questions? Contact or comment below!