Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
1 Vastaa
2551 Näkymät

Hi everyone,

We're looking for a way to write data to an external database each time a record is created.

- I tried setting up Zapier to add a trigger each time a record is created, but Zapier doesn't seem to be compatible with Odoo.sh

- Then explored the possibility of connecting to the Odoo instance via the XML-RPC API, but I guess with this option I should be querying the Odoo instance in an infinite loop to check for new records?

- Trying now to just edit the Python code of the model to add a small script that sends the data to the external database each time a record is created. Is it possible to edit the source code of a model created with Studio on Odoo.sh?

Thanks!

Avatar
Hylkää

Any record or a specific type of record?

Tekijä

Hi Oliver, this is for a specific type of record

Paras vastaus

Would not db replication solve this more easily?

###

The process of copying data from a PostgreSQL database server to another server is called PostgreSQL Replication. The source database server is usually called the Master server, whereas the database server receiving the copied data is called the Replica server.

Avatar
Hylkää
Tekijä

Hi Kim, that will definitely solve the problem. Can this be done with Odoo.sh?

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
1
jouluk. 24
1328
1
kesäk. 19
4579
1
kesäk. 25
656
2
elok. 24
2065
1
huhtik. 19
4577