{"uid":"cap_ly67YZHwQbpSUtWEbMAjg","slug":"supplier-qualification-exact-row-deduplication-grouped-numeric-summary-473a8691","name":"Supplier Qualification — Exact Row Deduplication + Grouped Numeric Summary","description":"Supplier qualification — Exact row deduplication + Grouped numeric summary: Exact row deduplication + Grouped numeric summary 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-040?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_hfm7MvtopYAZ30zT6p2Am","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":"Deduplicates exact rows and produces a grouped numeric summary report for supplier qualification records containing checked_criteria and met_criteria fields.","exampleAgentPrompt":"Can you deduplicate and summarize these supplier qualification records — I have up to 200 rows with company_group, date, checked_criteria, and met_criteria — and give me both a deduplication report and a grouped numeric summary by company group for the met_criteria field?","exampleUseCases":[{"title":"Vendor audit data cleanup","prompt":"I have 150 supplier qualification records with company groups and their checked vs met criteria counts — some rows are duplicates. Can you remove exact duplicate rows and then give me a grouped summary of met_criteria broken down by company group?"},{"title":"Procurement team criteria reporting","prompt":"Our procurement team collected qualification data from multiple sources so there are likely duplicate entries. Run exact row deduplication and then produce a grouped numeric summary of checked_criteria across all company groups for these supplier records."},{"title":"Supplier onboarding batch analysis","prompt":"We're onboarding new suppliers and have qualification records for groups A, B, and C with dates and criteria scores. Deduplicate the dataset and summarize the met_criteria numbers grouped by company_group so we can see which groups are performing best."}],"resultDescription":"Two independent analytical reports: (1) an exact row deduplication report identifying and removing duplicate entries from the supplied supplier qualification rows, and (2) a grouped numeric summary aggregating the selected field (checked_criteria or met_criteria) by company_group, providing statistics such as counts, sums, and averages per group. Covers up to 200 input rows with no external lookups or live data.","failureModes":["Input exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, checked_criteria, met_criteria) — validation error","Invalid date format (must be YYYY-MM-DD) — pattern validation failure","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — schema rejection","Empty rows array — minItems violation","Invalid field enum value (must be checked_criteria or met_criteria) — rejected"],"whenToPreferThis":"Choose this endpoint when you have up to 200 supplier qualification records and need two specific offline analytical operations — exact row deduplication and grouped numeric summarization — performed together in a single low-cost call. It is ideal for procurement and vendor management workflows where data has been collected from multiple sources and may contain duplicates, and you need clean grouped statistics without any live lookups, predictions, or external integrations.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:52.963Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-exact-row-deduplication-grouped-numeric-summary-473a8691"}