insert
, update
, or delete
rows in your Postgres database.
When you’re connected to your database through the Sequin Proxy, the Proxy listens for changes. When you make a mutation, the Proxy applies the mutation to Salesforce’s API first. If the mutation succeeds, your database is updated as well. If it fails, your database mutation will be rolled back, and you’ll receive a Postgres error.
Data flows from Salesforce to your Postgres database. Your code or SQL client then reads from the database. To mutate your data, you update records in your database. Those mutations are applied to Salesforce then to your database.
With this architecture, Salesforce remains the source of truth and your database never gets out-of-sync.
insert
to create a new entry in the “Orders” table on Salesforce.200
. The body contains the new order.orders
table in your Sequin database.