{"uid":"cap_7DP2ObayFNT37TxTE-Rzj","slug":"record-routing-analytics-quality-audit-deduplication-grouped-summary-2f325f10","name":"Record Routing Analytics: Quality Audit, Deduplication & Grouped Summary","description":"Record routing — Record quality audit + Exact row deduplication + Grouped numeric summary: Record quality audit + Exact row deduplication + Grouped numeric summary for supplied record routing records (accepted_records, rejected_records). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-19-211?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_-bschAylsJAksF398jbUD","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 three local analytical reports on record routing data: a quality audit, exact row deduplication, and a grouped numeric summary of accepted/rejected record counts.","exampleAgentPrompt":"Can you run a quality audit, deduplicate, and group summary on my record routing data? I have rows with row_id, dataset_group, date, accepted_records, and rejected_records — up to 200 rows — and I want the analysis based on the accepted_records field.","exampleUseCases":[{"title":"ETL pipeline data quality check","prompt":"I have up to 150 rows of record routing logs with accepted and rejected record counts per dataset group and date. Can you run a quality audit on the accepted_records field, remove any exact duplicate rows, and give me a grouped numeric summary by dataset_group?"},{"title":"Deduplication audit for routing logs","prompt":"My routing records dataset might have duplicate rows — can you run an exact deduplication check on these rows along with a quality audit? Each row has a row_id, date, dataset_group, accepted_records, and rejected_records."},{"title":"Grouped rejection rate analysis","prompt":"I want to understand how rejected_records vary across my dataset groups. Can you run the grouped numeric summary and quality audit on my record routing data using the rejected_records field? I'll provide about 80 rows with row_id, date, dataset_group, accepted_records, and rejected_records."}],"resultDescription":"Three analytical reports: (1) a record quality audit flagging missing or anomalous values across the dataset, (2) an exact row deduplication report identifying and removing fully duplicate rows, and (3) a grouped numeric summary aggregating the selected numeric field (accepted_records or rejected_records) by dataset_group — all computed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, dataset_group) cause row-level rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation failure","Numeric values outside the allowed range cause field-level errors","Empty rows array returns an error due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical operations on a single record routing dataset in one call — quality auditing, deduplication, and grouped aggregation — without requiring external data sources or live lookups. Ideal for ETL pipeline monitoring, data hygiene checks, and summarizing accepted vs rejected record volumes by group, especially when cost efficiency matters (all three reports for $0.01 USDC per call on up to 200 rows).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:51.747Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-quality-audit-deduplication-grouped-summary-2f325f10"}