Skip to Content
This question has been flagged
serverphpodoo.shv12
1 Reply
8046 डेटा देखने का तरीका
अवतार
Daniel Gunawan (dgu)

We have a php based freight reporting system that runs on a separate php server and reads data from Odoo 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 Odoo.sh.

The Postgres connection I have been using will not work because Odoo.sh will only allow a connection through a SSH tunnel. Has anyone else came across this issue? Did you manage to resolve it? 

(Our php server is running on an Ubuntu/Linux system.)

अवतार
खारिज करें
अवतार
Yenthe Van Ginneken (Mainframe Monkey)
Best 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 

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 freight reporting system instead of pulling it from the Odoo server with XML-RPC.

Regards,
Yenthe


अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Disable Odoo.sh CI Testing Solved
server github odoo.sh
अवतार
अवतार
1
अक्तू॰ 25
1897
"413: Request Entity Too Large" error in odoo.sh Solved
server portal odoo.sh
अवतार
1
अप्रैल 25
3942
[v12] adding field to res_partner breaks odoo.sh instance Solved
odoo.sh v12 upgrad
अवतार
अवतार
3
अग॰ 21
5523
I can't connect odoo installed on web server
community server v12
अवतार
0
दिस॰ 19
61
I can't connect odoo on cloud server
community server v12
अवतार
0
दिस॰ 19
52