Connecting Odoo.sh to a php server

Question

We have a    php  based    freight    reporting   system that    runs   on a    separate    php  server and    reads data from   O  doo    and other    tables to provide a quick    searchable   summary of inwards and outwards goods.     I am looking for a    method   to connect our    php  server to read the tables which are now housed on    O  doo.sh.
The Postgres connection I have been using   will not work because    O  doo.sh will only allow a connection through a SSH tunnel.    Has anyone e

Yenthe Van Ginneken (Mainframe Monkey) · Answer

Hi Daniel,
While you can't create postgreSQL connections to the Odoo.sh instances you can use xml-rpc calls. You can code your own XML-RPC calls for all the data you need from the database tables. You can find more information about the API's at  https://www.odoo.com/documentation/12.0/webservices/odoo.html [1]
Alternatively you could also do it the another way around by creating a module on your Odoo.sh environment. This module could then do calls to your PHP server to 'push' data to the freigh

Gerelateerde posts	Antwoorden	Weergaven
Disable Odoo.sh CI Testing Opgelost server github odoo.sh	1 okt. 25	426
"413: Request Entity Too Large" error in odoo.sh Opgelost server portal odoo.sh	1 apr. 25	2567
[v12] adding field to res_partner breaks odoo.sh instance Opgelost odoo.sh v12 upgrad	3 aug. 21	4515
I can't connect odoo installed on web server community server v12	0 dec. 19	61
I can't connect odoo on cloud server community server v12	0 dec. 19	52

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!