{"uid":"cap_dEYKNVPUe71isDtBTXaxX","slug":"contract-renewal-inventories-duplicate-key-report-keyed-dataset-f0488a24","name":"Contract Renewal Inventories — Duplicate Key Report + Keyed Dataset Comparison","description":"Contract renewal inventories — Duplicate key report + Keyed dataset comparison: Duplicate key report + Keyed dataset comparison 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-069?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},"other":{"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":21},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","renewed_contracts":3,"expiring_contracts":17},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","renewed_contracts":4,"expiring_contracts":33}],"maxItems":200,"minItems":0}}},"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_jcLA12eGSYxsn2SBEXuZW","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: a duplicate key detection report and a keyed comparison between two supplied datasets, for up to 200 rows each.","exampleAgentPrompt":"Check my two sets of contract renewal records for duplicate row IDs and then compare them against each other key by key — the primary dataset has rows like row-1/group-a/2026-10-01 with expiring_contracts and renewed_contracts values, and the secondary dataset has the same structure but slightly different values for some rows.","exampleUseCases":[{"title":"Duplicate key audit before renewal processing","prompt":"Before we process this month's contract renewals, can you run a duplicate key check on our inventory data? I have up to 150 rows with row_id, company_group, date, expiring_contracts, and renewed_contracts — flag any row IDs that appear more than once."},{"title":"Cross-check two renewal data feeds for discrepancies","prompt":"We received contract renewal data from two different sources for the same period. Can you compare them row by row using row_id as the key and tell me which rows have different expiring_contracts or renewed_contracts values between the two feeds?"},{"title":"Validate merged dataset integrity before reporting","prompt":"I just merged contract renewal records from group-a and group-b into one dataset and I want to make sure there are no duplicate keys before I finalize the quarterly report — can you run the duplicate key report on my combined rows?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report listing any row_ids that appear more than once within the supplied dataset, and (2) a keyed dataset comparison showing row-by-row differences between the primary and secondary datasets based on matching row_id keys, highlighting mismatches in expiring_contracts and renewed_contracts values. Up to 200 rows processed per report.","failureModes":["Exceeding 200 rows causes rejection or truncation","Missing required fields (row_id, company_group, date, expiring_contracts, renewed_contracts) causes validation error","Invalid date format (not YYYY-MM-DD) fails schema validation","Numeric values outside ±1,000,000,000,000 range rejected","Empty rows array causes minItems violation","Payment failure via x402 protocol blocks request"],"whenToPreferThis":"Choose this endpoint when you need simultaneous duplicate key detection and cross-dataset comparison on contract renewal inventory data (expiring_contracts, renewed_contracts fields) in a single low-cost API call. It is best suited for datasets of up to 200 rows where you want local analytical processing without any external lookups, predictions, or live data enrichment. Prefer this over general-purpose data tools when cost predictability ($0.01 USDC flat for both reports) and schema-specific contract renewal semantics matter.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T18:57:13.870Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-duplicate-key-report-keyed-dataset-f0488a24"}