Odoo

Estimated reading time: 14 min
Odoo banner

Odoo is a powerful business management platform, and it can be even more powerful when integrated with other applications. This allows you to automate tasks, streamline your workflows, and get a more complete view of your business.

Wiresk makes it easy to connect Odoo to any application that has an API, including CRM systems, marketing automation platforms, and accounting software.

A screenshot of the group management page in the Wiresk platform. It shows a list of groups with their name, key, flow count, and flow execution status. There is a search bar and a button to create a new group.

The group system in Wiresk is a way to organize and manage your users and Flows.

When you start with Wiresk (Admin account), you are automatically assigned to the default group. This default group can be renamed.

for users with Pro plan or higher, you can:

  • Assign users to specific Flows: Control who has access to and can edit different Flows.
  • Organize Flows: Group related Flows together for better management and visibility.
  • Manage permissions: Set permissions for different groups, determining who can create, edit, and view Flows.
  • Collaborate effectively: Facilitate collaboration among team members by assigning them to appropriate groups.
For more details about Group and Users, refer to Group system.

There are two ways to connect your app to Wiresk:

  • In “My apps” section, where you can manage your connections (select or create your group first to get access to this section, refer to the Group system ).
  • While building your Flow, you can easily establish a connection to your app directly within the Flow builder. This can be done during the setup of either a Trigger or a Method.

In this documentation, we will explain how to create a connection in “My apps” section, it is essentially the same as when creating it on-the-go.

Prerequisite:  
You must have an Odoo Account, create one here
Create a Database and use users’ credentials to create a create a connection in Wiresk. 

go to “My apps” and click on the (+) button. 

Search “Odoo” in the search field or scroll down the list of apps and choose the Odoo icon.

Screenshot of Wiresk add apps screen. Red arrows shows where to search for Odoo app. one arrow point to Odoo icon.

On the new prompted screen:

Screenshot of Add apps screen, this show the setting for Odoo connection with numbered red arrows pointing to different fields.

1 – Give a name to your connection

2 – Enter your Odoo Instance URL

