{"uid":"cap__SRIYDPnF26DUWr7N4ISt","slug":"contract-renewal-inventories-exact-row-deduplication-duplicate-key-b23778ee","name":"Contract Renewal Inventories — Exact Row Deduplication + Duplicate Key Report","description":"Contract renewal inventories — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied contract renewal inventories records (expiring_contracts, renewed_contracts). 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-20-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","expiring_contracts","renewed_contracts"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"renewed_contracts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"expiring_contracts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","renewed_contracts":1,"expiring_contracts":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","renewed_contracts":2,"expiring_contracts":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","renewed_contracts":3,"expiring_contracts":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","renewed_contracts":4,"expiring_contracts":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_17Cy_5sXeJrET4rEb-Kb4","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 contract renewal inventory rows and generates a duplicate key report for up to 200 records across expiring and renewed contract fields.","exampleAgentPrompt":"Can you deduplicate my contract renewal inventory records and give me a duplicate key report? Here are my rows: row-1 for group-a on 2026-10-01 with 10 expiring and 1 renewed, row-2 for group-b on 2026-10-02 with 20 expiring and 2 renewed, and row-1 for group-a on 2026-10-01 with 10 expiring and 1 renewed — I think there are duplicates in there.","exampleUseCases":[{"title":"Monthly contract renewal data cleanup","prompt":"I need to clean up this month's contract renewal inventory before I run my analysis — can you find all exact duplicate rows and flag any duplicate keys? I have about 80 records covering group-a and group-b from October 2026, with expiring and renewed contract counts for each date."},{"title":"Auditing multi-source contract feed merges","prompt":"We merged contract renewal data from two systems and suspect there are duplicate entries — can you run an exact row deduplication and duplicate key report on these 150 rows? Each row has a row_id, company_group, date, expiring_contracts, and renewed_contracts count."},{"title":"Pre-reporting data quality check","prompt":"Before I send this contract renewal inventory report to my manager, can you check it for duplicate rows and duplicate keys? I've got records for group-a and group-b across Q4 2026 — about 60 rows total with expiring and renewed contract figures."}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication report identifying and removing fully identical rows from the submitted contract renewal inventory, and (2) a duplicate key report flagging records sharing the same key fields (such as row_id, company_group, or date combinations). Both reports are generated locally from the supplied data with no external lookups.","failureModes":["Exceeding 200 rows causes rejection — only up to 200 rows accepted per call","Missing required fields (row_id, company_group, date, expiring_contracts, renewed_contracts) will cause validation errors","Invalid date format (must be YYYY-MM-DD) will fail schema validation","Numeric values outside the allowed range (±1,000,000,000,000) will be rejected","Empty rows array (minItems: 1) will cause an error","Malformed JSON input will result in a request parsing error"],"whenToPreferThis":"Choose this endpoint when you need to quickly deduplicate contract renewal inventory records and identify duplicate keys across up to 200 rows, without needing live data lookups or predictive analytics. It is especially useful for data quality checks before reporting, merging datasets from multiple sources, or auditing contract renewal pipelines. At $0.01 USDC for two reports, it is cost-effective for routine data hygiene tasks on moderate-sized contract datasets.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:51.058Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-exact-row-deduplication-duplicate-key-b23778ee"}