{"uid":"cap_4dC5WkeDb6n59T3YPwV6e","slug":"data-reconciliation-duplicate-key-report-explicit-missing-value-fill-937a2dbe","name":"Data Reconciliation — Duplicate Key Report + Explicit Missing-Value Fill","description":"Data reconciliation — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill for supplied data reconciliation records (source_total, target_total). 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-11-070?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"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_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_xD0hksE4NBB3sxMqQwOlx","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":"Identifies duplicate row keys and fills missing values (via zero, mean, or median) in up to 200 reconciliation records comparing source_total and target_total fields.","exampleAgentPrompt":"Check my reconciliation data for duplicate row IDs and fill any missing source_total values using the median — here are the rows: [{\"row_id\":\"row-1\",\"dataset_group\":\"group-a\",\"date\":\"2026-10-01\",\"source_total\":10,\"target_total\":null},{\"row_id\":\"row-1\",\"dataset_group\":\"group-a\",\"date\":\"2026-10-02\",\"source_total\":null,\"target_total\":2}].","exampleUseCases":[{"title":"Monthly finance reconciliation cleanup","prompt":"I have 150 rows of monthly finance reconciliation records with some duplicate row IDs and missing source_total values — can you run a duplicate key report and fill in the missing source_total figures using the mean?"},{"title":"Data pipeline null detection","prompt":"My ETL pipeline produced reconciliation records for group-a and group-b and some target_total fields are null — can you identify any duplicate row IDs and fill those missing target_total values with zeros?"},{"title":"Audit-ready data quality check","prompt":"Before I submit this reconciliation dataset for audit, can you flag any duplicate row IDs and replace any missing source_total values using the median so the data is clean and consistent?"}],"resultDescription":"Returns two independent reports: (1) a duplicate key report listing all row_ids that appear more than once in the input, and (2) a missing-value fill report showing the original and imputed values for any null entries in the specified field (source_total or target_total), filled using the chosen method (zero, mean, or median). Covers up to 200 input rows per call.","failureModes":["Input array exceeds 200 rows — request will be rejected","Row missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","source_total or target_total outside allowed range (-1e12 to 1e12) — validation error","Invalid method or field enum value — schema rejection","Empty rows array — minItems constraint violation"],"whenToPreferThis":"Choose this endpoint when you need two specific data quality operations — duplicate key detection and null imputation — applied together to reconciliation data (source vs. target totals) in a single low-cost call. It is ideal for data pipeline validation, pre-audit cleanup, and ETL quality checks on tabular reconciliation records up to 200 rows. It does not perform live lookups, predictions, or external actions, making it suitable for deterministic, offline analytical use cases.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:56.431Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-duplicate-key-report-explicit-missing-value-fill-937a2dbe"}