{"uid":"cap_pVarBMrOjC-JLfLgCnnZa","slug":"transformation-throughput-analytics-record-quality-audit-string-aa997fc5","name":"Transformation Throughput Analytics — Record Quality Audit, String Normalisation & Duplicate Key Report","description":"Transformation throughput — Record quality audit + String normalisation + Duplicate key report: Record quality audit + String normalisation + 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-192?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_3CkWzNdvycJUPE8NDbD9M","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 (record quality audit, string normalisation, and duplicate key detection) on supplied transformation throughput records containing processed_rows and duration_seconds fields.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and duplicate key report on my transformation throughput data — here are 4 rows: row-1 for group-a on 2026-10-01 with 10 processed rows over 1 second, row-2 for group-b on 2026-10-02 with 20 rows over 2 seconds, row-3 for group-a on 2026-10-03 with 15 rows over 3 seconds, and row-4 for group-b on 2026-10-04 with 30 rows over 4 seconds?","exampleUseCases":[{"title":"ETL batch quality check before reporting","prompt":"I have a week's worth of ETL run records — each with a row ID, dataset group, date, processed row count, and duration in seconds. Can you audit them for quality issues, normalise any inconsistent string fields, and flag any duplicate row IDs before I send the summary to my data team?"},{"title":"Detecting duplicate keys in pipeline logs","prompt":"Our pipeline logging system may have accidentally written duplicate entries. I've got about 150 throughput records with row IDs, group names, dates, processed row counts, and durations — can you run a duplicate key report on them and also do a quality audit at the same time?"},{"title":"Normalising dataset group names across transformation runs","prompt":"We've got transformation throughput records from multiple systems and the dataset_group field has inconsistent casing and whitespace. Can you normalise those strings and also flag any quality issues or duplicate keys across the 80 records I'll send you?"}],"resultDescription":"Three independent analytical reports: (1) a record quality audit highlighting missing, null, or out-of-range values in the supplied rows; (2) a string normalisation report identifying and correcting inconsistencies in text fields such as dataset_group; and (3) a duplicate key report flagging row_id or composite key collisions across the submitted records. All analysis is performed locally using shared analytical engines on up to 200 rows per call.","failureModes":["Submitting more than 200 rows returns an error — batch must be split","Missing required fields (row_id, dataset_group, date, processed_rows, duration_seconds) cause row-level validation failures","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Null numeric values are accepted but flagged in quality audit output","Empty rows array (minItems:1 not met) returns a schema validation error"],"whenToPreferThis":"Choose this endpoint when you need three simultaneous analytical reports — quality audit, string normalisation, and duplicate key detection — on transformation throughput records (processed_rows, duration_seconds) in a single low-cost call. It is ideal for data engineering pipelines where ETL batch metrics need to be validated offline without any external lookups or live data fetching. Prefer it over separate single-report endpoints when all three analyses are needed together for up to 200 rows at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:28.643Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-record-quality-audit-string-aa997fc5"}