App Connect API Data Source Support Product Page
Connecting to Odoo XML-RPC API?
Asked 11 Aug 2020 02:20:28
1
has this question
11 Aug 2020 02:20:28 Kent Angel posted:
I'm wondering if you can clarify if it is possible to connect to the Odoo XML-RPC API directly using the DMX API data source extension?I'm reading through the API documentation (www.odoo.com/documentation/12.0/webservices/odoo.html)
There IS a way to connect using "Java", but can't figure out how to configure through the App Connect panel OR, if I need to setup a custom connector to connect DMX through
Replies
Replied 11 Aug 2020 07:59:17
11 Aug 2020 07:59:17 Teodor Kuduschiev replied:
Hello Kent,
Your API needs to return the data in a JSON format in order to be able to use it with our API tools.
XML data sources are not supported.
Your API needs to return the data in a JSON format in order to be able to use it with our API tools.
XML data sources are not supported.
Replied 26 Aug 2020 14:19:29
26 Aug 2020 14:19:29 Kent Angel replied:
Hi Teodor,
I found the jsonrpc api for Odoo and have installed it:
github.com/odoo/odoo-client-lib
Unsure how to configure the DMX app connect settings to connect to it though.
I've set a "content-type" header to "application/json" and entered the parameters in app connect for url, hostname, database, login and password
The error I get back when fetching the schema is :
Server returned code: 400
Error <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <title>400 Bad Request</title> <h1>Bad Request</h1> <p>Invalid JSON data: ''</p>
I found the jsonrpc api for Odoo and have installed it:
github.com/odoo/odoo-client-lib
Unsure how to configure the DMX app connect settings to connect to it though.
I've set a "content-type" header to "application/json" and entered the parameters in app connect for url, hostname, database, login and password
The error I get back when fetching the schema is :
Server returned code: 400
Error <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <title>400 Bad Request</title> <h1>Bad Request</h1> <p>Invalid JSON data: ''</p>
Replied 26 Aug 2020 14:37:37
26 Aug 2020 14:37:37 Teodor Kuduschiev replied:
The error says that the data is not properly formatted or not in a JSON format.
Your API response must be a valid JSON.
Your API response must be a valid JSON.