{"uid":"cap_IUnuRXxLYr1k-Jl7Yy_cq","slug":"supplier-qualification-duplicate-key-report-date-by-category-pivot-401d97ec","name":"Supplier Qualification — Duplicate Key Report + Date by Category Pivot","description":"Supplier qualification — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied supplier qualification records (checked_criteria, met_criteria). 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-02-068?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","checked_criteria","met_criteria"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"met_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"checked_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","met_criteria":1,"company_group":"group-a","checked_criteria":10},{"date":"2026-10-02","row_id":"row-2","met_criteria":2,"company_group":"group-b","checked_criteria":20},{"date":"2026-10-03","row_id":"row-3","met_criteria":3,"company_group":"group-a","checked_criteria":15},{"date":"2026-10-04","row_id":"row-4","met_criteria":4,"company_group":"group-b","checked_criteria":30}],"maxItems":200,"minItems":1},"field":{"enum":["checked_criteria","met_criteria"],"type":"string","default":"checked_criteria"}}},"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_v342j9_uZNs_ivZniKdvs","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 supplier qualification records to produce two local analytical reports: a duplicate key report and a date-by-category pivot on checked_criteria or met_criteria values.","exampleAgentPrompt":"Can you run a duplicate key check and a date-by-category pivot on this supplier qualification data — checking the met_criteria field — for these records: row-1 on 2026-10-01 group-a with 10 checked and 1 met, row-2 on 2026-10-02 group-b with 20 checked and 2 met, row-3 on 2026-10-03 group-a with 15 checked and 3 met?","exampleUseCases":[{"title":"Detecting duplicate supplier qualification entries","prompt":"I have 150 supplier qualification records from our procurement system and I need to know if any row IDs are duplicated. Can you run a duplicate key report on them using the checked_criteria field?"},{"title":"Date-by-category pivot for procurement review","prompt":"Can you pivot our supplier qualification results by date and company group for me? I want to see how met_criteria breaks down across group-a and group-b over the past quarter — here's the data with dates from 2026-10-01 to 2026-10-04."},{"title":"Data quality audit before supplier onboarding","prompt":"Before we onboard these suppliers, I need to audit our qualification dataset for duplicate entries and get a date-by-category summary of checked_criteria — can you run both reports on these 80 rows?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report flagging any row_ids that appear more than once in the submitted dataset, and (2) a date-by-category pivot table aggregating the selected field (checked_criteria or met_criteria) grouped by date and company_group. No external data is fetched; all analysis runs on the supplied rows only (up to 200).","failureModes":["Fewer than 1 row submitted — request rejected","More than 200 rows submitted — exceeds max limit","Invalid date format (not YYYY-MM-DD) — schema validation error","row_id missing or empty — required field violation","checked_criteria or met_criteria value outside ±1,000,000,000,000 — range error","Invalid field enum value — must be 'checked_criteria' or 'met_criteria'"],"whenToPreferThis":"Choose this endpoint when you need fast, local analytical processing of supplier qualification records without any external lookups or predictions. It is ideal for data quality checks (duplicate detection) combined with date-based category pivots in a single $0.01 call covering up to 200 rows. Prefer it over general analytics tools when working within the x402 micropayment ecosystem or when you need both a duplicate report and a pivot report simultaneously from a single request.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:55.146Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-duplicate-key-report-date-by-category-pivot-401d97ec"}