{"uid":"cap_DLHK8a74nokK7cP45hnzf","slug":"transformation-throughput-duplicate-key-report-numeric-interval-filter-eb06602a","name":"Transformation Throughput — Duplicate Key Report + Numeric Interval Filter","description":"Transformation throughput — Duplicate key report + Numeric interval filter: Duplicate key report + Numeric interval filter for supplied transformation throughput records (processed_rows, duration_seconds). 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-13-059?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_ZWF0dqjKYQ1gpVlLLiIDY","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 transformation throughput records to generate a duplicate key report and a numeric interval filter report for processed_rows or duration_seconds fields, handling up to 200 rows.","exampleAgentPrompt":"Check my transformation throughput records for duplicate row IDs and also filter for rows where processed_rows is between 50 and 500 — here are up to 200 records with row_id, dataset_group, date, processed_rows, and duration_seconds fields.","exampleUseCases":[{"title":"ETL pipeline deduplication audit","prompt":"I have 150 transformation throughput records from last week's ETL runs — can you find any duplicate row IDs and also show me which records have processed_rows between 1000 and 50000? Each record has a row_id, dataset_group, date, processed_rows, and duration_seconds."},{"title":"Pipeline duration range filtering","prompt":"Run two reports on my pipeline throughput logs: first find any duplicate keys, then filter for records where duration_seconds is between 10 and 300. I have about 80 records with row_id, dataset_group, date, processed_rows, and duration_seconds columns."},{"title":"Data quality check on batch processing output","prompt":"I need to validate my batch processing throughput data — check for any duplicate row IDs and filter processed_rows to only show entries between 0 and 10000. Here are the records with row_id, dataset_group, date, processed_rows, and duration_seconds."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report listing any row_ids or keys that appear more than once across the supplied records, and (2) a numeric interval filter report showing which records have the specified field (processed_rows or duration_seconds) falling within the given minimum and maximum bounds. Both reports are computed locally from the supplied data without external lookups.","failureModes":["Exceeding 200 rows causes rejection — must trim input to ≤200 records","Missing required fields (row_id, dataset_group, date, processed_rows, duration_seconds) on any row causes validation failure","Invalid date format (not YYYY-MM-DD) causes schema rejection","Minimum greater than maximum for the interval filter may return empty filter results","Null values in the target numeric field are excluded from the interval filter","Payment failure (insufficient USDC balance) results in 402 response and no report generated"],"whenToPreferThis":"Choose this endpoint when you need simultaneous duplicate key detection and numeric range filtering on transformation throughput records (processed_rows or duration_seconds) in a single paid call. It is ideal for ETL/data pipeline quality checks where you want both reports for $0.01 USDC rather than making separate API calls. Prefer alternatives if you need more than 200 rows, need live data lookups, require grouping summaries, or need trailing mean / histogram analytics (other sibling endpoints cover those combinations).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:26.624Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-duplicate-key-report-numeric-interval-filter-eb06602a"}