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

Powiązane posty	Odpowiedzi	Widoki
Disable Odoo.sh CI Testing Rozwiązane server github odoo.sh	1 paź 25	436
"413: Request Entity Too Large" error in odoo.sh Rozwiązane server portal odoo.sh	1 kwi 25	2572
[v12] adding field to res_partner breaks odoo.sh instance Rozwiązane odoo.sh v12 upgrad	3 sie 21	4523
I can't connect odoo installed on web server community server v12	0 gru 19	61
I can't connect odoo on cloud server community server v12	0 gru 19	52

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!