{"uid":"cap_h2rwkQXsbPHuavTbA5TlV","slug":"join-coverage-record-quality-audit-with-iqr-outlier-flags-63572191","name":"Join Coverage Record Quality Audit with IQR Outlier Flags","description":"Join coverage — Record quality audit + IQR outlier flags: Record quality audit + IQR outlier flags for supplied join coverage records (matched_rows, source_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-09-014?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["matched_rows","source_rows"],"type":"string","default":"matched_rows"}}},"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_gv4u02CPqb6Vo_auG8j1m","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":"Performs a record quality audit and IQR-based outlier detection on supplied join coverage data (matched_rows, source_rows) for up to 200 rows, returning 2 independent analytical reports.","exampleAgentPrompt":"Can you run a record quality audit and IQR outlier detection on my join coverage data — I have 4 rows across two groups (group-a and group-b) with matched_rows and source_rows counts for dates in October 2026, and I want to flag outliers in the matched_rows field?","exampleUseCases":[{"title":"ETL pipeline join coverage audit","prompt":"I ran an ETL job and want to audit the quality of my join coverage results — here are 50 rows with row_id, date, dataset_group, matched_rows, and source_rows. Can you flag any IQR outliers in the matched_rows field and give me a full record quality report?"},{"title":"Detecting anomalous source row counts","prompt":"I have daily join coverage data for three dataset groups spanning 30 days. Can you run the IQR outlier detection on the source_rows field and tell me which records look anomalous compared to the rest?"},{"title":"Data quality check before pipeline merge","prompt":"Before I merge my datasets I want to validate the join coverage stats — I've got 100 rows with matched_rows and source_rows per group. Can you do a record quality audit and highlight any outlier rows using IQR so I know what to investigate?"}],"resultDescription":"Returns 2 independent analytical reports: (1) a record quality audit summarizing completeness, validity, and structural issues across the supplied rows, and (2) IQR-based outlier flags identifying which rows have anomalous values in the selected field (matched_rows or source_rows), all computed locally without external lookups.","failureModes":["Fewer than 1 row supplied — minimum input not met","More than 200 rows submitted — exceeds max item limit","Missing required fields (row_id, date, matched_rows, source_rows, dataset_group) in any row","Date field not in YYYY-MM-DD format — pattern validation failure","Numeric values out of allowed range (±1 trillion)","Invalid field enum value — must be 'matched_rows' or 'source_rows'","Payment not completed — x402 protocol payment required before response"],"whenToPreferThis":"Choose this endpoint when you need a combined record quality audit AND IQR outlier detection on join coverage metrics in a single API call. It is ideal for data engineers and analysts who want to validate ETL join outputs, detect anomalous match rates, or audit data pipeline quality without external dependencies. Prefer it over generic stats APIs when your data specifically involves matched_rows and source_rows join coverage fields and you need two structured reports for up to 200 rows at low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:45.507Z","isFirstParty":false,"canonicalSlug":"join-coverage-record-quality-audit-with-iqr-outlier-flags-63572191"}