{"uid":"cap_arG-PIJuHDr6q-1YqChe4","slug":"transformation-throughput-record-quality-audit-string-normalisation-04a88f25","name":"Transformation Throughput — Record Quality Audit + String Normalisation + Numeric Interval Filter","description":"Transformation throughput — Record quality audit + String normalisation + Numeric interval filter: Record quality audit + String normalisation + Numeric interval filter 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-197?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},"field":{"enum":["processed_rows","duration_seconds"],"type":"string","default":"processed_rows"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_pcQrXEDtE7oLXXeFTDsKY","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":"Audits data quality, normalises strings, and filters by numeric interval for transformation throughput records (processed_rows, duration_seconds) across up to 200 rows in three bundled reports.","exampleAgentPrompt":"Can you audit the data quality, normalise the dataset group strings, and filter to only rows where processed_rows is between 0 and 500 for this set of transformation throughput records: [{\"row_id\":\"run-1\",\"dataset_group\":\"group-a\",\"date\":\"2026-10-01\",\"processed_rows\":120,\"duration_seconds\":5},{\"row_id\":\"run-2\",\"dataset_group\":\" Group-B \",\"date\":\"2026-10-02\",\"processed_rows\":750,\"duration_seconds\":10}]?","exampleUseCases":[{"title":"ETL pipeline run quality check","prompt":"I have 50 transformation throughput records from yesterday's pipeline runs — can you audit their data quality, normalise the dataset_group strings, and filter to only rows where processed_rows falls between 10 and 50000? Here's the data: [{\"row_id\":\"r1\",\"dataset_group\":\" Sales \",\"date\":\"2026-11-01\",\"processed_rows\":12000,\"duration_seconds\":30},{\"row_id\":\"r2\",\"dataset_group\":\"marketing\",\"date\":\"2026-11-01\",\"processed_rows\":null,\"duration_seconds\":15}]."},{"title":"Duration outlier range validation","prompt":"Can you run a quality audit and numeric interval filter on duration_seconds for these transformation throughput rows, keeping only records where duration_seconds is between 1 and 3600? Here are my rows: [{\"row_id\":\"job-a\",\"dataset_group\":\"finance\",\"date\":\"2026-10-15\",\"processed_rows\":5000,\"duration_seconds\":7200},{\"row_id\":\"job-b\",\"dataset_group\":\"finance\",\"date\":\"2026-10-16\",\"processed_rows\":3000,\"duration_seconds\":900}]."},{"title":"Dataset group label normalisation for reporting","prompt":"My ETL logs have inconsistently cased and padded dataset_group names — please normalise the strings and audit data quality for these 5 throughput records, and also filter processed_rows to between 0 and 100000: [{\"row_id\":\"t1\",\"dataset_group\":\" HR Data \",\"date\":\"2026-09-30\",\"processed_rows\":80000,\"duration_seconds\":60},{\"row_id\":\"t2\",\"dataset_group\":\"hr data\",\"date\":\"2026-09-30\",\"processed_rows\":95000,\"duration_seconds\":55}]."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging nulls, missing fields, and anomalies; (2) a string normalisation report for the dataset_group field; and (3) a numeric interval filter report identifying which rows fall within the specified minimum–maximum range for the chosen field (processed_rows or duration_seconds). All reports are computed locally on the supplied data with no external lookups.","failureModes":["Empty or missing rows array returns validation error","More than 200 rows submitted exceeds the item limit and is rejected","Invalid date format (not YYYY-MM-DD) causes schema rejection","Minimum value greater than maximum value may produce empty filter results","Null or missing row_id fails the required field check","Field enum value outside 'processed_rows' or 'duration_seconds' is rejected"],"whenToPreferThis":"Choose this endpoint when you need a bundled, cost-effective single call (0.01 USDC) that simultaneously covers data quality auditing, string normalisation, and numeric range filtering for transformation throughput records. It is ideal for ETL pipeline validation workflows where all three operations are needed together on the same dataset of up to 200 rows, and no external data sources or predictions are required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:16.291Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-record-quality-audit-string-normalisation-04a88f25"}