{"uid":"cap_f_iLfGk6G71F9Tdo7xmAU","slug":"contract-renewal-inventories-adjacent-row-changes-date-by-category-8c6da93e","name":"Contract Renewal Inventories — Adjacent Row Changes + Date by Category Pivot","description":"Contract renewal inventories — Adjacent row changes + Date by category pivot: Adjacent row changes + Date by category pivot 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-160?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_6Ko-BLJ8WnGeek2bq_BIx","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":"Runs two analytical reports on contract renewal inventory data: adjacent row-to-row change analysis and a date-by-category pivot, for up to 200 rows of expiring/renewed contract records.","exampleAgentPrompt":"Can you run adjacent row change analysis and a date-by-category pivot on my contract renewal data? I have 4 rows: row-1 on 2026-10-01 for group-a with 10 expiring and 1 renewed, row-2 on 2026-10-02 for group-b with 20 expiring and 2 renewed, row-3 on 2026-10-03 for group-a with 15 expiring and 3 renewed, row-4 on 2026-10-04 for group-b with 30 expiring and 4 renewed — analyze the expiring_contracts field.","exampleUseCases":[{"title":"Tracking daily contract expiry shifts","prompt":"I have daily contract data for two company groups over the past week — can you show me how the expiring_contracts count changes between each consecutive day, and also give me a pivot of expiring contracts by date and group?"},{"title":"Renewal rate trend analysis by group","prompt":"Run an adjacent row change report and a date-category pivot on my renewed_contracts data across group-a and group-b for October 2026 — I want to see which days had the biggest jumps and how each group compares by date."},{"title":"Month-end contract inventory review","prompt":"I need two reports on this batch of 50 contract renewal records — show me the row-over-row changes in expiring_contracts and a pivot table breaking things down by date and company group so I can review the month-end inventory."}],"resultDescription":"Two analytical reports derived from the supplied rows: (1) an adjacent row changes report showing sequential deltas for the selected field (expiring_contracts or renewed_contracts), and (2) a date-by-category pivot table cross-tabulating values by date and company_group. No external data is fetched; all computation is local to the engine.","failureModes":["Missing required fields (row_id, company_group, date, expiring_contracts, renewed_contracts) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows returns an error or truncated result","Null numeric values may affect change calculations — handled but should be expected in output","Invalid field enum value (anything other than expiring_contracts or renewed_contracts) causes rejection","Empty rows array (minItems: 1 violated) returns an error"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical reports — sequential/adjacent row delta analysis and a date-by-category pivot — on contract renewal inventory data (expiring and renewed contract counts), without needing live data lookup, prediction, or external integrations. Ideal for periodic batch analysis of up to 200 contract records at low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:41.039Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-adjacent-row-changes-date-by-category-8c6da93e"}