{"uid":"cap_5pDUIqGrJmD7hen7-kZsZ","slug":"competitor-supplied-prices-duplicate-key-report-category-frequencies-aa786ac3","name":"Competitor Supplied Prices — Duplicate Key Report + Category Frequencies","description":"Competitor supplied prices — Duplicate key report + Category frequencies: Duplicate key report + Category frequencies for supplied competitor supplied prices records (list_price, package_quantity). 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-07-057?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","list_price","package_quantity"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"list_price":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"package_quantity":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","list_price":10,"company_group":"group-a","package_quantity":1},{"date":"2026-10-02","row_id":"row-2","list_price":20,"company_group":"group-b","package_quantity":2},{"date":"2026-10-03","row_id":"row-3","list_price":15,"company_group":"group-a","package_quantity":3},{"date":"2026-10-04","row_id":"row-4","list_price":30,"company_group":"group-b","package_quantity":4}],"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_KkFn4cNDvJlPC5ziX_tPX","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":"Analyzes up to 200 rows of competitor price records to produce a duplicate key report and category frequency table for list_price and package_quantity fields.","exampleAgentPrompt":"Can you check my competitor pricing dataset for duplicate row IDs and show me how frequently each company group appears? I have about 50 records with fields like row_id, company_group, date, list_price, and package_quantity.","exampleUseCases":[{"title":"Audit competitor price feed for duplicates","prompt":"I just pulled 150 rows of competitor pricing data with columns for row_id, company_group, date, list_price, and package_quantity — can you run a duplicate key check and tell me which entries appear more than once?"},{"title":"Frequency breakdown of price categories","prompt":"I have a batch of 80 competitor price records across several company groups and I need to know how often each category shows up — can you give me the category frequencies for the list_price and package_quantity fields?"},{"title":"Data quality check before pricing model","prompt":"Before I feed this competitor pricing data into my model, can you audit these 120 rows for any duplicate keys and generate a frequency report on the company groups and package quantities so I can spot any weird skews?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying which row_id or key combinations appear more than once across the submitted records, and (2) a category frequency table showing how often each distinct value or group appears in the list_price and package_quantity fields — covering up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, list_price, package_quantity) — validation error","Invalid date format (must be YYYY-MM-DD) — schema rejection","Empty rows array — minimum 1 item required","Payment not completed — 402 response before processing begins","list_price or package_quantity outside allowed range (-1T to 1T) — validation error"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously check a batch of competitor pricing records for duplicate keys AND understand the frequency distribution of price categories in a single low-cost call. Ideal for data quality audits before downstream modeling, deduplication pipelines, or competitive pricing analysis workflows where you have up to 200 rows of structured price data with company group, date, list price, and package quantity fields.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T06:43:03.496Z","isFirstParty":false,"canonicalSlug":"competitor-supplied-prices-duplicate-key-report-category-frequencies-aa786ac3"}