Gift cards

Gift cards — outstanding balance (liability) and issued value, by status and customer.

10 fields — 7 dimensions, 3 metrics. Date clauses (SINCE, UNTIL, DURING) use createdAt.

The live, authoritative list is always GET /v1/datasets — this page is regenerated from the same catalog, but the endpoint reflects exactly what is deployed.

Query it

FROM gift_cards
  SHOW gift_card_count
  GROUP BY enabled
  SINCE -30d

See Querying with SoloQL for the language.

This dataset is queryable through SoloQL; it has no record-retrieval endpoint.

Fields

Field	Type	Role	Description
enabled	boolean	dimension	Whether the gift card is enabled.
customer_name	string	dimension	Name of the customer the gift card belongs to.
currency	string	dimension	Currency of the gift card balance.
created_at	date	dimension	When the gift card was created.
expires_on	date	dimension	When the gift card expires.
deactivated_at	date	dimension	When the gift card was deactivated.
gift_card_count	number	metric	Number of gift cards in the group (document count — value_count on createdAt). Sums across stores.
balance	money	metric	Current remaining balance — the store's outstanding gift card liability.
initial_value	money	metric	Initial value the gift card was issued with.
store	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.