{"uid":"cap_7HS2tisnPX5aC3DjulMWA","slug":"metadata-completeness-duplicate-key-report-secondary-measure-weighted-60d100b0","name":"Metadata Completeness Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Metadata completeness — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied metadata completeness records (present_fields, expected_fields). 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-web-05-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","site_group","date","present_fields","expected_fields"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"site_group":{"type":"string","default":"","maxLength":80},"present_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"expected_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","site_group":"group-a","present_fields":10,"expected_fields":1},{"date":"2026-10-02","row_id":"row-2","site_group":"group-b","present_fields":20,"expected_fields":2},{"date":"2026-10-03","row_id":"row-3","site_group":"group-a","present_fields":15,"expected_fields":3},{"date":"2026-10-04","row_id":"row-4","site_group":"group-b","present_fields":30,"expected_fields":4}],"maxItems":200,"minItems":1},"field":{"enum":["present_fields","expected_fields"],"type":"string","default":"present_fields"}}},"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_yO5tufOzmDPl2u7p_QciO","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 metadata completeness records (present_fields, expected_fields) to produce a duplicate key report and a secondary-measure weighted mean, using local analytical engines on up to 200 rows.","exampleAgentPrompt":"I have up to 200 metadata completeness records with row_id, site_group, date, present_fields, and expected_fields — can you run a duplicate key report and compute the secondary-measure weighted mean for the present_fields column on this data?","exampleUseCases":[{"title":"Audit metadata pipeline for duplicate keys","prompt":"I've got 150 rows from our metadata pipeline, each with a row_id, site_group, date, present_fields, and expected_fields. Can you run a duplicate key report to find any repeated keys, and also give me the weighted mean of present_fields?"},{"title":"Weighted completeness score across site groups","prompt":"I have metadata completeness records for several site groups across different dates — can you compute the secondary-measure weighted mean for the expected_fields column and also flag any duplicate row IDs in the dataset?"},{"title":"QA check before data ingestion","prompt":"Before I ingest these metadata records into our warehouse, can you check them for duplicate keys and calculate the weighted mean of the present_fields values? There are about 80 rows with row_id, site_group, date, present_fields, and expected_fields."}],"resultDescription":"Returns two analytical reports: (1) a duplicate key report identifying repeated key combinations within the supplied metadata completeness rows, and (2) a secondary-measure weighted mean computed over the selected field (present_fields or expected_fields), all computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, site_group, date, present_fields, expected_fields) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","present_fields or expected_fields outside allowed numeric range — rejected","Empty rows array — minimum 1 row required"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a weighted mean computation on metadata completeness records (present_fields/expected_fields) in a single low-cost call. It is ideal for data quality pipelines that need to validate key uniqueness and summarize completeness metrics without external API calls or live data lookups. Best for datasets up to 200 rows processed locally.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-27T13:06:30.968Z","isFirstParty":false,"canonicalSlug":"metadata-completeness-duplicate-key-report-secondary-measure-weighted-60d100b0"}