{"uid":"cap_MNQZ0nbreIoJFwKeu7EJT","slug":"transformation-throughput-analytics-record-quality-audit-exact-row-e1597061","name":"Transformation Throughput Analytics: Record Quality Audit + Exact Row Deduplication + Duplicate Key Report","description":"Transformation throughput — Record quality audit + Exact row deduplication + Duplicate key report: Record quality audit + Exact row deduplication + Duplicate key report for supplied transformation throughput records (processed_rows, duration_seconds). 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-13-209?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","processed_rows","duration_seconds"],"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},"processed_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"duration_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","processed_rows":10,"duration_seconds":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","processed_rows":20,"duration_seconds":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","processed_rows":15,"duration_seconds":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","processed_rows":30,"duration_seconds":4}],"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_tEJitpc9jDg3BBBqnRZ4f","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":"Analyzes up to 200 transformation throughput records (processed_rows, duration_seconds) to produce three independent local reports: a record quality audit, exact row deduplication, and a duplicate key report.","exampleAgentPrompt":"Can you audit the quality of my transformation throughput records, deduplicate exact rows, and flag any duplicate keys? Here are my records: row-1 on 2026-10-01 in group-a with 10 processed_rows and 1 duration_second, row-2 on 2026-10-02 in group-b with 20 processed_rows and 2 duration_seconds — up to 200 rows total, and I need all three reports back.","exampleUseCases":[{"title":"ETL pipeline run quality check","prompt":"I have 150 records from last night's ETL pipeline run with processed_rows and duration_seconds per batch. Can you run a full record quality audit, deduplicate any exact duplicate rows, and give me a duplicate key report so I can clean up before loading to the warehouse?"},{"title":"Duplicate detection in throughput logs","prompt":"My transformation throughput logs for dataset group 'sales-daily' from October might have duplicate entries. Can you check these records for exact row duplicates and give me a duplicate key report — I have about 80 rows with row_id, date, processed_rows, and duration_seconds?"},{"title":"Data quality validation before reporting","prompt":"Before I generate our weekly pipeline performance report, I need to validate these 200 transformation throughput records for quality issues, remove any exact duplicates, and flag any duplicate keys — the fields are row_id, dataset_group, date, processed_rows, and duration_seconds."}],"resultDescription":"Three independent analytical reports: (1) a record quality audit identifying malformed, null, or out-of-range values across the supplied rows; (2) an exact row deduplication report listing and removing perfectly identical rows; and (3) a duplicate key report identifying rows sharing the same key fields. All analysis is performed locally on the submitted data with no external lookups.","failureModes":["More than 200 rows submitted — exceeds the maxItems limit, request rejected","Missing required fields (row_id, dataset_group, date, processed_rows, or duration_seconds) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — schema rejection","Empty rows array (minItems: 1 not met) — request rejected","Payment not included or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need three bundled local analytical reports — record quality audit, exact deduplication, and duplicate key detection — for transformation throughput data (processed_rows and duration_seconds) in a single cost-effective call ($0.01 USDC for all three). Ideal for data engineers validating ETL pipeline outputs before downstream loading, especially when working with batches up to 200 rows and no external data enrichment or prediction is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:41:49.414Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-record-quality-audit-exact-row-e1597061"}