{"uid":"cap_uh7SwY_XbTTSexhkwhTQk","slug":"data-ingestion-batches-record-quality-audit-string-normalisation-date-3ad230bd","name":"Data Ingestion Batches — Record Quality Audit, String Normalisation & Date-by-Category Pivot","description":"Data ingestion batches — Record quality audit + String normalisation + Date by category pivot: Record quality audit + String normalisation + Date by category pivot 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-206?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},"field":{"enum":["received_rows","accepted_rows"],"type":"string","default":"received_rows"}}},"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_fsl9NOWNpf0yre4rj16a3","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 analytical reports on up to 200 data ingestion batch rows: a record quality audit, string normalisation, and a date-by-category pivot for received_rows or accepted_rows.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and date-by-category pivot on these ingestion batch rows — I have about 50 rows with row_id, dataset_group, date, received_rows, and accepted_rows — and use the accepted_rows field for the pivot?","exampleUseCases":[{"title":"ETL pipeline quality check","prompt":"I've got 120 rows from last week's data ingestion batches — each with a row_id, dataset_group, date, received_rows, and accepted_rows. Can you audit the record quality, normalise the dataset_group strings, and pivot accepted_rows by date and category so I can spot which groups had the most rejections?"},{"title":"Daily batch acceptance rate review","prompt":"Run a quality audit plus a date-by-category pivot on these 80 ingestion batch records using the received_rows field — I need to see how many rows were received per group per day and whether any records look malformed or incomplete."},{"title":"Data onboarding group comparison","prompt":"We just onboarded three new data partners and I have 45 rows of ingestion data with received_rows and accepted_rows for each. Can you do a quality audit, clean up the dataset_group names with string normalisation, and give me a date pivot so I can compare acceptance rates across groups over the past two weeks?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging completeness and consistency issues across the supplied rows, (2) a string normalisation report standardising dataset_group and other string fields, and (3) a date-by-category pivot table summarising either received_rows or accepted_rows grouped by date and dataset_group. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected, trim to 200 max","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) — validation error","Date field not in YYYY-MM-DD format — pattern validation failure","Numeric fields outside allowed range (±1,000,000,000,000) — schema rejection","Empty rows array — minItems:1 constraint failure","Invalid field enum value (not 'received_rows' or 'accepted_rows') — schema error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 data ingestion batch records and need three simultaneous analyses — quality audit, string normalisation, and date pivot — in a single cheap call ($0.01 USDC). It is ideal for ETL pipeline monitoring, batch acceptance rate review, and data onboarding quality checks where no live external lookup or ML prediction is needed and all computation is local to the supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:46.962Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-record-quality-audit-string-normalisation-date-3ad230bd"}