How can I GET json from an external database, to Odoo.... I see everywhere they talk about getting data from the odoo database through an API, but i want to GET external data into odoo through an url API.. in other words, I dont want to connect to Odoo, I want to conect from odoo to another external database that is nothing to do with odoo and extract the data from that database into odoo

Hi Chris,

Other ways by which you can do so is to use the methods of XMLRPC or JSONRPC with which you don't require the use of module to work with it.

You need to create a python script, authorise the user who has access to the database and use the in built methods in the rpc to search the records based on your domain.

For reference: https://www.cybrosys.com/odoo/odoo-books/odoo-15-development/ch14/

Regards