Hello,
I want to create a scenario where I am listening to a new row being added to my table in the DB of PostgreSQL.
Once the row is added, I want to take some data from the row to send a WhatsApp message.
I will be glad to get any help
Welcome to the Make community!
Short answer: It might be possible, but it will require lots of effort.
Long answer:
Make doesn’t have a module to “Watch” for new items in PostgreSQL.
You can suggest for it to be made in the Idea exchange. Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.
It might be possible to do it with the “Execute a query” module to get the latest items, and see if the row’s timestamp is greater than the last time the scenario was run. However I won’t be able to help with that since it will take time.
Alternatively, you can use other databases that has a “new items” trigger. You can find alternatives on https://www.make.com/en/integrations/category/databases?community=1&verified=1
Hope this helps! Let me know if there are any further questions or issues.
Note: I see hundreds of posts, notifications, and messages daily on this forum, so if I missed your reply, please message me to look at your reply.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
1 Like
Hi
Thank you for your quick response
I heard that I can send HTTP requests from my server directly to make
and in Make, I have a HTTP request module - am I right?
Unfortunately, I can’t use with another DB , the company already build the product that contains the customers in this DB.
I am sure that there is a solution , no?
If you want to send requests to Make, your scenario needs to begin with a Custom Webhook trigger module. This will provide you with a URL that your server can call.
Hope this helps! Let me know if there are any further questions or issues.
Note: I see hundreds of posts, notifications, and messages daily on this forum, so if I missed your reply, please message me to look at your reply.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
What do you mean by custom webhook?
Can you share with me example or link that I can read and will give me some insights?
Sure, see the Webhook links below.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Getting Started
- Help Centre | Tutorials – Make “Manual”
- Make Academy – Basics 101: Learn Make and get certified
Help Centre Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Date Format: tokens for
parseDate| tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
- How to use Regex in Make - How to use pattern matching to extract the text you want
- Webhooks – Make Academy – tutorial on how to use Webhooks
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Can you setup a search using the PostgreSQL app to search for a row being added with some sort of known criteria? This can be scheduled to run on a repeated basis monitoring the data. You may also be able to use the advanced search module to do a more complex search.
–
Alex Sirota
Director of NewPath Consulting
1 Like
I think @samliew and @alex.newpath have the right idea with polling your server for new rows using Execute a Query.
Hopefully you have a column in your database indicating when the record was created, and if possible, a field to indicate when your Make scenario has read the record and done something with it so you don’t run your process multiple times on the same record.
After reading and processing a set of records (and optionally marking them as processed in the database), store the most recent created date/time in a Data Store.
When the scenario runs, read that value from the Data Store and only query records that were created after that date/time.
1 Like
Thank you guys!
I found a way
I created a custom webhook that generates a URL
On the other hand, I made a POST API request from Postmane Tool that is listen to the URL from Custom Webhook
It’s work fantastic, I get the new data that arrives.
I just need to create the API from my PostgreSQL on new row is added and it’s will work fine
3 Likes
Thank you so much!
It’s absolutely helped me! 