{"uid":"cap_pQ8a-FJ_fJmk65U5Q9ZLf","slug":"api-contracts-exact-row-deduplication-grouped-numeric-summary-debf6cc7","name":"API Contracts — Exact Row Deduplication + Grouped Numeric Summary","description":"API contracts — Exact row deduplication + Grouped numeric summary: Exact row deduplication + Grouped numeric summary for supplied api contracts records (fields_checked, incompatible_fields). 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-software-19-040?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","component","date","fields_checked","incompatible_fields"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"component":{"type":"string","default":"","maxLength":80},"fields_checked":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"incompatible_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","component":"group-a","fields_checked":10,"incompatible_fields":1},{"date":"2026-10-02","row_id":"row-2","component":"group-b","fields_checked":20,"incompatible_fields":2},{"date":"2026-10-03","row_id":"row-3","component":"group-a","fields_checked":15,"incompatible_fields":3},{"date":"2026-10-04","row_id":"row-4","component":"group-b","fields_checked":30,"incompatible_fields":4}],"maxItems":200,"minItems":1},"field":{"enum":["fields_checked","incompatible_fields"],"type":"string","default":"fields_checked"}}},"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_z2VbUaEGqp1vQKDGftCv6","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 for API contract records containing fields_checked and incompatible_fields metrics.","exampleAgentPrompt":"I have a list of API contract records with fields_checked and incompatible_fields — can you deduplicate any exact duplicate rows and give me a grouped numeric summary by component? I'll provide up to 200 rows.","exampleUseCases":[{"title":"API contract audit deduplication","prompt":"Here are 150 API contract validation records with fields_checked and incompatible_fields values — please deduplicate any exact duplicate rows and give me a grouped summary of incompatible_fields by component."},{"title":"Component-level field check rollup","prompt":"I've got API contract data across several components and dates. Can you remove any duplicate entries and then group the fields_checked metric by component to show me totals and stats?"},{"title":"Contract regression data cleanup","prompt":"After running our regression suite, I ended up with API contract records that may have duplicate rows — can you deduplicate them exactly and summarize incompatible_fields counts grouped by component?"}],"resultDescription":"Two independent reports: (1) an exact row deduplication report identifying and removing duplicate rows from the supplied API contract records; (2) a grouped numeric summary aggregating the selected numeric field (fields_checked or incompatible_fields) by component, including statistics such as counts, sums, and means. Handles up to 200 input rows per call.","failureModes":["Input exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, component, date, fields_checked, incompatible_fields) cause validation errors","Invalid date format (must match YYYY-MM-DD) causes schema rejection","Numeric values outside allowed range (-1e12 to 1e12) cause validation failure","Empty rows array (minItems: 1 not met) causes error","Invalid field enum value (must be fields_checked or incompatible_fields) causes rejection"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a grouped numeric summary for API contract data (fields_checked, incompatible_fields) in a single $0.01 call, with no external lookups or live data required. It is ideal for batch data cleaning and rollup of up to 200 contract validation records where you want two analytical reports simultaneously using local engines.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:52:34.474Z","isFirstParty":false,"canonicalSlug":"api-contracts-exact-row-deduplication-grouped-numeric-summary-debf6cc7"}