Filter, sort and summarise fetched listings
analyze_listingsWork on the COMPLETE response of an earlier get_event_listings, compare_marketplaces or find_events call, including items too many to show inline. Pass the file link from that result. Free: spends no credits and makes no new fetch. Works for 15 minutes after the fetch, only for the account that made it. For marketplace listings it uses one standard row per listing with the same field names on every marketplace: section, row, quantity (tickets available), splits (quantities you can buy), price (per ticket before fees), fees, price_total (all-in per ticket), face_value, currency, notes, area, ticket_type, inventory_type, deal_score, delivery, is_parking, listing_id, marketplace. Any other field name is read from the original listing (prefix 'raw.' to force that). compare_marketplaces results merge every marketplace's listings into one list with a marketplace field. Filter with conditions (AND) and tickets, sort, pick fields, get min/median/max of a numeric field, and count or price items per group (per section, per marketplace, per row). Every reply includes an overview of all matches: count, tickets, price range and the cheapest listing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | The file link from an earlier result (https://mcp.ticketsdata.com/mcp?file=...) or just its token. | |
| limit | No | How many matching items to return (0 for summary only). Default 50. | |
| where | No | Conditions every returned item must meet, combined with AND. Example: [{"field":"price_total","op":"<=","value":300},{"field":"section","op":"in","value":["101","102"]}]. | |
| fields | No | Return only these fields of each item. Omit to return the standard rows (or raw items when there is no standard view). | |
| offset | No | Skip this many matching items, for paging. | |
| sort_by | No | Field to sort matches by, e.g. 'price_total'. Numbers (including prices written as text) sort numerically. Items without the field go last. | |
| tickets | No | Keep only listings where exactly this many tickets can be bought together (uses splits, or quantity when the marketplace gives no splits). | |
| group_by | No | Field to group matches by, e.g. 'section' or 'marketplace'. Returns count per group (and prices with stats_field), cheapest group first. | |
| list_path | No | Dotted path of a list in the raw response to analyze instead, e.g. 'body.events'. Turns off the standard view. | |
| descending | No | Sort from highest to lowest. | |
| include_raw | No | Add the original listing under 'raw' to each standard row. | |
| stats_field | No | Numeric field to summarise over ALL matches: min, p25, median, p75, max, mean. Also adds min, median and max to each group. |