{"uid":"cap_W1Eg_XznXhV8HO6F-_YUw","slug":"marketplace-charges-exact-row-deduplication-numeric-row-ordering-d98d8867","name":"Marketplace Charges — Exact Row Deduplication + Numeric Row Ordering","description":"Marketplace charges — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering 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-042?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},"field":{"enum":["gross_amount","fee_amount"],"type":"string","default":"gross_amount"}}},"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_-6zZmDH6kaIbOzzEqFdf4","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 applies numeric row ordering to supplied marketplace charge records (gross_amount, fee_amount), returning 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"I have a list of marketplace charge records with store groups, dates, gross amounts, and fee amounts — can you run exact row deduplication and numeric row ordering on these rows, focusing on the gross_amount field, and give me the two analytical reports?","exampleUseCases":[{"title":"Deduplicating retail charge exports","prompt":"I exported our marketplace charges for October and I think there are duplicate rows — can you run exact row deduplication and numeric ordering on these records, looking at gross_amount? Here are the rows: row-1 group-a 2026-10-01 gross=10 fee=1, row-2 group-b 2026-10-02 gross=20 fee=2, row-1 group-a 2026-10-01 gross=10 fee=1."},{"title":"Cleaning fee amount data before reconciliation","prompt":"Before I reconcile our store fee charges, I need to deduplicate exact rows and get them ordered numerically — can you process these marketplace charge records focusing on fee_amount across our group-a and group-b stores for the past week?"},{"title":"Auditing multi-store charge data quality","prompt":"We have up to 150 marketplace charge rows across several store groups and I need two reports: one that removes exact duplicate charge entries and one that orders the rows numerically by gross_amount — can you run that analysis on my supplied data?"}],"resultDescription":"Returns 2 independent analytical reports: (1) an exact row deduplication report identifying and removing duplicate charge rows, and (2) a numeric row ordering report sorting the supplied rows by the selected field (gross_amount or fee_amount). Both reports are computed locally against the supplied data with no external lookups.","failureModes":["Rows array empty or missing — minItems:1 violation returns validation error","More than 200 rows supplied — maxItems:200 limit exceeded","Invalid date format (not YYYY-MM-DD) — pattern validation failure","Missing required fields (row_id, store_group, date, gross_amount, fee_amount) — schema validation error","row_id exceeds 80 character limit — validation error","Numeric amounts outside allowed range (±1,000,000,000,000) — validation error","Invalid field enum value (not gross_amount or fee_amount) — schema error"],"whenToPreferThis":"Choose this endpoint when you have marketplace charge data (with gross_amount and fee_amount fields) and need both exact row deduplication and numeric row ordering in a single call, without requiring live data lookups or external integrations. Ideal for data cleaning pipelines before financial reconciliation or reporting. Prefer this over generic data tools when your data fits the marketplace charges schema and you want two bundled analytical reports at a fixed low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:58.348Z","isFirstParty":false,"canonicalSlug":"marketplace-charges-exact-row-deduplication-numeric-row-ordering-d98d8867"}