{"uid":"cap_xXswae0UoyjIr5QwyPm_D","slug":"transformation-throughput-analytics-record-quality-audit-string-180f6918","name":"Transformation Throughput Analytics: Record Quality Audit + String Normalisation + Exact Row Deduplication","description":"Transformation throughput — Record quality audit + String normalisation + Exact row deduplication: Record quality audit + String normalisation + Exact row deduplication 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-191?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_AyArRqazM_rG5uWB1rRXR","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 record quality, normalises strings, and deduplicates rows in transformation throughput data (processed_rows, duration_seconds) for up to 200 supplied rows, returning 3 independent analytical reports.","exampleAgentPrompt":"Audit the quality of my transformation throughput records, normalise any string fields, and remove exact duplicate rows — here are my records with row IDs, dataset groups, dates, processed_rows counts, and duration_seconds values for the past week across group-a and group-b.","exampleUseCases":[{"title":"ETL pipeline data quality check","prompt":"Can you run a quality audit, string normalisation, and deduplication on these 50 transformation throughput records from our nightly ETL jobs? They have row IDs, dataset groups, dates, processed_row counts, and duration in seconds — I want to find any bad data or duplicates before we load to the warehouse."},{"title":"Deduplicating pipeline performance logs","prompt":"I've got 120 rows of transformation throughput data — row IDs, groups, dates, processed_rows, and duration_seconds — and I suspect there are exact duplicate entries from a logging glitch. Can you run the deduplication and quality audit reports to identify them?"},{"title":"Normalising dataset group strings in throughput metrics","prompt":"My team exported transformation throughput records across several dataset groups and I'm worried some group names have inconsistent capitalisation or spacing. Please run the string normalisation and quality audit on these 80 rows so I can see what needs cleaning before analysis."}],"resultDescription":"Three independent analytical reports: (1) a record quality audit flagging 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) an exact row deduplication report listing and removing fully duplicate rows. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, processed_rows, duration_seconds) causes row rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation error","Submitting zero rows returns a minItems validation error","Extremely large numeric values near the ±1,000,000,000,000 boundary may be flagged as anomalies"],"whenToPreferThis":"Choose this endpoint when you need three distinct data hygiene operations — quality audit, string normalisation, and exact deduplication — applied together to transformation throughput records (processed_rows and duration_seconds) in a single API call. It is ideal for pre-load data cleaning of ETL metrics, pipeline performance logs, or batch processing summaries with up to 200 rows. Prefer this over general-purpose analytics endpoints when your data specifically contains transformation throughput fields and you want all three reports bundled for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:26.898Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-record-quality-audit-string-180f6918"}