Discord Webhook

[thiago_tcr]

Hi!

Need some help with a webhook configuration. I used to have an integration with Make, monitoring my GoogleSheet (was my "database" at the time) and every addition to that table, a message with the ID and Date would be sended to Discord.

Now I´m connected to Postgres, and trying to configure a webhook. Already got task and process figured out and message is working on Discord every time I add a row to the table.

I´m struggling to reference the columns from the table cause I just coppied the Json body format from Make:

{
"content" : "**New Order Request** \nID: {{3.`2`}}\nDate: {{3.`3`}}"
}

where {{3.`2`}} and {{3.`3`}} is referencing two columns from the table, so i get a result like this:

Can´t find any documentation on how to replace with elements referencing the table column, already tryied "<<[COLUMN_NAME]>>", but apparently it reads the first row instead of the one I´ve just added.

[SkrOYC]

---

@thiago_tcr wrote:

already tryied "<<[COLUMN_NAME]>>",

---

Post the whole JSON body that you tried and failed in order for us to help

[thiago_tcr]

Sorry,!

here it is:

{

   "content" : "**New Order Request** \nID: "<<[ID_ORDER]>>"\nDate: "<<[DATE]>>"

   }

[SkrOYC · Accepted solution]

I see.
Try:

{
 "content" : "**New Order Request**\nID: <<[ID_ORDER]>>\nDate: <<[DATE]>>"
}

[thiago_tcr]

Thanks @SkrOYC for the reply. 

It reads the data from the table, but it seens to always get the first row instead of the last added one.

[SkrOYC]

That's quite a werid behaviour.
Does this bot have an event tied to Adds only?

[thiago_tcr]

Yes, 

But found out what is going on! your solution is perfect! Each time a create an order, it´s creating it twice in DB. 

Thanks again for the reply.