{"uid":"cap_iVrigtIbPy_JJbeiAnKA4","slug":"join-coverage-duplicate-key-report-base-100-series-23fbbd07","name":"Join Coverage — Duplicate Key Report + Base-100 Series","description":"Join coverage — Duplicate key report + Base-100 series: Duplicate key report + Base-100 series 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-063?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"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_eGyZhMgYyyhKoMQB5zvph","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":"Analyzes join coverage data (matched_rows, source_rows) to produce a duplicate key report and a Base-100 indexed series for up to 200 rows.","exampleAgentPrompt":"Run a duplicate key report and base-100 series on my join coverage data — field is matched_rows, start the index at row 0 — here are my rows: group-a had 10 matched out of 1 source on 2026-10-01, group-b had 20 matched out of 2 source on 2026-10-02, group-a had 15 matched out of 3 source on 2026-10-03.","exampleUseCases":[{"title":"Duplicate key audit for ETL pipeline","prompt":"I ran a join between two tables and got these matched_rows and source_rows counts per group and date — can you run a duplicate key report on them and also give me a base-100 series indexed from row 0 using the matched_rows field?"},{"title":"Normalizing join metrics across dataset groups","prompt":"I have join coverage records across four dataset groups over the past week — please generate a base-100 series for source_rows starting at base index 2, and also flag any duplicate keys in the data."},{"title":"Data quality check before reporting","prompt":"Before I publish this join coverage summary, can you run a duplicate key report and a base-100 index on matched_rows for these 15 rows across group-alpha and group-beta, starting the index at position 0?"}],"resultDescription":"Returns two analytical reports: (1) a duplicate key report identifying row IDs or keys that appear more than once in the supplied join coverage records, and (2) a Base-100 series that normalizes the selected numeric field (matched_rows or source_rows) relative to the row at the specified base_index. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["More than 200 rows supplied — request rejected due to maxItems limit","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error","date field does not match YYYY-MM-DD pattern — schema validation failure","base_index out of range (≥ number of rows supplied) — computation error","All numeric values are null — base-100 series cannot be computed","Payment not attached or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a Base-100 normalization series on join coverage data in a single call. It is ideal for data engineers validating ETL join results, analysts checking for key duplication before aggregation, or pipelines that need indexed join metrics without external lookups. Prefer this over single-report endpoints when you need both reports at once for up to 200 rows at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:34.037Z","isFirstParty":false,"canonicalSlug":"join-coverage-duplicate-key-report-base-100-series-23fbbd07"}