Odoo provides an external API to expose its data to the outside world. This makes getting, modifying, and even executing functions of models possible. The main way to access this API is via XML-RPC or JSON-RPC. We completely integrated this API in our XQTING Integration Engine
so that via the low code scripting, you can easily interact with your Odoo system.
The operations provided are:
- Reading (one or more fields) of a record
- Creating records
- Updating fields of a record
- Deleting records
- Executing methods defined within an Odoo model
For ease of use, The XQTING Integration Engine allows us to configure one or more Odoo environments. Each environment gets a name and the required configuration parameters:
- The id of the Odoo user
- The password of the Odoo user
- The name of the database that the Odoo instance is using
- The URL of the Odoo instance
Configuring multiple environments allows for quickly switching between them, if needed, and would even allow you to integrate or connect multiple Odoo systems.
The XQTING Integration Engine provides predefined functions to access our Odoo instances. As with other integrations, the functions calls have a common structure. Example
Let's say we want to synchronize MsGraph contacts with Odoo users. We use the MsGraph module and the Odoo module in the XQTING Integration Engine. Configuration
As Odoo is the focal point of this article, we will only cover the configuration of this module. Imagine your company is called 'MyCompany' and you have an Odoo instance with the same name. The database where the Odoo instance is running on is named 'my-company-odoo-db' and the URL used to access this instance is 'https://mycompany.com/odoo
'. Lastly, you are a user in that Odoo instance with user id 15 and password 'pwd123!'. In the engine.js file, we configure all this information once.