{"uid":"cap_l2rqs1kCz5edW7ExO1aah","slug":"data-ingestion-batches-record-quality-audit-date-by-category-pivot-4647a854","name":"Data Ingestion Batches — Record Quality Audit + Date by Category Pivot","description":"Data ingestion batches — Record quality audit + Date by category pivot: Record quality audit + Date by category pivot for supplied data ingestion batches records (received_rows, accepted_rows). 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-01-017?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_pVaFr8B5oc24pdxE1vOLV","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 supplied data ingestion batch records: a record quality audit (checking received_rows vs accepted_rows integrity) and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"Can you run a record quality audit and date-by-category pivot on my ingestion batch data? Here are the rows: row-1 on 2024-01-15, dataset group 'sales', received_rows=1000, accepted_rows=950; row-2 on 2024-01-16, dataset group 'returns', received_rows=500, accepted_rows=480 — use received_rows as the field for the pivot.","exampleUseCases":[{"title":"Daily ETL pipeline quality check","prompt":"I have my ingestion batch logs for yesterday — can you audit the record quality and pivot the accepted_rows by date and dataset group? Here's the data: row-1, group 'orders', 2024-03-10, received 2000, accepted 1950; row-2, group 'customers', 2024-03-10, received 800, accepted 790; row-3, group 'orders', 2024-03-11, received 2100, accepted 1800."},{"title":"Investigating drop in row acceptance rate","prompt":"Something looks off in our ingestion pipeline — can you run a quality audit and date-by-category pivot on these batch records so I can see where rows are being rejected? Use accepted_rows as the pivot field. Rows: row-1, group 'events', 2024-02-01, received 5000, accepted 3200; row-2, group 'events', 2024-02-02, received 5100, accepted 2100; row-3, group 'metrics', 2024-02-01, received 1200, accepted 1190."},{"title":"Monthly ingestion batch summary report","prompt":"Can you generate a record quality audit and a date-by-category pivot for our monthly ingestion batches? Field to pivot: received_rows. Data: row-1, group 'billing', 2024-01-05, received 3000, accepted 2995; row-2, group 'usage', 2024-01-12, received 7000, accepted 6850; row-3, group 'billing', 2024-01-20, received 3100, accepted 3090; row-4, group 'usage', 2024-01-28, received 7200, accepted 7100."}],"resultDescription":"Two analytical reports: (1) a record quality audit summarizing data completeness and acceptance metrics (received_rows vs accepted_rows) for each supplied row, and (2) a date-by-category pivot table grouping the selected field (received_rows or accepted_rows) by date and dataset_group. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected due to maxItems constraint","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) cause validation errors","Date field not matching YYYY-MM-DD pattern returns schema validation error","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) rejected","Invalid field enum value (not 'received_rows' or 'accepted_rows') causes error","Empty rows array rejected due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you need two complementary analytical views — a quality audit and a date-category pivot — on data ingestion batch records in a single low-cost call ($0.01 USDC). Ideal for ETL monitoring, pipeline quality review, and batch acceptance rate analysis without requiring external data sources or live connections. Best when you already have the ingestion batch data in hand and want structured analytical output quickly.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:34.861Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-record-quality-audit-date-by-category-pivot-4647a854"}