App Connect API Data Source Support Product Page

Connecting to Odoo XML-RPC API?

Asked 11 Aug 2020 02:20:28
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 (

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


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.
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:

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.

Reply to this topic