{"uid":"cap_3vk8UAuzsvBQVsfxd04UJ","slug":"research-grant-spending-deduplication-and-grouped-numeric-summary-fde151a0","name":"Research Grant Spending Deduplication and Grouped Numeric Summary","description":"Research grant spending — Exact row deduplication + Grouped numeric summary: Exact row deduplication + Grouped numeric summary for supplied research grant spending records (budget_amount, spend_amount). 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-education-20-040?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","budget_amount","spend_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"course_group":{"type":"string","default":"","maxLength":80},"spend_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"budget_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","course_group":"group-a","spend_amount":1,"budget_amount":10},{"date":"2026-10-02","row_id":"row-2","course_group":"group-b","spend_amount":2,"budget_amount":20},{"date":"2026-10-03","row_id":"row-3","course_group":"group-a","spend_amount":3,"budget_amount":15},{"date":"2026-10-04","row_id":"row-4","course_group":"group-b","spend_amount":4,"budget_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["budget_amount","spend_amount"],"type":"string","default":"budget_amount"}}},"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_9SjpZQd6_MUvIbokaAE5u","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":"Deduplicates exact rows and produces grouped numeric summaries for research grant spending records (budget_amount, spend_amount) across up to 200 rows in two independent reports.","exampleAgentPrompt":"Can you deduplicate these research grant spending records and give me a grouped numeric summary by course group? I have up to 50 rows with budget_amount and spend_amount fields, and I want two reports — one for deduplication and one for the grouped summary, using budget_amount as the primary field.","exampleUseCases":[{"title":"Grant budget reconciliation by department","prompt":"I have 120 rows of research grant spending data with course groups and dates — some rows might be duplicates. Can you deduplicate them and give me a grouped numeric summary of budget_amount by course group so I can see where we stand?"},{"title":"Spend variance audit across grant categories","prompt":"Run deduplication and a grouped numeric summary on my grant spending records using spend_amount — I want to see totals and any outliers per course group across these 80 rows."},{"title":"Monthly grant reporting data cleanup","prompt":"I need to clean up our monthly research grant data before the report — can you remove any exact duplicate rows and then produce a grouped summary of budget_amount across all course groups for these 150 records?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication result identifying and removing duplicate records from the submitted rows, and (2) a grouped numeric summary of the selected field (budget_amount or spend_amount) aggregated by course_group, including statistics such as totals and counts per group.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, course_group, date, budget_amount, spend_amount) cause rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation error","Null or out-of-range numeric values may cause computation errors","Submitting an empty rows array returns a minItems validation error"],"whenToPreferThis":"Choose this endpoint when you have structured research grant spending data (up to 200 rows) that needs both exact duplicate removal and grouped numeric aggregation in a single call. It is ideal for education finance workflows where you need two complementary analytical reports cheaply and quickly without sending data to an external live system. Prefer it over general analytics tools when you need deterministic, local computation with no side effects on up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:49:35.128Z","isFirstParty":false,"canonicalSlug":"research-grant-spending-deduplication-and-grouped-numeric-summary-fde151a0"}