latestOpenAPI 3.0.32026-08-101461131.1 MB

ad6f143e43aa

fable

Aggregated consumer transactions from European credit card panels, structured for flexible analysis and faster access to insights. Each row represents daily credit card, debit card, or open banking transactions (7-day lag from transaction date) at a tagged merchant or payment processor, split across Currency, Country, Online/Offline, and Credit/Debit dimensions. Includes ticker (Bloomberg standard) and industry mapping for ~250 US public companies across 6 European countries (UK, DE, FR, IT, ES, AT). Open banking data achieves >85% fill rate at 7 days. User counts provided across 8 and 28-day windows enable custom normalization. NOTE: Individual accounts have a 30-day minimum lag from transaction_date for licensing compliance. Data returned reflects the latest available values, including any corrections from the data provider.

get/consumer-spending/eu/v1/merchant-aggregates

Query parameters

transaction_datestring

The calendar date when the consumer transactions occurred. Value must be formatted 'yyyy-mm-dd'.

transaction_date.gtstring

Filter greater than the value. Value must be formatted 'yyyy-mm-dd'.

transaction_date.gtestring

Filter greater than or equal to the value. Value must be formatted 'yyyy-mm-dd'.

transaction_date.ltstring

Filter less than the value. Value must be formatted 'yyyy-mm-dd'.

transaction_date.ltestring

Filter less than or equal to the value. Value must be formatted 'yyyy-mm-dd'.

namestring

The merchant or entity name for this aggregate (lowercase). When type is 'merchant', this value can be used as the lookup_name in the merchant-hierarchy endpoint to retrieve full corporate hierarchy details.

name.any_ofstring

Filter equal to any of the values. Multiple values can be specified by using a comma separated list.

name.gtstring

Filter greater than the value.

name.gtestring

Filter greater than or equal to the value.

name.ltstring

Filter less than the value.

name.ltestring

Filter less than or equal to the value.

user_country'UK' | 'DE' | 'FR' | 'ES' | 'IT' | 'AT' | 'unknown'

Country of consumer's residence (ISO codes). Available countries: UK, DE, FR, ES, IT, AT. Values outside these are mapped to 'unknown'.

user_country.any_of'UK' | 'DE' | 'FR' | 'ES' | 'IT' | 'AT' | 'unknown'

Filter equal to any of the values. Multiple values can be specified by using a comma separated list.

channel'online' | 'offline' | 'bnpl'

Transaction channel. Possible values: online, offline, bnpl (buy now pay later platforms such as Scala, Klarna, Zilch).

channel.any_of'online' | 'offline' | 'bnpl'

Filter equal to any of the values. Multiple values can be specified by using a comma separated list.

consumer_type'consumer_credit' | 'consumer_debit' | 'open_banking'

The panel the account is sourced from. Possible values: consumer_credit, consumer_debit, open_banking.

consumer_type.any_of'consumer_credit' | 'consumer_debit' | 'open_banking'

Filter equal to any of the values. Multiple values can be specified by using a comma separated list.

parent_namestring

Merchant's parent business name (Title Case). Useful for aggregating transactions across subsidiary brands. Also available in the merchant-hierarchy endpoint for full corporate structure.

parent_name.any_ofstring

Filter equal to any of the values. Multiple values can be specified by using a comma separated list.

parent_name.gtstring

Filter greater than the value.

parent_name.gtestring

Filter greater than or equal to the value.

parent_name.ltstring

Filter less than the value.

parent_name.ltestring

Filter less than or equal to the value.

limitinteger

Limit the maximum number of results returned. Defaults to '100' if not specified. The maximum allowed limit is '5000'.

sortstring

A comma separated list of sort columns. For each column, append '.asc' or '.desc' to specify the sort direction. The sort column defaults to 'transaction_date' if not specified. The sort order defaults to 'desc' if not specified.

Response

A list of results.

next_urlstring

If present, this value can be used to fetch the next page.

request_idstring required

A request id assigned by the server.

status'OK' required

The status of this request's response.