Skip to main content
GET
/
v1
/
transactions
List transactions
curl --request GET \
  --url https://clientapi.retailgrid.io/v1/transactions

Documentation Index

Fetch the complete documentation index at: https://docs.retailgrid.io/llms.txt

Use this file to discover all available pages before exploring further.

Returns sales transactions visible to your API key. Pair with List products to assemble a catalog-plus-sales view in your warehouse without going through the in-app CSV export flow.

​
Authentication

Bearer token. See Authentication.

​
Query parameters

NameTypeRequiredDescription
limitintegerNoPage size, default 1000, max 10000.
cursorstringNoOpaque pagination cursor returned by a previous response.
from_datestring (ISO-8601, UTC)NoEarliest transaction timestamp to include.
to_datestring (ISO-8601, UTC)NoLatest transaction timestamp to include.
product_idstringNoFilter to a single product.
store_idstringNoFilter to a single store.
updated_afterstring (ISO-8601, UTC)NoOnly return transactions updated at or after this timestamp - useful for incremental sync.

​
Response

{
  "data": [
    {
      "transaction_id": "txn_01HX9R5M",
      "product_id": "SKU-12345",
      "store_id": "STORE-007",
      "timestamp": "2026-05-21T16:42:09Z",
      "quantity": "2",
      "price": "1.49",
      "revenue": "2.98",
      "currency": "EUR",
      "is_promo": false,
      "updated_at": "2026-05-21T16:42:09Z"
    }
  ],
  "next_cursor": "eyJvZmZzZXQiOjEwMDB9"
}
Numeric values are returned as strings - see Conventions.

​
Incremental pulls

For downstream sync jobs, store the highest updated_at you’ve seen and pass it as updated_after on the next run. This is more efficient than re-reading the full window and lets you catch late-arriving corrections to existing transactions.

​
Large windows

For wide date ranges across high-volume accounts, narrow the window with from_date / to_date and page with limit=10000. Pulling many months in a single call is supported but slow and more likely to hit a retry.

​
Example request

curl -s "https://clientapi.retailgrid.io/v1/transactions?from_date=2026-05-01T00:00:00Z&to_date=2026-05-22T00:00:00Z&limit=10000" \
  -H "Authorization: Bearer rg_live_xxx"