Destinations are on the other side of sources. They are applications and databases that you send data into, and can be the same application or database as a source.

Adding a destination

Destinations, like sources, are automatically created by Operator when you connect an application or database. Operator will let you choose connections that are enabled with write access to be destinations, so there is no further step to specifically add a destination.

Choosing a destination

Choosing a destination for your data requires you to set 3 fields: App, Resource, and Operation.
The "App" field refers to the various applications and databases you have connected that can receive data, such as different Quickbooks accounts.
Depending on which App you pick, the types of Resources you can choose will change. Resources are specific entities under the App that you can create or update. In the example below, Quickbooks stores details on your Customers, Vendors, Purchases, and more. Each of these are a Resource, and you can make a new one (insert) or update an existing one (insert) based on which operation is chosen in the third and final field.

Updating data

We will first cover updating data. Updating data means there is an existing data object that you want to modify.
This requires one field, the ID of that data object (such as the ID of a customer or vendor). All other fields that you want to update are optional.
In this example, say we want to update the amount of a transaction. Then we can add an optional field and pick the appropriate app column that corresponds with the amount. For purchases, this would be the TotalAmt field as in Quickbooks that field refers to the amount of a purchase.
Once the appropriate app column is picked, then a query column must be mapped to it. The query column is the results of your SQL query, the outputs you saw in the preview. So choose the name of the column in the preview that contains the updated amounts.
Now that your mappings are set, press "Save Sync" and a message will pop up asking you to confirm the sync. This message contains JSON representation of one example of the data that will be sent, so take a look then confirm.
Now press the "Sync" button in the top right part of the screen, and it should take you to the Logs screen.

Inserting data

To insert data means to create a new data object in the destination, rather than modify an existing one. This means a lot more fields will be required than just the ID.
Just like updating, pick your app, resource, and set "Insert" as the operation. We will insert data into Google Sheets for this example.
For Google Sheets, things are a little different. The Resource refers to a Google Sheets file in the Google Drive account you've connected. The Table field refers to a specific sheet inside that Google Sheets file.
When inserting new data into a spreadsheet,
Last modified 7mo ago