{"uid":"cap_uqf2Gb-NeT2TG7041DhfO","slug":"data-ingestion-batches-record-quality-audit-string-normalisation-7fbc1c07","name":"Data Ingestion Batches — Record Quality Audit + String Normalisation + Duplicate Key Report","description":"Data ingestion batches — Record quality audit + String normalisation + Duplicate key report: Record quality audit + String normalisation + Duplicate key report for supplied data ingestion batches records (received_rows, accepted_rows). 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-01-192?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","received_rows","accepted_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"accepted_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"received_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","accepted_rows":1,"dataset_group":"group-a","received_rows":10},{"date":"2026-10-02","row_id":"row-2","accepted_rows":2,"dataset_group":"group-b","received_rows":20},{"date":"2026-10-03","row_id":"row-3","accepted_rows":3,"dataset_group":"group-a","received_rows":15},{"date":"2026-10-04","row_id":"row-4","accepted_rows":4,"dataset_group":"group-b","received_rows":30}],"maxItems":200,"minItems":1}}},"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_2NiwgUaKUhO_-EYol2bpJ","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 independent analytical reports on data ingestion batch records: a record quality audit, string normalisation, and a duplicate key report — all offline, no external calls.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and duplicate key report on my ingestion batch data? I have rows with fields like row_id, dataset_group, date, received_rows, and accepted_rows — here are my records: [{\"row_id\":\"row-1\",\"dataset_group\":\"group-a\",\"date\":\"2026-10-01\",\"received_rows\":10,\"accepted_rows\":1},{\"row_id\":\"row-2\",\"dataset_group\":\"group-b\",\"date\":\"2026-10-02\",\"received_rows\":20,\"accepted_rows\":2}].","exampleUseCases":[{"title":"ETL pipeline batch quality check","prompt":"I just ran an ETL job and want to check the ingestion batch logs for quality issues, string inconsistencies, and duplicate row IDs — can you run a quality audit, string normalisation, and duplicate key report on these rows? Here they are: [{\"row_id\":\"batch-001\",\"dataset_group\":\"Sales Data\",\"date\":\"2025-03-15\",\"received_rows\":5000,\"accepted_rows\":4800},{\"row_id\":\"batch-001\",\"dataset_group\":\"sales data\",\"date\":\"2025-03-15\",\"received_rows\":5000,\"accepted_rows\":4800}]."},{"title":"Data warehouse ingestion validation","prompt":"Before I load these ingestion batch records into the warehouse, can you run the three-report analytics — record quality audit, string normalisation, and duplicate key detection — on my dataset? It has up to 150 rows with columns for row_id, dataset_group, date, received_rows, and accepted_rows."},{"title":"Monthly data acceptance rate audit","prompt":"I have a month's worth of daily ingestion batch summaries and need to audit them for quality problems, normalise the dataset group name strings, and flag any duplicate row IDs. Can you run all three reports at once on my 30 rows of received_rows and accepted_rows data?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging anomalies or invalid values in the supplied rows, (2) a string normalisation report cleaning and standardising text fields like dataset_group, and (3) a duplicate key report identifying repeated row_id or key combinations — all computed locally without any external lookups.","failureModes":["More than 200 rows submitted — endpoint accepts a maximum of 200 rows per call","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) cause validation errors","Invalid date format (not YYYY-MM-DD) rejected by schema pattern validation","Numeric values for received_rows or accepted_rows outside allowed range cause schema rejection","Empty rows array (minItems: 1 not met) returns an error","Payment of 0.01 USDC not received — request blocked by x402 paywall"],"whenToPreferThis":"Choose this endpoint when you need to validate, normalise, and deduplicate data ingestion batch records in a single call without any external API lookups or predictions. It is ideal for ETL pipeline auditing, pre-warehouse data quality checks, and identifying inconsistencies in batch logs containing received_rows and accepted_rows fields. Prefer it over general data validation tools when your data specifically matches the ingestion batch schema and you want three bundled analytical reports at minimal cost ($0.01 USDC).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T18:45:21.863Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-record-quality-audit-string-normalisation-7fbc1c07"}