{"uid":"cap_fcEjySF6juZu9vQ5YjLWr","slug":"record-routing-analytics-string-normalisation-grouped-numeric-summary-beafc957","name":"Record Routing Analytics — String Normalisation & Grouped Numeric Summary","description":"Record routing — String normalisation + Grouped numeric summary: String normalisation + Grouped numeric summary for supplied record routing records (accepted_records, rejected_records). 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-analytics-19-023?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","accepted_records","rejected_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"accepted_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rejected_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","accepted_records":10,"rejected_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","accepted_records":20,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":15,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":30,"rejected_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["accepted_records","rejected_records"],"type":"string","default":"accepted_records"}}},"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_pVm0UoFV5Qxzhi6MucGhP","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":"Normalises string fields and produces a grouped numeric summary report for up to 200 record routing rows (accepted_records, rejected_records), returning two analytical reports per call.","exampleAgentPrompt":"I have a batch of record routing data with accepted and rejected counts across different dataset groups and dates — can you normalize the string fields and give me a grouped numeric summary for the accepted_records field across all rows?","exampleUseCases":[{"title":"ETL pipeline quality review","prompt":"I've got up to 80 rows of record routing data from our daily ETL runs, each with a date, group label, and accepted/rejected counts — can you normalize the strings and give me a grouped numeric summary broken down by dataset_group for the rejected_records field?"},{"title":"Multi-group ingestion audit","prompt":"We have two dataset groups, 'group-a' and 'group-b', with daily routing records for October — can you run a grouped numeric summary on the accepted_records field so I can see how each group is performing?"},{"title":"Data quality dashboard prep","prompt":"I need two analytical reports on my routing records: string normalisation and a grouped numeric summary for accepted_records. I have about 150 rows with row IDs, dates, groups, and accepted/rejected counts — can you process them all at once?"}],"resultDescription":"Returns two reports per call: (1) a string normalisation report for the string fields in the routing records, and (2) a grouped numeric summary aggregating the selected numeric field (accepted_records or rejected_records) by dataset_group, covering up to 200 input rows. No external lookups or predictions are made — all analysis is performed on the supplied data.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, accepted_records, rejected_records) cause validation errors","Malformed date strings not matching YYYY-MM-DD pattern rejected","Numeric values outside ±1,000,000,000,000 range rejected","Empty rows array causes failure","Invalid field enum value (not 'accepted_records' or 'rejected_records') causes error"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation and grouped numeric summaries on record routing data in a single low-cost call (0.01 USDC for both reports). It is ideal for ETL pipeline auditing, data quality reviews, or dashboarding where you have up to 200 rows of routing records with accepted/rejected counts grouped by category. It does not perform live lookups, predictions, or external actions — use it purely for local analytical computation on supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:13.948Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-string-normalisation-grouped-numeric-summary-beafc957"}