Sign in
latestOpenAPI 3.0.32026-08-101461131.1 MB

ad6f143e43aa

fable

Reference data mapping merchants to parent companies, tickers, sectors, and industries across Fable's European consumer transaction panel. Each row represents a single merchant with its corporate hierarchy and classification metadata. Weekly snapshots contain ~3,500 merchants covering ~250 US public companies. Use lookup_name to join with the name field from the merchant-aggregates endpoint, filtering by active_from and active_to to match a specific transaction_date (e.g., active_from.lte=2025-06-15&active_to.gte=2025-06-15).

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

Query parameters

lookup_namestring

Lowercase merchant tag used for joining with the merchant-aggregates endpoint name field (e.g., 'asda', 'amazon').

lookup_name.any_ofstring

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

lookup_name.gtstring

Filter greater than the value.

lookup_name.gtestring

Filter greater than or equal to the value.

lookup_name.ltstring

Filter less than the value.

lookup_name.ltestring

Filter less than or equal to the value.

tickerstring

Stock ticker associated with the merchant (~250 US public companies mapped). Uses Bloomberg standard.

ticker.any_ofstring

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

ticker.gtstring

Filter greater than the value.

ticker.gtestring

Filter greater than or equal to the value.

ticker.ltstring

Filter less than the value.

ticker.ltestring

Filter less than or equal to the value.

listing_status'public' | 'private'

Whether the merchant is a publicly listed company or private. Possible values: public, private.

listing_status.any_of'public' | 'private'

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

active_fromstring

Date this merchant hierarchy mapping became applicable. A value of 0001-01-01 indicates no known start date. Use with active_to to match against transaction_date from the merchant-aggregates endpoint to perform point-in-time queries. Value must be formatted 'yyyy-mm-dd'.

active_from.gtstring

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

active_from.gtestring

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

active_from.ltstring

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

active_from.ltestring

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

active_tostring

Date after which this merchant hierarchy mapping is no longer applicable due to a corporate action. A value of 9999-12-31 indicates the mapping is currently active. Value must be formatted 'yyyy-mm-dd'.

active_to.gtstring

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

active_to.gtestring

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

active_to.ltstring

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

active_to.ltestring

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

limitinteger

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

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 'lookup_name' if not specified. The sort order defaults to 'asc' 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.