{"uid":"cap_0YjQgUZYDEWf7rwGFEy_D","slug":"join-coverage-record-quality-audit-exact-row-deduplication-4131c84a","name":"Join Coverage — Record Quality Audit + Exact Row Deduplication","description":"Join coverage — Record quality audit + Exact row deduplication: Record quality audit + Exact row deduplication 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-002?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_XdHCIxb13knst-BWKCwN3","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 two local analytical reports on join coverage data: a record quality audit and exact row deduplication, for up to 200 rows of matched_rows/source_rows data.","exampleAgentPrompt":"Can you run a record quality audit and exact row deduplication on this join coverage data? I have 4 rows: row-1 on 2026-10-01 with source_rows=1 and matched_rows=10 in group-a, row-2 on 2026-10-02 with source_rows=2 and matched_rows=20 in group-b, row-3 on 2026-10-03 with source_rows=3 and matched_rows=15 in group-a, and row-4 on 2026-10-04 with source_rows=4 and matched_rows=30 in group-b.","exampleUseCases":[{"title":"Pre-pipeline join coverage validation","prompt":"Before I load this into the warehouse, can you audit these 50 join coverage records for quality issues and flag any exact duplicates? The rows span dataset groups alpha and beta from 2025-01-01 to 2025-02-19, each with matched_rows and source_rows counts."},{"title":"Duplicate detection in ETL output","prompt":"My ETL job just produced join coverage output — can you check these 120 rows for exact duplicates and also flag any records with missing or suspicious matched_rows or source_rows values? Groups are region-north and region-south across October 2025."},{"title":"Data handoff quality check between teams","prompt":"We're handing off join coverage data to another team and need a clean bill of health — please run a record quality audit and deduplication check on these 30 rows across dataset groups prod and staging dated between 2024-06-01 and 2024-06-30."}],"resultDescription":"Returns two independent analytical reports for the supplied join coverage rows: (1) a record quality audit identifying issues such as nulls, out-of-range values, or malformed fields across matched_rows and source_rows; and (2) an exact row deduplication report identifying any fully duplicated records within the submitted dataset. All analysis is performed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes schema rejection","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Submitting zero rows triggers minItems constraint failure","Payment failure or insufficient USDC balance blocks request processing"],"whenToPreferThis":"Choose this endpoint when you need both a record quality audit and exact deduplication in a single paid call on join coverage data (matched_rows, source_rows) with up to 200 rows, and you want purely local, offline analysis with no external lookups or predictions. It is ideal for data engineering pipelines, ETL validation steps, or pre-handoff data hygiene checks on join metrics.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:46.662Z","isFirstParty":false,"canonicalSlug":"join-coverage-record-quality-audit-exact-row-deduplication-4131c84a"}