{"uid":"cap_swWLmQQFukh9wtZG8ENF7","slug":"supplier-qualification-exact-row-deduplication-duplicate-key-report-c728cc61","name":"Supplier Qualification — Exact Row Deduplication + Duplicate Key Report","description":"Supplier qualification — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report 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-038?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}}},"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_8QONeL7j4YCSIq9R7EGXc","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 supplier qualification records and generates a duplicate key report for up to 200 rows of checked/met criteria data.","exampleAgentPrompt":"I have a list of up to 200 supplier qualification records with fields like row_id, company_group, date, checked_criteria, and met_criteria — can you run exact row deduplication on them and give me a duplicate key report showing which records are repeated?","exampleUseCases":[{"title":"Procurement data cleanup before audit","prompt":"I'm preparing for a supplier audit and need to clean our qualification records — can you deduplicate these 150 supplier rows by exact match and give me a report of which entries appeared more than once? Each row has a row_id, company_group, date, checked_criteria, and met_criteria."},{"title":"Supplier onboarding pipeline deduplication","prompt":"We're onboarding new suppliers and some entries got submitted twice in our system. Run exact row deduplication and generate a duplicate key report on these qualification records so I can see which ones need to be removed."},{"title":"Quarterly supplier criteria data quality check","prompt":"At the end of Q3, I want to validate our supplier qualification data for duplicates — here are 80 rows each with a company_group, date, checked_criteria, and met_criteria. Can you find all exact duplicate rows and produce a duplicate key report for me?"}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication result showing unique records after removing fully identical rows, and (2) a duplicate key report identifying which key combinations (e.g. row_id, company_group, date) appear more than once across the supplied supplier qualification records.","failureModes":["Exceeding 200 rows results in rejection or truncation","Missing required fields (row_id, company_group, date, checked_criteria, met_criteria) causes validation failure","Invalid date format (not YYYY-MM-DD) triggers schema error","Empty rows array returns an error due to minItems:1 constraint","Non-numeric values for checked_criteria or met_criteria fail schema validation"],"whenToPreferThis":"Choose this endpoint when you need fast, offline deduplication and duplicate key reporting on a batch of up to 200 supplier qualification records without any external lookups or live data enrichment. It is ideal for data hygiene tasks in procurement pipelines, supplier onboarding workflows, or pre-audit data cleaning where both a deduplicated dataset and a duplicate key summary report are needed simultaneously at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:44.127Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-exact-row-deduplication-duplicate-key-report-c728cc61"}