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.

The following query parameters can be specified when grabbing data from select endpoints.

Query Parameter

Endpoints

Format

created_at_min
created_at_max

  • Fetch all Orders
  • Fetch all Products
  • Fetch all Transactions
  • Fetch all Payouts
  • Fetch all Account Transactions

UNIX timestamp in milliseconds

updated_at_min
updated_at_max

  • Fetch all Orders
  • Fetch all Products
  • Fetch all Accounts
  • Fetch all Account Transactions

UNIX timestamp in milliseconds

start_date
end_date

  • Fetch Balance Sheets
  • Fetch Cash Flow Statements
  • Fetch Income Statements

ISO 8601 timestamp

Examples

UNIX 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/orders?created_at_min=1656658800000&created_at_max=1659337199000 \
     --header 'Accept: application/json' \
     --header 'Authorization: Basic your_encoded_client_id_and_api_key'

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/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'

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.