Adding to a HTTP body

[jvanoy3]

Hey everyone!

I have a HTTP body that includes addresses. I am now wanting to use addresses from a google sheet to be put into that Body. How can i make this happen?

Attached is the currently working Body command (Names and addresses are made up). Ass you can see, this body has three addresses in it. Lets say i want to replace these addresses with 5 addresses from a google sheet. How would you go about doing so?

{

“addresses”: [

{

“title”: “Tinisha Pesina”,

“address”: “2986 Walnut Hill Ln, Dallas, TX 75229”

},

{

“title”: “Josphine Gregorio”,

“address”: “609 E Plano Pkwy, Plano, TX 75074”

},

{

“title”: “Wilfred Bresett”,

“address”: “18101 Coit Rd, Dallas, TX 75252”

}

]

}

[dilipborad]

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

Aggregate items into a JSON collection

@Kevin_Flaherty You can use a text aggregator? Or is it a different kind of value you are looking for. [Screenshot 2022-11-07 at 23.19.21] Here you setup the JSON, which then looks like this: [Screenshot 2022-11-07 at 23.19.15] You only have to add another opening and closing brackets for the JSON.

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!

[jvanoy3]

But Google sheet modules return data in the form of an collection (Seen in attached photo). How do i create a data structor when it is in that format?

[dilipborad]

Hello @jvanoy3,
Please also share your Actual GSheet screenshot and share the output of the Make’s Sheet module.
Put that output like this for readable JSON data.
``` Output ```