{"uid":"cap_7NDmIkSriQwIlyUY0k7je","slug":"research-task-completion-duplicate-key-report-secondary-measure-a9458e37","name":"Research Task Completion — Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Research task completion — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied research task completion records (completed_tasks, assigned_tasks). 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-22-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","completed_tasks","assigned_tasks"],"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},"assigned_tasks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_tasks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","assigned_tasks":1,"completed_tasks":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","assigned_tasks":2,"completed_tasks":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","assigned_tasks":3,"completed_tasks":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","assigned_tasks":4,"completed_tasks":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_tasks","assigned_tasks"],"type":"string","default":"completed_tasks"}}},"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_PGZ_CY-H6d2JruWn6vJeM","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":"Generates two analytical reports from research task completion data: a duplicate key report and a secondary-measure weighted mean, for up to 200 rows.","exampleAgentPrompt":"Can you run two quick reports on this task completion dataset — one to flag any duplicate row IDs and another to calculate the weighted mean of completed_tasks — I've got 4 rows with row_id, company_group, date, completed_tasks, and assigned_tasks?","exampleUseCases":[{"title":"Data quality audit before reporting","prompt":"I need to check my research task completion records for duplicate row IDs before I submit the weekly report — here are 150 rows with row_id, company_group, date, completed_tasks, and assigned_tasks. Can you flag any duplicates and also give me the weighted mean of completed_tasks?"},{"title":"Weighted task completion benchmarking by group","prompt":"We have assigned_tasks and completed_tasks logged per company group and date across 80 rows — can you compute the weighted mean for assigned_tasks as the primary field and also tell me if there are any duplicate keys in the dataset?"},{"title":"Research operations data validation pipeline","prompt":"Before we archive this month's task completion data, I need two quick checks: a duplicate key report across all row IDs and a weighted mean calculation for completed_tasks. Here are the 200 rows formatted with row_id, company_group, date, completed_tasks, and assigned_tasks."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying any repeated row_id values across the supplied rows, and (2) a weighted mean of the specified field (completed_tasks or assigned_tasks) using the other measure as a weight — all computed locally from the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, company_group, date, completed_tasks, assigned_tasks) on any row","Invalid date format (must be YYYY-MM-DD)","field enum value not recognized — must be completed_tasks or assigned_tasks","All values for the weight field are null or zero — weighted mean undefined","Empty rows array submitted"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate-key integrity check and a weighted mean statistic in a single API call on research task completion data (up to 200 rows). It is ideal when you want offline, deterministic analytics without any external lookup or live data dependencies. Prefer this over building custom scripts when the input conforms to the row_id/company_group/date/completed_tasks/assigned_tasks schema and you want both reports bundled for $0.01.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:25.953Z","isFirstParty":false,"canonicalSlug":"research-task-completion-duplicate-key-report-secondary-measure-a9458e37"}