{"uid":"cap_nr5GP0X-eRN2r-irPTCfZ","slug":"marketplace-charges-exact-row-deduplication-category-frequencies-a85ac962","name":"Marketplace Charges — Exact Row Deduplication + Category Frequencies","description":"Marketplace charges — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies for supplied marketplace charges records (gross_amount, fee_amount). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-retail-16-041?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","gross_amount","fee_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"fee_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"store_group":{"type":"string","default":"","maxLength":80},"gross_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","fee_amount":1,"store_group":"group-a","gross_amount":10},{"date":"2026-10-02","row_id":"row-2","fee_amount":2,"store_group":"group-b","gross_amount":20},{"date":"2026-10-03","row_id":"row-3","fee_amount":3,"store_group":"group-a","gross_amount":15},{"date":"2026-10-04","row_id":"row-4","fee_amount":4,"store_group":"group-b","gross_amount":30}],"maxItems":200,"minItems":1}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_03ZEFnhGmx_d-aPxH9kgi","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Deduplicates exact rows and computes category-level frequency counts for up to 200 marketplace charge records (gross_amount, fee_amount) using local analytical engines.","exampleAgentPrompt":"I have 150 marketplace charge records with row IDs, store groups, dates, gross amounts, and fee amounts — can you deduplicate the exact rows and give me a frequency count of charges per store group category?","exampleUseCases":[{"title":"Audit duplicate charge records","prompt":"I've got a batch of 80 marketplace charge rows with store_group, date, gross_amount, and fee_amount fields — can you find any exact duplicate rows and tell me which ones are repeated?"},{"title":"Store group frequency analysis","prompt":"Here are 120 marketplace transaction records across different store groups with gross and fee amounts — can you tell me how many charges appear for each store group category?"},{"title":"Clean reconciliation dataset","prompt":"Before I reconcile my marketplace charges, I need to deduplicate these 200 rows by exact match and get a breakdown of how frequently each store group category appears in the data."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying which of the supplied marketplace charge records are exact duplicates, and (2) a category frequency report showing how often each store_group value appears across the supplied rows. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected due to row limit","Missing required fields (row_id, store_group, date, gross_amount, fee_amount) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","Payment not included or insufficient — x402 payment required error","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you have up to 200 marketplace charge records and need both exact-duplicate detection and store-group category frequency counts in a single low-cost call. It is ideal for pre-reconciliation data cleaning, quick audits of charge datasets, or when you need two complementary reports (deduplication + category frequencies) without any external data enrichment or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:35:20.571Z","isFirstParty":false,"canonicalSlug":"marketplace-charges-exact-row-deduplication-category-frequencies-a85ac962"}