The PostgreSQL modules let you execute your custom logic directly in your database server through functions. Integromat loads interface of input and output parameters dynamically so each parameter can be mapped individually.
Here is a sample SQL statement that creates a function that just simply inserts the values passed in the three parameters into a table:
CREATE OR REPLACE FUNCTION insert_record_from_integromat(_name character varying,_email character varying, _phone character varying)
INSERT INTO contacts (name, email, phone) VALUES (_name, _email, _phone);
To learn more about creating functions, see PostgreSQL documentation.
Make sure the account you're using to connect to your database has read access to 'information_schema.routines' and 'information_schema.parameters' tables.
Integromat will make connections to your database from the following IP range:
18.104.22.168. Our servers are set up with valid PTR records so you can easily restrict access by allowing