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
"413: Request Entity Too Large" error in odoo.sh Rozwiązane server portal odoo.sh	1 kwi 25	1453
[v12] adding field to res_partner breaks odoo.sh instance Rozwiązane odoo.sh v12 upgrad	3 sie 21	3659
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
How to access sudo on Odoo.sh? v12 sudouser odoo.sh v12	3 sie 19	9347

To pytanie dostało ostrzeżenie

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