{"uid":"cap_xM9no9P2cWqf4uJ7Eumjm","slug":"supplier-qualification-duplicate-key-report-secondary-measure-63ebcb70","name":"Supplier Qualification — Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Supplier qualification — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean 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-067?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_QKoO-D0yjqH246MjUZc1H","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 supplied supplier qualification records: a duplicate key report and a secondary-measure weighted mean calculation, for up to 200 rows.","exampleAgentPrompt":"Check my supplier qualification records for duplicate row IDs and also compute the weighted mean of checked_criteria — I have about 50 rows with fields: row_id, company_group, date, checked_criteria, and met_criteria.","exampleUseCases":[{"title":"Supplier data quality audit","prompt":"I have 80 supplier qualification records with row_id, company_group, date, checked_criteria, and met_criteria — can you run a duplicate key check on them and also give me the weighted mean of met_criteria?"},{"title":"Procurement analytics for group scoring","prompt":"We have supplier qualification data for three company groups across 120 rows and need to know if any row IDs are duplicated, plus the weighted average of checked_criteria across the dataset."},{"title":"Pre-onboarding supplier record validation","prompt":"Before we onboard these suppliers, can you scan our 40 qualification records for duplicate keys and calculate the secondary-measure weighted mean for checked_criteria so we can flag any anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any rows with repeated row_id values, and (2) a weighted mean calculation for the selected secondary measure field (checked_criteria or met_criteria) across the supplied rows. Up to 200 rows processed per call.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit","Missing required fields (row_id, company_group, date, checked_criteria, met_criteria) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — validation error","Empty rows array — minItems constraint violated","Invalid field enum value — must be 'checked_criteria' or 'met_criteria'"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously detect duplicate row IDs and compute a weighted mean for supplier qualification records in a single low-cost call. It is best suited for batch data quality checks on procurement or supplier onboarding datasets of up to 200 rows where no live external lookup or prediction is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:39.672Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-duplicate-key-report-secondary-measure-63ebcb70"}