{"uid":"cap_oOnypmlTlCAvcUGTyIqEB","slug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-2884ee73","name":"Join Coverage Analytics: Record Quality Audit, Exact Row Deduplication & Duplicate Key Report","description":"Join coverage — Record quality audit + Exact row deduplication + Duplicate key report: Record quality audit + Exact row deduplication + Duplicate key report for supplied join coverage records (matched_rows, source_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-09-209?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}}},"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_Ieco4EfZXx48JXxPED481","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 supplied join coverage records (matched_rows, source_rows): a record quality audit, exact row deduplication, and a duplicate key report — all in one call for up to 200 rows.","exampleAgentPrompt":"Run a record quality audit, exact row deduplication, and duplicate key report on these join coverage records — I have 4 rows across two dataset groups (group-a and group-b) with matched_rows and source_rows counts for dates in October 2026.","exampleUseCases":[{"title":"Pipeline join coverage data quality check","prompt":"Audit these 12 join coverage records from my ETL pipeline — they span three dataset groups across Q3 and I want to know about quality issues, any exact duplicate rows, and duplicate row IDs before I push to production."},{"title":"Deduplicating analyst-submitted join metrics","prompt":"My analytics team submitted 50 join coverage records for the 'revenue' dataset group with matched_rows and source_rows for each day in September — can you deduplicate them exactly and flag any duplicate keys?"},{"title":"Validating join coverage before dashboard refresh","prompt":"Before I refresh my dashboard, run all three reports — quality audit, deduplication, and duplicate key check — on these 30 join coverage rows covering the 'orders' and 'customers' dataset groups from 2026-01-01 to 2026-01-30."}],"resultDescription":"Returns three independent reports: (1) a record quality audit flagging issues such as nulls or out-of-range values in matched_rows/source_rows; (2) an exact row deduplication result listing which rows are duplicates; and (3) a duplicate key report identifying repeated row_id or dataset_group/date combinations — all computed locally from the supplied data with no external lookup.","failureModes":["More than 200 rows supplied — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation errors","Date field not matching YYYY-MM-DD pattern causes schema rejection","Empty rows array returns error","Numeric values outside the allowed range (-1e12 to 1e12) cause validation failure"],"whenToPreferThis":"Choose this endpoint when you need a bundled, low-cost ($0.01 USDC) batch analysis of join coverage records and want three reports (quality audit, deduplication, duplicate key detection) in a single call without any external API lookups or live data dependencies. Ideal for data engineering pipelines validating join coverage outputs, or analysts who need quick integrity checks on small datasets (up to 200 rows) without spinning up a dedicated analytics environment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:37.864Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-2884ee73"}