{"uid":"cap_Akj9UT7LnwzLu1EU1hK5g","slug":"newsletter-preparation-record-quality-audit-exact-row-deduplication-c6f44dc0","name":"Newsletter Preparation — Record Quality Audit + Exact Row Deduplication","description":"Newsletter preparation — Record quality audit + Exact row deduplication: Record quality audit + Exact row deduplication for supplied newsletter preparation records (completed_items, planned_items). 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-23-002?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","completed_items","planned_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"planned_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"document_group":{"type":"string","default":"","maxLength":80},"completed_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","planned_items":1,"document_group":"group-a","completed_items":10},{"date":"2026-10-02","row_id":"row-2","planned_items":2,"document_group":"group-b","completed_items":20},{"date":"2026-10-03","row_id":"row-3","planned_items":3,"document_group":"group-a","completed_items":15},{"date":"2026-10-04","row_id":"row-4","planned_items":4,"document_group":"group-b","completed_items":30}],"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_VyaQJ2ARhGGnAR0z9QCHS","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":"Audits data quality and removes exact duplicate rows from newsletter preparation records (completed_items and planned_items) in a single call, returning two independent analytical reports.","exampleAgentPrompt":"Can you run a record quality audit and exact row deduplication on these newsletter preparation records — I have about 40 rows with row_id, document_group, date, completed_items, and planned_items — and give me both reports?","exampleUseCases":[{"title":"Pre-publish newsletter data cleanup","prompt":"Before I send out the weekly newsletter, run a quality audit and deduplication check on my 80 newsletter preparation rows — each has a row_id, document_group, date, completed_items count, and planned_items count — and flag any bad or duplicate records."},{"title":"Editorial team duplicate detection","prompt":"Our editorial tracker has about 120 rows of completed and planned newsletter items across multiple document groups. Can you deduplicate them exactly and also give me a quality audit report so I know which records have issues?"},{"title":"Monthly newsletter dataset validation","prompt":"I've got 150 rows of newsletter preparation data covering October 2026, each with a row_id, group label, date, and numbers for completed and planned items. Please run both the record quality audit and exact row deduplication on all of them."}],"resultDescription":"Two independent analytical reports: (1) a record quality audit identifying data quality issues across the supplied rows, and (2) an exact row deduplication report listing which rows are exact duplicates. Both reports are generated locally from the supplied data with no external lookups. Up to 200 rows processed per call.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Rows missing required fields (row_id, document_group, date, completed_items, planned_items) — validation error","Date fields not matching YYYY-MM-DD pattern — schema validation failure","completed_items or planned_items values outside allowed numeric range — rejection","Empty rows array submitted — error response"],"whenToPreferThis":"Choose this endpoint when you need both a data quality audit and exact deduplication for newsletter preparation data in a single low-cost call. It is ideal for pre-publication data hygiene checks on completed/planned newsletter item records of up to 200 rows. Prefer this over generic deduplication tools when your data specifically has the newsletter preparation schema (row_id, document_group, date, completed_items, planned_items) and you want two bundled reports for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:50:36.034Z","isFirstParty":false,"canonicalSlug":"newsletter-preparation-record-quality-audit-exact-row-deduplication-c6f44dc0"}