Connecting with RESTFUL API of Odoo to get table data and performing CRUD operations on it.

AppSheet AppSheet Q&A
, , ,
1

We want to integrate Odoo’s RESTful API with AppSheet. The goal is to retrieve data from specific tables in Odoo and display it within an AppSheet app. Additionally, We want to perform CRUD (Create, Read, Update, Delete) operations on this data directly from within the AppSheet interface, with the changes being reflected back in Odoo.

We are going for this approach to limit the data being fetched from the DB and optimize our queries.

Could you please provide guidance on the following:

  1. Setting Up the API Connection:

    • What is the best way to establish a connection between AppSheet and Odoo’s RESTful API? Can we connect with API’s directly or do we need paid services like Apigee or convert the data to Odata format. Also right now we are on Core plan do we need to upgrade to Enterprise to connect Restfull Api directly?

  2. Performing CRUD Operations:

    • Are there any limitations or considerations for performing CRUD operations (Create, Read, Update, Delete) when performing these operations through AppSheet?

  3. PFA Screenshot where it is written that REST APIs connection is available in Enterprise plan. Please confirm

    Screenshot from 2024-08-21 16-54-57.png
    Screenshot from 2024-08-21 16-54-57.png1367×469 29.6 KB

1 Like
2

First, you should know that APpSheet currently does not support request/response type API calls - meaning you cannot send a request to an external API for a set of data to be returned.

Presently you can either:

  1. Submit data to the external API
  2. Or if possible have that external API submit data into AppSheet - using AppSheet API.

However, all is not lost. There are ways you can implement the request/response.

  1. Create an Google App Script. AppSheet can call the script which then interacts with the external API in request/response fashion. The script could then call AppSheet API to submit the returned data (which would allow for automations to perform additional activities) OR the script could just insert directly in the sheet or database used as the app datasource.

  2. You can look into using an integrator service (e.g. Make). There services have connectors to many different systems and then allow you to build a bridge process between AppSheet and that external service. Make does have AppSheet integration built-in. Others might as well. You would have to check if they have support for Odoo’s API.

I hope this helps!