Odoo Connector

Manage records in an Odoo database

Connections

Odoo Connection

Input	Comments	Default
Odoo Base URL	Enter the URL you visit when you log in to Odoo
Server Port	Leave blank to use default HTTP (80) or HTTPS (443)
Odoo Database Name	Click the user icon on the top-right within Odoo and then select 'My Databases'
Username
Password or API Key

Actions

Create Record

Create a new record of a given type

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.
Parameters		{ "name": "John Doe", "email": "doe@example.com", "country_code": "US", "city": "New York", "zip": "10001" }
External ID	A unique identifier mapping this record to an ID in an external system

Delete Record By ID

Delete a record by its numerical ID

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.
Record ID	The ID of the record you want. Odoo uses numbers for record IDs.

Get Record by External ID

Get a record by its external ID

Input	Comments	Default
Connection
External ID	A unique identifier mapping this record to an ID in an external system

Get Record By ID

Fetch a Record by its numerical ID

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.
Record ID	The ID of the record you want. Odoo uses numbers for record IDs.

List Model Fields

List all fields for a given model

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.

List Models

Fetch a list of models installed in the customer's Odoo database

Input	Comments	Default
Connection
Name Search	Search for models whose names contain this search term
Model Search	Search for models whose contain this search term

List Records

Fetch a list of records of a given type

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.
Pagination Limit	Fetch only this many records at a time. See https://www.odoo.com/documentation/15.0/developer/api/external_api.html#pagination
Pagination Offset	Fetch records offset by this value. See https://www.odoo.com/documentation/15.0/developer/api/external_api.html#pagination

Raw Request

Issue any execute_kw action

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.
Method	The action to execute in Odoo
Parameters		[["read"]]

Set External ID

Add an external ID to a record that does not have one

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.
Record ID	The ID of the record you want. Odoo uses numbers for record IDs.
External ID	A unique identifier mapping this record to an ID in an external system

Update Record

Update an existing record of a given type

Input	Comments	Default
Connection
Model	The type of record you would like to query for. Use the 'List Models' action for a list of available models.
Record ID	The ID of the record you want. Odoo uses numbers for record IDs.
Parameters		{ "name": "John Doe", "email": "doe@example.com", "country_code": "US", "city": "New York", "zip": "10001" }