{"uid":"cap_LXqPMcM5GoLHz-Pl_G3Yb","slug":"competitor-supplied-prices-duplicate-key-report-explicit-missing-97596c39","name":"Competitor Supplied Prices — Duplicate Key Report + Explicit Missing-Value Fill","description":"Competitor supplied prices — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill 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-070?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},"field":{"enum":["list_price","package_quantity"],"type":"string","default":"list_price"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_1JHn8ZElAE46oqabYN1rG","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":"Runs two local analytical reports on up to 200 rows of competitor price data: identifies duplicate keys and fills missing numeric values (list_price or package_quantity) using zero, mean, or median imputation.","exampleAgentPrompt":"I have up to 150 rows of competitor pricing records with row_id, company_group, date, list_price, and package_quantity — can you run a duplicate key report and fill any missing list_price values using the median?","exampleUseCases":[{"title":"Detecting duplicate competitor price entries","prompt":"I've got 80 rows of competitor supplied prices with row_id, company_group, date, list_price, and package_quantity — run a duplicate key report so I can see which records share the same key, and fill any missing list_price values using the median."},{"title":"Imputing missing package quantities with mean","prompt":"My competitor pricing dataset has about 120 rows and several package_quantity values are null — can you fill those missing package_quantity entries using the mean and also flag any duplicate keys in the data?"},{"title":"Zero-filling missing prices before analysis","prompt":"Before I analyze my competitor price list, I need to zero-fill any missing list_price fields and get a duplicate key report — I have around 50 rows with columns for row_id, company_group, date, list_price, and package_quantity."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report listing rows that share identical keys within the submitted competitor price data, and (2) a missing-value fill report showing the original and imputed values for the chosen numeric field (list_price or package_quantity) using the selected method (zero, mean, or median). No external data is fetched; all analysis runs locally on the submitted rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers schema rejection","Numeric values outside ±1,000,000,000,000 range are rejected","Invalid enum value for field or method causes bad request","Empty rows array (minItems:1 not met) returns error"],"whenToPreferThis":"Choose this endpoint when you need both duplicate-key detection and missing-value imputation on competitor pricing data (list_price, package_quantity) in a single low-cost call. It is purpose-built for small-to-medium batches (up to 200 rows) of structured competitor price records and runs entirely on local analytical engines with no external lookups, making it fast, deterministic, and private. Prefer alternatives if you need more than 200 rows, real-time price lookups, predictive pricing models, or reports beyond deduplication and imputation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:05.991Z","isFirstParty":false,"canonicalSlug":"competitor-supplied-prices-duplicate-key-report-explicit-missing-97596c39"}