{"uid":"cap_R9Q6obq_6ePGyZuZHZVhw","slug":"commercial-proposal-comparisons-duplicate-key-report-base-100-series-a7350c2d","name":"Commercial Proposal Comparisons — Duplicate Key Report + Base-100 Series","description":"Commercial proposal comparisons — Duplicate key report + Base-100 series: Duplicate key report + Base-100 series for supplied commercial proposal comparisons records (quoted_amount, delivery_days). 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-24-063?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","quoted_amount","delivery_days"],"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},"delivery_days":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"quoted_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","delivery_days":1,"quoted_amount":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","delivery_days":2,"quoted_amount":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","delivery_days":3,"quoted_amount":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","delivery_days":4,"quoted_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["quoted_amount","delivery_days"],"type":"string","default":"quoted_amount"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":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_645HxEzvHjHUB7raVreDs","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":"Analyzes commercial proposal comparison records to produce a duplicate key report and a Base-100 indexed series for quoted_amount or delivery_days fields, across up to 200 rows.","exampleAgentPrompt":"I have 8 commercial proposal rows with company_group, date, quoted_amount, and delivery_days — can you run a duplicate key check and also generate a Base-100 index series on quoted_amount starting from row index 0?","exampleUseCases":[{"title":"Vendor bid duplicate audit","prompt":"I've got a list of vendor bids with row IDs, company groups, dates, quoted amounts, and delivery days — can you check this for duplicate keys and index the quoted_amount values to Base-100 starting from the first row?"},{"title":"Delivery days baseline comparison","prompt":"Here are 50 commercial proposal records from different suppliers. I want a duplicate key report and a Base-100 series on delivery_days using row index 2 as the baseline so I can see how each supplier compares."},{"title":"Procurement proposal data quality check","prompt":"Can you audit these 120 procurement proposal rows for duplicate row keys across company_group and date, and also give me a Base-100 index on quoted_amount anchored to row 0?"}],"resultDescription":"Returns two reports: (1) a duplicate key report identifying rows with repeated key combinations (e.g. same company_group and date), and (2) a Base-100 indexed series for the chosen numeric field (quoted_amount or delivery_days), where the specified base_index row is set to 100 and all other values are expressed relative to it. Both reports are computed locally from the supplied rows with no external lookups.","failureModes":["Missing required fields (row_id, company_group, date, quoted_amount, delivery_days) cause validation errors","More than 200 rows submitted — exceeds max row limit","Invalid date format (must match YYYY-MM-DD pattern)","base_index out of range (must be 0–199 and within submitted row count)","Numeric field values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) rejected","Empty rows array not accepted (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need two specific analytical outputs on commercial proposal data — a duplicate key detection report and a Base-100 normalization series — without any external lookup or prediction. It is ideal for procurement analysts or agents comparing vendor quotes and delivery terms across up to 200 rows, where data is already in hand and the goal is structured QA plus relative indexing. Prefer it over general-purpose analytics tools when the domain is specifically commercial proposals (quoted_amount, delivery_days) and cost-efficiency matters ($0.01 for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:42:55.118Z","isFirstParty":false,"canonicalSlug":"commercial-proposal-comparisons-duplicate-key-report-base-100-series-a7350c2d"}