{"uid":"cap_AmERXS_CzYt4rleRSZt4T","slug":"record-routing-record-quality-audit-date-by-category-pivot-4038165d","name":"Record Routing — Record Quality Audit + Date by Category Pivot","description":"Record routing — Record quality audit + Date by category pivot: Record quality audit + Date by category pivot 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-017?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_GaoSYvYfx9MnfaXpVewj2","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 analytical reports on record routing data: a quality audit of accepted/rejected records and a date-by-category pivot, for up to 200 rows of supplied data.","exampleAgentPrompt":"Can you run a record quality audit and a date-by-category pivot on this record routing data? I have 4 rows: row-1 on 2026-10-01 in group-a with 10 accepted and 1 rejected, row-2 on 2026-10-02 in group-b with 20 accepted and 2 rejected, row-3 on 2026-10-03 in group-a with 15 accepted and 3 rejected, and row-4 on 2026-10-04 in group-b with 30 accepted and 4 rejected — analyze the accepted_records field.","exampleUseCases":[{"title":"Data pipeline quality audit","prompt":"I need to audit the quality of my record routing pipeline — here are 50 rows with row IDs, dates, dataset groups, and counts of accepted and rejected records. Run both a quality audit and a date-by-category pivot on the accepted_records field so I can see where rejections are clustering."},{"title":"Category pivot for weekly review","prompt":"Can you pivot my record routing data by date and category for our weekly data review? I'll give you the rows with accepted and rejected record counts per dataset group, and I want the date-by-category breakdown on the rejected_records field."},{"title":"Identify rejection spikes by group","prompt":"We've been seeing some rejection spikes in our data routing — please run a record quality audit and a date-category pivot on these 120 rows across group-a and group-b so I can identify which groups and dates are driving the most rejections."}],"resultDescription":"Returns two independent analytical reports: (1) a record quality audit summarizing accepted and rejected record distributions and quality metrics across the supplied rows, and (2) a date-by-category pivot table breaking down the selected field (accepted_records or rejected_records) by date and dataset group — all computed locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 row or more than 200 rows supplied — validation error","Row missing required fields (row_id, dataset_group, date, accepted_records, rejected_records) — schema validation failure","Date field not matching YYYY-MM-DD format — pattern validation error","Field selector not one of 'accepted_records' or 'rejected_records' — enum validation error","Numeric values outside allowed range (±1,000,000,000,000) — validation failure","Payment of 0.01 USDC not completed — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of record routing data with accepted/rejected record counts and need both a quality audit and a date-by-category pivot in a single call. It is ideal for data pipeline monitoring, batch quality reviews, and category-level breakdowns without requiring any external data sources or live lookups. Prefer this over generic analytics tools when the data is already structured with row_id, dataset_group, and date fields and you need two specific pre-built report types in one low-cost API call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:11.688Z","isFirstParty":false,"canonicalSlug":"record-routing-record-quality-audit-date-by-category-pivot-4038165d"}