{"uid":"cap_3N8d84F7AZnEpjYQwlin4","slug":"brand-mention-inventories-exact-row-deduplication-duplicate-key-report-39394f9e","name":"Brand Mention Inventories — Exact Row Deduplication + Duplicate Key Report","description":"Brand mention inventories — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied brand mention inventories records (mention_count, source_count). 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-company-18-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","mention_count","source_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"mention_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_count":1,"company_group":"group-a","mention_count":10},{"date":"2026-10-02","row_id":"row-2","source_count":2,"company_group":"group-b","mention_count":20},{"date":"2026-10-03","row_id":"row-3","source_count":3,"company_group":"group-a","mention_count":15},{"date":"2026-10-04","row_id":"row-4","source_count":4,"company_group":"group-b","mention_count":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_30XzJdu0yTO3C22jND4Ew","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":"Performs exact row deduplication and generates a duplicate key report for brand mention inventory records (mention_count, source_count) for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate my brand mention inventory records and flag any duplicate keys? Here are my rows: row-1 for group-a on 2026-10-01 with mention_count 10 and source_count 1, row-2 for group-b on 2026-10-02 with mention_count 20 and source_count 2, and row-1 for group-a on 2026-10-01 with mention_count 10 and source_count 1 — I need both the exact row deduplication report and the duplicate key report.","exampleUseCases":[{"title":"Cleaning brand mention tracking data","prompt":"I have 50 rows of brand mention inventory data across several company groups and dates, and I suspect there are exact duplicate rows messing up my counts — can you run a deduplication and give me a duplicate key report? Here's my dataset: row-1, group-alpha, 2026-09-01, mention_count 100, source_count 5 … through row-50."},{"title":"Auditing monthly mention data integrity","prompt":"Before I finalize my monthly brand mention report, I need to check for any exact duplicate entries and duplicate keys in my inventory data for October 2026. Can you run both the deduplication and duplicate key report on these 80 records across group-a and group-b?"},{"title":"Validating merged mention datasets","prompt":"I merged two brand mention inventory exports and now I'm worried about duplicates — can you identify any exact duplicate rows and flag duplicate row_id keys across these 120 combined records with their mention_count and source_count values?"}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication report identifying and removing fully identical rows from the input dataset, and (2) a duplicate key report flagging records sharing the same key fields (such as row_id, company_group, or date combinations). Both reports are computed locally on the supplied data without any external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, company_group, date, mention_count, source_count) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers schema validation failure","Numeric values outside the allowed range (-1,000,000,000,000 to 1,000,000,000,000) cause rejection","Empty rows array (minItems: 1 not met) returns an error","Payment of 0.01 USDC not included or failed — x402 payment required"],"whenToPreferThis":"Choose this endpoint when you need to clean or audit brand mention inventory data by detecting exact duplicate rows and flagging duplicate keys across fields like company_group and date. It is ideal for pre-processing steps before analytics, reporting, or data warehouse ingestion where data quality is critical. Best suited for small-to-medium datasets (up to 200 rows) where two complementary deduplication reports are needed in a single call at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:57.029Z","isFirstParty":false,"canonicalSlug":"brand-mention-inventories-exact-row-deduplication-duplicate-key-report-39394f9e"}