{"uid":"cap_ND5w4XcUeKB9UBhk9xuZM","slug":"research-task-completion-string-normalisation-date-by-category-pivot-4330b4e2","name":"Research Task Completion — String Normalisation + Date by Category Pivot","description":"Research task completion — String normalisation + Date by category pivot: String normalisation + Date by category pivot 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-035?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_YO6Gze70EBzcIxh1S-TUO","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 research task completion data: string normalisation of company group labels and a date-by-category pivot table for completed_tasks or assigned_tasks, across up to 200 rows.","exampleAgentPrompt":"I have 4 rows of research task completion records — row-1 group-a 2026-10-01 completed 10 assigned 1, row-2 group-b 2026-10-02 completed 20 assigned 2, row-3 group-a 2026-10-03 completed 15 assigned 3, row-4 group-b 2026-10-04 completed 30 assigned 4 — can you normalize the company group strings and generate a date-by-category pivot on completed_tasks for me?","exampleUseCases":[{"title":"Weekly task completion pivot by team","prompt":"I have this week's research task records across groups A and B — about 50 rows with dates, completed_tasks, and assigned_tasks — can you normalize the group names and give me a pivot table of completed_tasks broken out by date and company group?"},{"title":"Audit group label inconsistencies in task data","prompt":"Our task tracking export has messy company group labels across 120 rows. Can you normalize those strings and also pivot the assigned_tasks field by date and group so I can see the distribution cleanly?"},{"title":"Compare research output across categories over a quarter","prompt":"I've got 200 rows of research task completion data spanning Q4 — each row has a date, company group, and completed_tasks count. Run the string normalization and date-by-category pivot on completed_tasks so I can compare output across groups."}],"resultDescription":"Returns two analytical reports computed locally on the supplied data: (1) a string-normalised version of the company_group field across all rows, and (2) a pivot table cross-tabulating the selected metric (completed_tasks or assigned_tasks) by date and company group category. Covers up to 200 input rows with no external lookups.","failureModes":["Missing required fields (row_id, company_group, date, completed_tasks, assigned_tasks) cause validation errors","Date values not matching YYYY-MM-DD pattern are rejected","Input array exceeding 200 rows returns an error","Null numeric values in the selected metric field may be excluded from pivot aggregations","Invalid field selector (not 'completed_tasks' or 'assigned_tasks') returns a schema error"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation of categorical group labels and a date-by-category pivot on research task completion data in a single low-cost call. Ideal for cleaning and summarising up to 200 rows of task tracking records without requiring external data sources, live lookups, or predictions. Best suited for batch analytical processing of structured task data rather than real-time monitoring.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T00:49:20.154Z","isFirstParty":false,"canonicalSlug":"research-task-completion-string-normalisation-date-by-category-pivot-4330b4e2"}