{"uid":"cap_mtJ93dwGTSzZwmJgnJIwy","slug":"contract-renewal-inventories-exact-row-deduplication-adjacent-row-06f00bde","name":"Contract Renewal Inventories — Exact Row Deduplication + Adjacent Row Changes","description":"Contract renewal inventories — Exact row deduplication + Adjacent row changes: Exact row deduplication + Adjacent row changes 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-046?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},"field":{"enum":["expiring_contracts","renewed_contracts"],"type":"string","default":"expiring_contracts"}}},"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_T5HQBLZQe67v1JKYz5LJH","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 rows and computes adjacent row changes for contract renewal inventory data (expiring_contracts, renewed_contracts) across up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"I have a list of up to 200 contract renewal records with columns row_id, company_group, date, expiring_contracts, and renewed_contracts — can you deduplicate the exact rows and compute the adjacent row changes for the expiring_contracts field?","exampleUseCases":[{"title":"Deduplicating renewal pipeline records","prompt":"I've got a table of contract renewal entries for multiple company groups — some rows look like exact duplicates. Can you deduplicate them and also show me how the expiring_contracts values change from one row to the next?"},{"title":"Auditing renewed contracts delta report","prompt":"Here are 150 rows of renewed contract data across several groups from Q4. Run the exact row deduplication and show me adjacent row changes for the renewed_contracts field so I can spot anomalies."},{"title":"Cleaning contract inventory before reporting","prompt":"Before I build my quarterly report, I need to clean this contract inventory dataset — remove any exact duplicate rows and give me a breakdown of how expiring_contracts shifts between consecutive records for group-a and group-b."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate rows from the supplied contract renewal inventory, and (2) an adjacent row changes report showing the delta between consecutive rows for the selected field (expiring_contracts or renewed_contracts), all computed locally without external lookups.","failureModes":["Missing required fields (row_id, date, company_group) causes validation error","Date values not matching YYYY-MM-DD pattern are rejected","Array exceeding 200 rows is rejected with schema validation error","Null numeric values may affect change computation between adjacent rows","Invalid field selector value (not expiring_contracts or renewed_contracts) causes error"],"whenToPreferThis":"Choose this endpoint when you need both exact-duplicate row removal and adjacent row change detection on contract renewal inventory data (expiring_contracts and renewed_contracts) in a single low-cost call. It is ideal for data cleaning pipelines before reporting, when no external lookup or prediction is needed, and when your dataset fits within 200 rows. It bundles two complementary reports for $0.01 USDC, making it efficient compared to calling separate deduplication and delta-computation services.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:38.909Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-exact-row-deduplication-adjacent-row-06f00bde"}