{"uid":"cap_-2HeuTCIgTb_CWsnM-DHz","slug":"illustration-estimates-duplicate-key-report-secondary-measure-5d6d1695","name":"Illustration Estimates Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Illustration estimates — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied illustration estimates records (estimated_hours, actual_hours). 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-creative-19-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","estimated_hours","actual_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"actual_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"estimated_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","actual_hours":1,"estimated_hours":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","actual_hours":2,"estimated_hours":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","actual_hours":3,"estimated_hours":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","actual_hours":4,"estimated_hours":30}],"maxItems":200,"minItems":1},"field":{"enum":["estimated_hours","actual_hours"],"type":"string","default":"estimated_hours"}}},"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_NmlCeyVNWwu8IG3GwaOZK","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 local analytical reports on illustration estimate records: a duplicate key report and a secondary-measure weighted mean, across up to 200 rows of estimated_hours and actual_hours data.","exampleAgentPrompt":"Can you check my illustration estimate records for duplicate row IDs and also calculate the weighted mean of estimated_hours? I have 4 rows: row-1 for group-a on 2026-10-01 with estimated 10 hours and actual 1, row-2 for group-b on 2026-10-02 with estimated 20 and actual 2, row-3 for group-a on 2026-10-03 with estimated 15 and actual 3, and row-4 for group-b on 2026-10-04 with estimated 30 and actual 4.","exampleUseCases":[{"title":"Audit creative project hour logs","prompt":"I have a batch of illustration project records with estimated and actual hours — can you run a duplicate key check on all the row IDs and also give me the weighted mean of actual_hours across the dataset? The rows cover groups alpha and beta across October 2026."},{"title":"Validate illustration estimate data quality","prompt":"Before I submit my illustration estimates to the client, can you check these 15 rows for any duplicate row IDs and compute the weighted mean of the estimated_hours field so I can sanity-check the numbers?"},{"title":"Summarize asset group hour distribution","prompt":"I've got illustration hour tracking data across several asset groups and dates — please run both a duplicate key report and a weighted mean on the estimated_hours so I can spot data entry errors and understand the average workload weighting."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any row_id values that appear more than once in the supplied records, and (2) a secondary-measure weighted mean computed over the specified field (estimated_hours or actual_hours) across all submitted rows. Both reports are computed locally without external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, asset_group) causes row rejection","Invalid date format (non-YYYY-MM-DD) triggers a pattern validation failure","Null values in the selected measure field may affect weighted mean calculation","Numeric values outside the allowed range cause schema validation errors"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously check for duplicate row identifiers and compute a weighted mean over hour-based illustration estimate data in a single API call. It is ideal for creative project managers or data pipelines that need lightweight, local data quality and statistical summary reports on up to 200 rows without requiring external data sources or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:37:58.551Z","isFirstParty":false,"canonicalSlug":"illustration-estimates-duplicate-key-report-secondary-measure-5d6d1695"}