{"uid":"cap_N6jLxpBNS4StyWuG-hnuh","slug":"pipeline-durations-analytics-quality-audit-deduplication-numeric-70ba79e9","name":"Pipeline Durations Analytics — Quality Audit + Deduplication + Numeric Distribution","description":"Pipeline durations — Record quality audit + Exact row deduplication + Numeric distribution: Record quality audit + Exact row deduplication + Numeric distribution for supplied pipeline durations records (run_seconds, processed_rows). 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-05-210?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_Di9T27laNEiosM9BHSSQM","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 on pipeline duration records: record quality audit, exact row deduplication, and numeric distribution analysis for run_seconds or processed_rows fields.","exampleAgentPrompt":"Audit the quality, deduplicate, and show me the numeric distribution of run_seconds for these pipeline records — I have 4 rows with row_id, dataset_group, date, run_seconds, and processed_rows fields.","exampleUseCases":[{"title":"ETL pipeline run quality check","prompt":"I have a batch of 50 pipeline execution records with run_seconds and processed_rows. Can you audit them for data quality issues, find any exact duplicates, and show me the distribution of run_seconds?"},{"title":"Deduplication before warehouse load","prompt":"Before I load these 120 pipeline duration rows into the warehouse, run an exact deduplication check on them along with a quality audit — use processed_rows as the numeric field for the distribution report."},{"title":"Distribution analysis for SLA review","prompt":"I need to review our pipeline SLA compliance — run a numeric distribution analysis on run_seconds for these 80 pipeline records, and also flag any data quality problems or duplicate rows in the dataset."}],"resultDescription":"Three independent analytical reports: (1) a record quality audit flagging missing, null, or out-of-range values across fields; (2) an exact row deduplication report identifying duplicate records; (3) a numeric distribution summary (min, max, mean, percentiles, etc.) for the chosen field (run_seconds or processed_rows). All computed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, run_seconds, processed_rows) causes schema rejection","Invalid date format (non-YYYY-MM-DD) triggers pattern validation failure","Numeric values outside ±1,000,000,000,000 bounds are rejected","Empty rows array returns an error due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical reports — quality audit, deduplication, and numeric distribution — in a single low-cost call for up to 200 pipeline duration records. Ideal when you want offline, deterministic analysis with no external API calls or ML predictions, and when your data fits the specific schema of run_seconds and processed_rows pipeline metrics.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T06:55:21.916Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-analytics-quality-audit-deduplication-numeric-70ba79e9"}