Timestamps - Rutter API Reference - the Common Language for Business Data

Rutter supports the ability to fetch a portion of data based on the timestamp. This is particularly useful when you only need a subset of the data.

Examples

UNIX Timestamp

Query Parameter	Endpoints	Format
created_at_min, created_at_max	Fetch Orders Fetch Products Fetch Transactions Fetch Payouts	UNIX timestamp in milliseconds
updated_at_min, updated_at_max	Fetch Orders Fetch Products Fetch Accounts	UNIX timestamp in milliseconds
start_date, end_date	Fetch Balance Sheets Fetch Cash Flow Statements Fetch Income Statements	ISO 8601 timestamp

Below is an example of fetching all orders between June 1, 2022 and June 31, 2022 using UNIX timestamp in milliseconds:

curl --request GET \
     --url 'https://production.rutterapi.com/versioned/orders?created_at_min=1656658800000&created_at_max=1659337199000' \
     --header 'Accept: application/json' \
     --header 'Authorization: Basic your_encoded_client_id_and_api_key' \
     --header 'X-Rutter-Version: 2023-02-07'

ISO 8601

Below is an example of fetching all balance sheets starting on June 1, 2022 and ending June 31, 2022 using an ISO 8601 timestamps:

curl --request GET \
     --url 'https://production.rutterapi.com/versioned/accounting/balance_sheets?start_date=2022-07-01T00%3A00%3A00Z&end_date=2022-07-01T23%3A59%3A59Z' \
     --header 'Accept: application/json' \
     --header 'Authorization: Basic your_encoded_client_id_and_api_key' \
     --header 'X-Rutter-Version: 2023-02-07'

Please also see the Python example found in the Ingestion Pipeline guide on how to pull data periodically using the above query parameters to keep your data up to date.