(For example, the link of your Odoo domaine is https://wiresk.odoo.com/odoo, your Instance URL is https://wiresk.odoo.com)

3 – Enter your Odoo Database Name, this name is also in your Odoo Instance URL, for example, https://wiresk.odoo.com, wiresk is your Database name

4 – Enter the Odoo Username (User’s credentials from the Database)

5 – Enter the Odoo Password linked to your username

6 – Click on “Create App” button, voila! Your Odoo app is now created in Wiresk.

Use this Connection to create your Flow with Odoo.

After linking Odoo to Wiresk, you can start creating your Flows.

Select your Group, then on the Flow management screen click on “Create Flow”.

Animated image GIF, shows where to click to create a Flow in Wiresk. first select a group then click on create Flow.

On the new screen, name the Flow that you want to create.

Add your Trigger by clicking on the red plus (+) button.

Screenshot Flow creation screen, Red arrows shows where to name the Flow and add a Trigger.

On the Trigger selection screen, search your app or select it from the list below the screen.

Screenshot of Trigger search and selection. White background, arrows that point to search field and all app list.

On the new screen, select your specific Trigger then configure it (refer to Trigger settings below).

As mentioned in “How to connect your app to Wiresk” above, during your Trigger settings, you can create a new connection to your apps at this stage.

An HTTP Trigger allows you to manually activate your Flows.

  • One-time tasks: For tasks that only need to be performed once, like sending a specific notification or updating a database record.
  • Ad-hoc actions: For actions that need to be triggered on demand, without relying on scheduled events or data changes.
  • Testing and debugging: For testing and debugging Flows without relying on external events or conditions.

Click on the red plus button (+) again to add a Trigger for testing your Flow, then click on the button “HTTP Trigger”.

Screenshot of Wiresk HTTP Trigger selection. in manual configuration section, an arrow point to HTTP Trigger.

Write a description and select your API key or create a new one.

Click on save.

Now you can use your HTTP Trigger to Manually run your Flow.

Screenshot of HTTP Trigger setting screen. Arrows shows fields that need to be filled and selected for the settings. User need to add a description, select or create an API key.

The Method will perform a specific task on a particular app or service you’ve connected to Wiresk like get info or send emails.

You can add at least 1 or multiple Methods for complex Flows (a maximum of 255 Methods).

On the Flow builder screen, click on the plus button (+) next to the Trigger icon.

Screenshot of Wiresk Flow Builder, showing Trigger icon and arrow pointing to a plus button. This button is use to add Methods in Wiresk.

Search or scroll down to select the Methods from your favorite apps. Refer to Methods list and settings in this documentation.

If you want to build a complex Flow, Wiresk offers a selection of tools at your disposal. Refer to Wiresk’s Tools

To add Tools in your Flow, Follow the same step as adding the Methods. On the Flow builder screen, click on the plus button (+) then just click on the “Tool” tab and select the Tool that you want to add.


What will start your automation…

Depending on your Flow scenario, you can set up multiple Triggers. However, only one Trigger can be active at a time.

Setting up the recurrence rule or scheduler of your Trigger (if the Trigger is not a Webhook):

  • Regular intervals will monitor your Trigger by intervals in minute
  • Daily recurrence will monitor your Trigger by day and hour
  • Monthly recurrence will monitor your Trigger every month on a defined date and hour
  • Yearly recurrence will monitor your Trigger on a specific date and hour every year
  • Specific dates will start your Trigger on specific dates

After setting up the Trigger parameters (refer to how to define your parameters in the steps below), click on “Get sample”.

The “Get sample” allows you to extract a subset of data for validation. The data will be used to MAP your Method parameters according to your Flow. Refer to FIELD MAPPING documentation.

Here, you will find all Odoo Triggers available in Wiresk with their parameter descriptions.

Run your Flow at a Specific time or intervals automatically instead of being triggered manually or by events like Webhooks.

Retrieve multiple records from Odoo Database using Wiresk’s Query Builder.
A Query Builder allows you to create complex SQL queries without having to write any code.
This allows non-technical users to easily access and analyze data with a graphical user interface.
✓ When This Trigger is activated, the result of the Query can be use to Map your Methods.

Configuration Table:

Name*Retrieve Records using Wiresk’s Query Builder
Connection*Select your connection or create one Refer to how to create a connection.
Time outYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence rule/scheduler*Set up your recurrence rule
Parameters
Entity* (Set of data that contain records)Select the Entity where the data records are located.
For example, “Calendar event”, “Email Thread”, or “Companies”.
Related EntitiesThis section allows you to link related entities in Odoo to the primary entity you are querying. For example:
If you’re querying “Email Thread,” you might want to include related records such as the “Contact” or “Companies” associated with each Email Thread.

Clicking “Link an entity” will let you select and define relationships between the primary entity and its related entities.
Configure FilterThis tab enables you to define specific criteria to narrow down the records being retrieved.
Configure groupingThis tab allows you to group the retrieved records based on certain attributes or fields.
Configure Columns

Preview Data


Number of records:10

Begin at record:0

Edit Columns

Configure Sorting
Configure which columns or fields of data will be retrieved and included in the output.

To visualize the records. You must select at least 1 Columns to get the Preview Data.
If you get this message:” Cannot convert undefined or null to object”, it means there is no records.

By default, 10 records will be shown

The display starts at record 0

Customize which columns are displayed and retrieved. Minimum 1 column, maximum 50 columns.

This option is for sorting the data in the columns by Ascending or descending order.

(*) required field

Before saving your Trigger, don’t forget to use “Get Sample”.


What your automation will do…

Here, you will find all Odoo Methods available in Wiresk with their parameter descriptions.



After setting up your Flow, you can choose to:

  • Run once”, your Flow will run only a single time. You can use this function to test your Flow. Refer to how to set up an HTTP Trigger, in the Trigger setting step.
  • Run Scheduler” will automate your Flows with the recurrence rule you previously defined.


For more details, refer to How to run a Flow tutorial in our Help Center.
 
If you are using a Webhook Trigger, the Flow will initiate automatically when a webhook is received from your connected apps. This means that the Flow is automated without a scheduler and will run until you deactivate the Flow manually. Refer to Webhook documentation in our Help Center.

Wiresk makes things easier for you! Check our Templates Gallery to discover various ready to use cases.
If you need an integration that you cannot find in Wiresk, you can make a request to our team, and we will try our best to satisfy your needs.