{"uid":"cap_GL8ibMdGd4PsuzcAk-tOd","slug":"duplicate-observations-record-quality-audit-and-string-normalisation-dc956e37","name":"Duplicate Observations Record Quality Audit and String Normalisation","description":"Duplicate observations — Record quality audit + String normalisation: Record quality audit + String normalisation for supplied duplicate observations records (duplicate_rows, total_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-04-001?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":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_vS3zVLOy-aOcoNNOvWCG_","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 and normalises up to 200 rows of duplicate-observation records, producing a record quality report and a string normalisation report using local analytical engines.","exampleAgentPrompt":"Can you run a record quality audit and string normalisation check on these 4 rows of duplicate observation data — row-1 for group-a on 2026-10-01 with 10 duplicate_rows out of 1 total, row-2 for group-b on 2026-10-02 with 20 duplicate_rows out of 2 total, row-3 for group-a on 2026-10-03 with 15 duplicate_rows out of 3 total, and row-4 for group-b on 2026-10-04 with 30 duplicate_rows out of 4 total?","exampleUseCases":[{"title":"Monthly deduplication pipeline audit","prompt":"I have a batch of 50 rows from our monthly ETL run showing duplicate_rows and total_rows per dataset_group and date — can you run a record quality audit and string normalisation check on all of them so I can see where our deduplication is failing?"},{"title":"Dataset group label normalisation check","prompt":"Our dataset_group labels have inconsistent capitalisation and spacing across these 80 duplicate observation records — can you run a string normalisation report on them alongside a full record quality audit?"},{"title":"Data quality gate before warehouse load","prompt":"Before we load these 120 rows of duplicate observation counts into the warehouse, can you do a record quality audit and string normalisation pass on the duplicate_rows and total_rows fields to catch any anomalies or formatting issues?"}],"resultDescription":"Returns two independent reports: (1) a record quality audit assessing the integrity, completeness, and plausibility of the supplied duplicate_rows and total_rows figures across all input rows; (2) a string normalisation report identifying and correcting inconsistencies in text fields such as dataset_group and date. All analysis is performed locally with no external lookups or live data access.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","duplicate_rows or total_rows outside numeric bounds — rejection","Empty rows array (minItems:1 not met) — error returned","Payment of 0.01 USDC not completed — 402 response blocking execution"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of pre-collected duplicate observation records (duplicate_rows, total_rows, dataset_group, date) and need both a structured record quality audit and a string normalisation report in a single low-cost call. It is ideal for automated data pipeline checkpoints, pre-load validation steps, or periodic data quality reviews where no live external lookups, predictions, or professional assessments are required. Prefer alternatives if you need null coverage analysis, trend analysis, or correlation reports — those are covered by sibling endpoints on the same platform.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:17.999Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-record-quality-audit-and-string-normalisation-dc956e37"}