Configuring Platform Data Sync

Rutter offers a flexible data sync configuration that allows you to choose which data you want to sync from your connected platforms. This guide will walk you through the process of setting up your data sync configuration.

Exploring the Data Sync Configuration

You can view your organization's data sync configuration in the Rutter Dashboard by clicking the "Data Sync Configuration" on the left-hand navigation bar.

Data Sync Configuration Dashboard view

Your organization may have a default data sync configuration set up to fetch the last 24 months of data for all object types.

The data sync configuration is divided into 3 different sections:

  1. Commerce
  2. Accounting
  3. Ads

Each section has a list of Rutter Objects that will be synced from the corresponding platform during the Initial Sync and Incremental Sync. The Initial Sync refers to the first data sync that occurs when a new connection is created in Rutter, which fetches historical data. After the initial sync, Rutter will periodically perform an Incremental Sync at a regular interval to fetch new and updated data from the platform.

In order for a Rutter endpoint to return historical data for a specific object, it must be specified in the data sync config. For example to retrieve chart of accounts data in GET /accounting/accounts, you must have added the Account object to your data sync config.

For the Accounting data objects, there are some prepopulated options that can be used in the data config editor, noted below:

  1. All Rutter Objects
  2. All Expense Management Objects
  3. All Accounts Payable Objects
  4. All Accounts Receivable Objects
  5. All Underwriting Objects
Data Sync Accounting Prepopulated Options

You do not need to add an object to your data sync config to make POST requests to create new objects. For example, to create a new account in the chart of accounts you do not need to add the Account object. However, this means you will only receive the accounts you have created with Rutter through the GET /accounting/accounts endpoint.

Editing your Data Sync Configuration

Fetching data from the external platform can be time consuming for large connections. In addition, fetching all types of data may require your application to ask for more permissions than it needs. To address these issues, Rutter allows you to edit your data sync configuration from the dashboard.

There are two main levers you can adjust:

  1. The lookback window of the Initial Sync.

    The lookback window of the Initial Sync refers to the amount of historical data that is fetched during the initial sync. Adjusting this to be lower can significantly reduce the time it takes to fetch data during the initial sync. This value applies only to transaction type data, such as Orders, Bills, Expenses, etc. Rutter will always fetch all data for non-transaction types, such as Customers, Products, and Accounts.

    Data Sync Batchtime Config
  2. The Rutter Objects that are synced in the Initial Sync and Incremental Sync.

    Each Rutter Object corresponds to a GET endpoint that the Rutter API exposes. For example, if you need to fetch accounts via the GET /accounting/accounts Rutter endpoint, then you will want to ensure the Account object is being synced in your Data Sync Configuration. It is recommended to customize the list of Rutter Objects that are synced to only sync what is necessary for your business.

Advanced Use Cases

Configuring Multiple Batches

Sometimes your business requires that certain types of data are prioritized over others and synced as quickly as possible, or that some types of data require a longer historical lookback. During the Initial Sync, it is possible to define multiple "batches" of data to fetch, each with a different set of Rutter Objects and a different lookback. Batches are fetched in order. After the first batch is complete, an INITIAL_UPDATE webhook is fired. After each subsequent batch, a HISTORICAL_UPDATE webhook is fired. For more information, please see the Connection Webhooks page.

Data Sync Config Batching

Adjusting Incremental Sync Frequency

The Data Sync Configuration page of the dashboard shows the current Inremental Sync Frequency. However, you are unable to adjust this period through the dashboard for the time being. If your business requires a different incremental sync frequency, please reach out to your Rutter Customer Success Manager.

Platform Configuration

To see how Rutter objects would map to Platform Objects for your desired platforms, use the Platform Configuration option at the bottom of the Data Sync Configuration page.

Data Sync Platform Config Mapping

This is an example breakout object mapping for Quickbooks Online, as an example:

Rutter ObjectsPlatform Objects
AccountAccount
Account TransactionOrder, Product
Accounting CustomerCustomer
Ads AccountOrder, Product
Ads InvoiceOrder, Product
AttachmentOrder, Product
Balance SheetBalance Sheet
Bank DepositBank Deposit
Bank Feed AccountOrder, Product
Bank Feed TransactionOrder, Product
Bank TransferBank Transfer
BillBill, Tax
Bill Credit MemoVendor Credit
Bill PaymentBill Payment
CampaignOrder, Product
Campaign DailyOrder, Product
Cash FlowCash Flow
CategoryOrder, Product
ClassClass
Commerce CustomerOrder, Product
Company InfoCompany Info
CurrencyCurrency, Preference
Customer GroupOrder, Product
DepartmentDepartment
ExpenseExpense, Journal Entry, Tax
Income StatementIncome Statement
InvoiceInvoice
Invoice Credit MemoInvoice Credit Memo
Invoice PaymentInvoice Payment
ItemItem
Journal EntryJournal Entry
LocationLocation
OrderOrder, Product
Payment MethodPayment Method
Payment TermPayment Term
PayoutOrder, Product
ProductOrder, Product
ProjectOrder, Product
Purchase OrderPurchase Order
Sales OrderSales Order
StoreOrder, Product
SubscriptionOrder, Product
SubsidiaryOrder, Product
TaskOrder, Product
Tax RateTax Code, Tax
TransactionOrder, Product
VendorVendor