{"uid":"cap_v9LXGlNGW_XAjOVhQfE1V","slug":"competitor-supplied-prices-duplicate-key-report-date-by-category-pivot-6d81fcbe","name":"Competitor Supplied Prices — Duplicate Key Report + Date by Category Pivot","description":"Competitor supplied prices — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot 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-068?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"}}},"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_SvlGZUGb6wim7DXaNWQ3N","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 pricing data (list_price or package_quantity) to produce a duplicate key report and a date-by-category pivot table in a single call.","exampleAgentPrompt":"I have up to 200 rows of competitor pricing data with fields row_id, company_group, date, list_price, and package_quantity — can you run a duplicate key report and a date-by-category pivot on the list_price field for me?","exampleUseCases":[{"title":"Competitor price data quality audit","prompt":"I've got a dataset of competitor list prices with company groups and dates — can you check it for duplicate row keys and also pivot the list_price values by date and company group so I can see patterns? Here are my rows: row-1 for group-a on 2026-10-01 with list_price 10 and package_quantity 1, row-2 for group-b on 2026-10-02 with list_price 20 and package_quantity 2."},{"title":"Package quantity pivot by competitor and date","prompt":"Run a duplicate key report and a date-by-category pivot on the package_quantity field for my competitor pricing dataset — I want to see if any row IDs repeat and how quantities break down across company groups over time. I have about 150 rows to analyze."},{"title":"Market pricing anomaly detection","prompt":"I need two reports on my competitor supplied prices data: first flag any duplicate row keys, and second give me a date-by-category breakdown of the list_price values. My dataset has rows with company_group, date (YYYY-MM-DD), list_price, and package_quantity fields — can you analyze these for me?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying repeated row_id values within the submitted dataset, and (2) a date-by-category pivot table aggregating the selected numeric field (list_price or package_quantity) broken down by date and company_group, covering up to 200 input rows.","failureModes":["Exceeds 200 row limit — request rejected","Missing required fields (row_id, company_group, date, list_price, or package_quantity) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","Field value out of allowed numeric range (±1 trillion) — rejected","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key check and a date-by-category pivot on competitor pricing records (list_price or package_quantity) in a single low-cost call. It is ideal for data quality workflows where you want to simultaneously detect repeated row identifiers and summarize numeric pricing fields across time and company segments, without needing live market data, external lookups, or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:26.853Z","isFirstParty":false,"canonicalSlug":"competitor-supplied-prices-duplicate-key-report-date-by-category-pivot-6d81fcbe"}