{"uid":"cap_3uLmol5thwCU_INqdrGJf","slug":"patch-inventories-exact-row-deduplication-duplicate-key-report-0dc347c6","name":"Patch Inventories — Exact Row Deduplication + Duplicate Key Report","description":"Patch inventories — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied patch inventories records (affected_hosts, patched_hosts). 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-security-02-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","control_group","date","affected_hosts","patched_hosts"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"control_group":{"type":"string","default":"","maxLength":80},"patched_hosts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"affected_hosts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","control_group":"group-a","patched_hosts":1,"affected_hosts":10},{"date":"2026-10-02","row_id":"row-2","control_group":"group-b","patched_hosts":2,"affected_hosts":20},{"date":"2026-10-03","row_id":"row-3","control_group":"group-a","patched_hosts":3,"affected_hosts":15},{"date":"2026-10-04","row_id":"row-4","control_group":"group-b","patched_hosts":4,"affected_hosts":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_vQKYdG90h6ZT7O_5VtCZn","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 identifies duplicate keys in patch inventory records (affected_hosts, patched_hosts) with up to 200 rows, producing two independent analytical reports.","exampleAgentPrompt":"Can you check my patch inventory data for exact duplicate rows and duplicate keys? Here are my records: row-1 for group-a on 2026-10-01 with 10 affected and 1 patched host, row-2 for group-b on 2026-10-02 with 20 affected and 2 patched, row-3 for group-a on 2026-10-03 with 15 affected and 3 patched, and row-4 for group-b on 2026-10-04 with 30 affected and 4 patched — give me both the deduplication report and the duplicate key report.","exampleUseCases":[{"title":"Patch data quality audit before reporting","prompt":"I need to clean up my patch inventory before sending the monthly security report — can you run a full duplicate check on these 50 patch records and tell me which rows are exact duplicates and which row IDs appear more than once? Here's the data with control groups, dates, affected hosts, and patched hosts."},{"title":"Detect repeated entries across control groups","prompt":"We've been logging patch status from multiple teams and I suspect some records got entered twice. Can you take these 120 patch inventory rows and give me a report showing any exact duplicate entries and any duplicate row keys across our group-a and group-b control groups?"},{"title":"Validate patch feed before ingestion","prompt":"Before I load this batch of patch inventory data into our database, can you scan it for exact row duplicates and duplicate row_ids? I have about 80 records with affected_hosts and patched_hosts counts by date and control group that need to be validated first."}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication report identifying rows that are completely identical across all fields, and (2) a duplicate key report flagging rows that share the same key identifier (row_id), covering up to 200 submitted patch inventory records per call.","failureModes":["Submitting more than 200 rows returns an error or truncates results","Missing required fields (row_id, date, affected_hosts, patched_hosts) cause row-level validation failures","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Numeric values exceeding ±1,000,000,000,000 are out of range","Empty rows array returns an error (minItems: 1)","Payment of 0.01 USDC must be provided via x402 protocol or request is rejected"],"whenToPreferThis":"Choose this endpoint when you need to audit patch inventory records specifically for exact row-level duplicates and duplicate key collisions on the fields affected_hosts and patched_hosts, without requiring any live data lookup or external integrations. It is ideal for lightweight, local analytical data quality checks on batches of up to 200 patch management rows at very low cost ($0.01 per call for two reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:39:49.067Z","isFirstParty":false,"canonicalSlug":"patch-inventories-exact-row-deduplication-duplicate-key-report-0dc347c6"}