{"uid":"cap_1aizYVUHKuy_exCLA6SQX","slug":"publication-proofing-duplicate-key-report-explicit-missing-value-fill-4544b178","name":"Publication Proofing — Duplicate Key Report + Explicit Missing-Value Fill","description":"Publication proofing — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill for supplied publication proofing records (checked_pages, flagged_pages). 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-writing-18-070?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","checked_pages","flagged_pages"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"checked_pages":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"flagged_pages":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"document_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","checked_pages":10,"flagged_pages":1,"document_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","checked_pages":20,"flagged_pages":2,"document_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","checked_pages":15,"flagged_pages":3,"document_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","checked_pages":30,"flagged_pages":4,"document_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["checked_pages","flagged_pages"],"type":"string","default":"checked_pages"},"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_woK6HztZzCZbOrU5_i2Cd","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 up to 200 publication proofing records to produce a duplicate key report and fill missing values for checked_pages or flagged_pages using zero, mean, or median imputation.","exampleAgentPrompt":"I have 150 publication proofing records with row IDs, document groups, dates, checked_pages, and flagged_pages — can you run a duplicate key report on them and fill any missing checked_pages values using median imputation?","exampleUseCases":[{"title":"Editorial audit for duplicate page records","prompt":"I've got a batch of 80 proofreading log entries across two document groups and some rows have the same row_id — can you give me a duplicate key report and also fill any null checked_pages values with the median?"},{"title":"Missing flagged-pages imputation for publishing pipeline","prompt":"My publication QA export has about 120 rows but flagged_pages is null in several of them — can you fill those missing values using the mean and also flag any duplicate row IDs in the dataset?"},{"title":"Zero-fill missing data in small proof batch","prompt":"I have 40 proofing records with date, document_group, checked_pages, and flagged_pages — please run a duplicate key check and zero-fill any missing flagged_pages values so I can pass this dataset downstream."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying any rows sharing the same key identifiers, and (2) an explicit missing-value fill report showing imputed values for the selected field (checked_pages or flagged_pages) using the chosen method (zero, mean, or median). No external lookups or predictions are made — all analysis uses local analytical engines on the supplied data.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, document_group, date, checked_pages, flagged_pages) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Unrecognized imputation method or field enum value causes parameter error","Empty rows array (minItems:1 not met) causes rejection"],"whenToPreferThis":"Choose this endpoint when you need both duplicate key detection and missing-value imputation on publication proofing data (checked_pages, flagged_pages) in a single low-cost call. Ideal for small-to-medium editorial datasets (up to 200 rows) where no external lookups or ML predictions are needed — just fast, local data-quality auditing at $0.01 USDC for both reports.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:49:44.810Z","isFirstParty":false,"canonicalSlug":"publication-proofing-duplicate-key-report-explicit-missing-value-fill-4544b178"}