Skip to main content

Odoo

Plecto HelpFeaturesIntegrationsIntegration guides

Step 1: Get your Odoo credentials

First, you need to find your Odoo username, API key, Server URL, and database name.

Username

Username is the name of the Odoo user. You can find it on the Change Password page in Odoo.

  1. Open Odoo, then go to Settings > Users & Companies > Users.

  2. Choose a user, then click Action > Change Password.

API Key

  1. Click on your profile in the top-right corner, then click Preferences.

  2. Open the Account Security tab.

  3. Click New API Key under Developer API Keys.

  4. Enter a key description, for example, Plecto.

  5. Click Generate Key. Make sure you store the key securely – you won't be able to access it again.

Server URL

The server URL is your domain. For the cloud version of Odoo, it could look something like mycompany.odoo.com

Database name

For the cloud version, the database name is the subdomain. In the example mycompany.odoo.com, the subdomain is mycompany

Step 2: Create Odoo data sources in Plecto

  1. In Plecto, go to Data management > Data sources > + New data source > Odoo.

  2. Fill out the details, then click Next.

  3. Choose the data types you want to import.

  4. (Optional) Expand the Advanced settings to change the data source title, default date field used in formulas, or other settings. You can access the settings also after you've created the data source.

  5. Click Next to finish and import your data.

How to set up automatic registration deletion with webhooks

It's possible to configure deletion webhooks between Plecto and Odoo. It means that whenever you delete data in Odoo, it will also be deleted from Plecto.

Requirements

To use this feature, you need to purchase the following extensions from Odoo:

How to configure deletion webhooks

  1. Open your Odoo data source settings in Plecto and click Refresh webhooks.

  2. You will see a yellow warning message containing a callback URL. Copy the link.

  3. In a new browser tab, open Odoo and go to Settings > Technical > Webhooks.

  4. Click NEW in the top-left corner.

  5. Fill out the following details:

    1. Webhook name, user, secret, model, format, language.

    2. Paste the link you got from Plecto in the Callback URL field.

    3. Leave the Fields field blank.

  6. Under Event, select On Deletion.

  7. Click the little cloud icon next to the heading (Webhooks / New) to save the webhook.

Your deletion webhooks are now all set up! 🎉

Available data types

There are no predetermined data types to choose from. Odoo can be used in many different ways, and since Plecto integrates with everything, we cannot provide you with a complete list of data types – that depends on your Odoo account.

You will see your list of data types when you create an Odoo data source in Plecto. For each data type you import, Plecto will create one data source and store it under Data management > Data sources.