{"uid":"cap_RKGq3kfZcIyNKBRe3GtV1","slug":"pipeline-durations-analytics-exact-row-deduplication-numeric-row-5d6b9dff","name":"Pipeline Durations Analytics: Exact Row Deduplication + Numeric Row Ordering","description":"Pipeline durations — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering for supplied pipeline durations records (run_seconds, processed_rows). 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-05-042?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","run_seconds","processed_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"run_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"processed_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","run_seconds":10,"dataset_group":"group-a","processed_rows":1},{"date":"2026-10-02","row_id":"row-2","run_seconds":20,"dataset_group":"group-b","processed_rows":2},{"date":"2026-10-03","row_id":"row-3","run_seconds":15,"dataset_group":"group-a","processed_rows":3},{"date":"2026-10-04","row_id":"row-4","run_seconds":30,"dataset_group":"group-b","processed_rows":4}],"maxItems":200,"minItems":1},"field":{"enum":["run_seconds","processed_rows"],"type":"string","default":"run_seconds"}}},"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_QB9OIWF2JnbjcdY17R3Qj","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":"Deduplicates pipeline duration records and applies numeric row ordering across up to 200 rows of run_seconds and processed_rows data, returning 2 analytical reports.","exampleAgentPrompt":"I have a batch of pipeline run records with run_seconds and processed_rows fields — can you deduplicate them and return them in numeric order? Here are up to 200 rows across group-a and group-b, and I want the analysis done on run_seconds.","exampleUseCases":[{"title":"ETL pipeline timing audit","prompt":"I need to clean up my ETL pipeline logs — can you deduplicate these 150 pipeline duration records and order them numerically by run_seconds? I have rows with row_ids, dates, dataset groups, and both run_seconds and processed_rows values."},{"title":"Duplicate detection in batch job records","prompt":"I've got a set of pipeline execution records for two dataset groups spanning the last quarter — please run exact deduplication on them and give me both the deduplication report and the numerically ordered version for the processed_rows field."},{"title":"Data quality check before reporting","prompt":"Before I hand off these pipeline stats to my reporting tool, can you run deduplication and numeric ordering on these records? I have about 80 rows with run_seconds and processed_rows and need 2 clean analytical reports back."}],"resultDescription":"Two analytical reports derived from the supplied pipeline duration rows: one covering exact row deduplication results (identifying and removing duplicate records) and one covering numeric row ordering (rows sorted by the selected field — either run_seconds or processed_rows). No external lookups or predictions are made; all processing is local and deterministic.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, run_seconds, processed_rows) cause validation error","Invalid date format (not YYYY-MM-DD) fails schema validation","Numeric fields out of allowed range (-1e12 to 1e12) rejected","Invalid field enum value (not run_seconds or processed_rows) causes error","Empty rows array rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need both exact deduplication and numeric ordering applied to pipeline duration data (run_seconds or processed_rows) in a single call returning two reports. It is ideal for data engineering workflows where you want to clean pipeline execution logs offline without any external API calls, predictions, or live data lookups — all processing is local and deterministic. Best for datasets up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T06:52:16.921Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-analytics-exact-row-deduplication-numeric-row-5d6b9dff"}