Foundations

Timestamps

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 ParameterEndpointsFormat
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.