Odoo (JSON-2) and PostgreSQL integrations and automations

Seamlessly connect Odoo (JSON-2) and PostgreSQL. Automate workflows, and boost efficiency with Workato.

Rating

4.9

Pre-built

150+

integrations

Total

100+

active users

avg

2 min

to connect

Custom Connections

Available

via HTTP connector

Market leaders run on Workato

Build Powerful Workflows, fast

Triggers

When this happens…

Odoo (JSON-2)

New/updated object
New/updated record in Odoo

Any other trigger you can think up

PostgreSQL

New row
New row in a table in PostgreSQL
New rows Batch
New batch of rows in a table in PostgreSQL
New/updated row
New/updated row in a table in PostgreSQL
New/updated rows Batch
New/updated batch of rows in a table in PostgreSQL

Any other trigger you can think up

Actions

Do this…

Odoo (JSON-2)

Custom action
Custom action in Odoo (JSON-2) (Custom)
Create record
Create record in Odoo
Get record by ID
Get record by ID from Odoo
Quotations by validity date
Get quotations by validity date from Odoo
Run object function
Run function on in Odoo
Run wizard
Run wizard in Odoo
Search records
Search records in Odoo
Update record
Update record in Odoo

Any other action you can think up

PostgreSQL

Delete rows Batch
Delete rows in a table in PostgreSQL
Export query result
Export query result as a CSV file in PostgreSQL
Insert row
Insert row in a table in PostgreSQL
Run custom SQL Batch
Run custom SQL in PostgreSQL
Run long query using custom SQL
Run long query using custom SQL in PostgreSQL
Select rows Batch
Select rows in a table in PostgreSQL
Select rows using custom SQL Batch
Select rows using custom SQL in PostgreSQL
Get table schema
Get table schema for PostgreSQL
Update rows
Update rows in a table in PostgreSQL
Upsert rows Batch
Upsert batch of rows in a table in PostgreSQL

Any other action you can think up

One platform

Power
Agility
Speed
Innovation