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

[sumisha]

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