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

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]

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.