| Active |
|---|
| This application does not need additional settings. So you can make connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). only by using your login credentials or by following the instructions below . |
![[Important]](https://docs.boost.space/wp-content/themes/bsdocs/docs-parser/HTML/css/image/important.png) |
Important |
|---|---|
|
Any references to third-party products or services do not constitute Boost.spaceA platform that centralizes and synchronizes company data from internal and external sources, offering a suite of modules and addons for project management, CRM, data visualization, and more. Has many features to optimize your workflow! Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice. Boost.space does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems. |
The PostgreSQL modulesa module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. let you execute your custom logic directly in your database server through functionsFunctions you can use in Boost.space Integrator - create, update, delete, get, search.. Boost.space IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. loads interface of input and output parameters dynamically so each parameter can be mapped individually.
Here is a sample SQL statement that creates a functionFunctions you can use in Boost.space Integrator - create, update, delete, get, search. that just simply inserts the values passed in the three parameters into a table:
CREATE OR REPLACE FUNCTION insert_record_from_Boost.space Integrator(_name character varying,_email character varying, _phone character varying) RETURNS void LANGUAGE 'plpgsql' AS $BODY$ BEGIN INSERT INTO contacts (name, email, phone) VALUES (_name, _email, _phone); END; $BODY$;
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.
Boost.space Integrator will make connections to your database from specifc IP addresses. Our servers are set up with valid PTR recordsIn Boost.space, a record is a single data entry within a module, like a row in a database. For example, a contact in the Contacts module or a task in the Tasks module. so you can easily restrict access by allowing %.make.com.
This errorService is unavailable due to a failure, a service responds with unexpected data or the validation of input data fails. occurs when you modify the same data using multiple modules. It is caused by SQL transactions.
When any SQL modulea module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. is executed then it starts the transaction (1) and the transaction is finished after the scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. is fully executed.If another module tries to access the same data used in another unfinished transaction (1) then it has to wait until the previous transaction (1) is finished – but it never happens because the first transaction (1) will be finished after the scenario is finished.
Solution
Turn on Auto-commit. It finishes (commits) every transaction immediately after the module execution is done.
-
Open Scenario settings.
-
Enable theAuto commitThe Auto commit option defines how Boost.space Integrator processes data transactions. Enabling Auto commit switches all operations to the commit phase. In the case of an error, data commits immediately and you cannot restore any lost data. checkbox.
-
Confirm the settings dialog by clicking the OK button.
