{"uid":"cap_DDK14iM8PCkkpYlIxAgQP","slug":"pipeline-durations-analytics-quality-audit-deduplication-category-a87f8852","name":"Pipeline Durations Analytics: Quality Audit + Deduplication + Category Frequencies","description":"Pipeline durations — Record quality audit + Exact row deduplication + Category frequencies: Record quality audit + Exact row deduplication + Category frequencies 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-212?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}}},"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_1FUvtZ2kgzm6Hm-0Iyswv","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 analytical reports on pipeline duration records — a record quality audit, exact row deduplication, and category frequency analysis — for up to 200 rows of run_seconds/processed_rows data.","exampleAgentPrompt":"Can you run a quality audit, exact deduplication check, and category frequency report on these pipeline duration records — I have up to 50 rows with fields like row_id, dataset_group, date, run_seconds, and processed_rows?","exampleUseCases":[{"title":"ETL pipeline health check","prompt":"I have a batch of 80 pipeline run records with run_seconds and processed_rows — can you audit them for data quality issues, remove any exact duplicates, and tell me how many runs each dataset group has?"},{"title":"Duplicate pipeline log detection","prompt":"My pipeline logging system may have written duplicate entries — can you check these 120 records for exact row duplicates and also give me a quality report and category frequency breakdown by dataset_group?"},{"title":"Daily pipeline run summary","prompt":"At the end of today's pipeline runs, I want to validate data quality, deduplicate the 45 records I've collected, and get a frequency count showing how often each dataset group ran — the records have run_seconds, processed_rows, and a date field in YYYY-MM-DD format."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging nulls, out-of-range values, and completeness issues in run_seconds and processed_rows; (2) an exact row deduplication report identifying and removing identical records; and (3) a category frequency table showing how often each dataset_group value appears across the supplied rows.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, run_seconds, processed_rows) cause row-level rejection","Malformed date strings not matching YYYY-MM-DD pattern fail schema validation","Empty rows array returns an error (minItems: 1)","Payment failure via x402 protocol prevents execution"],"whenToPreferThis":"Choose this endpoint when you need three combined analytical reports — quality audit, deduplication, and category frequency — on pipeline duration data (run_seconds, processed_rows) in a single low-cost call. Ideal for data engineering teams that want to validate and summarize ETL pipeline logs without building their own analytical pipeline. Best for batches up to 200 rows where local computation (no external lookups) is sufficient.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T06:55:06.665Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-analytics-quality-audit-deduplication-category-a87f8852"}