{"uid":"cap_tpaZN-GnXm8N5XZEuNKkG","slug":"record-routing-quality-audit-string-normalisation-duplicate-key-report-c51cfeb1","name":"Record Routing Quality Audit, String Normalisation & Duplicate Key Report","description":"Record routing — Record quality audit + String normalisation + Duplicate key report: Record quality audit + String normalisation + Duplicate key report for supplied record routing records (accepted_records, rejected_records). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-19-192?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","accepted_records","rejected_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"accepted_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rejected_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","accepted_records":10,"rejected_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","accepted_records":20,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":15,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":30,"rejected_records":4}],"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_LeexfVFyj3OMLv2oCwsqM","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":"Runs three local analytical reports (quality audit, string normalisation, and duplicate key detection) on up to 200 record routing rows containing accepted and rejected record counts.","exampleAgentPrompt":"Can you run a quality audit, string normalisation, and duplicate key check on my record routing data — I have about 50 rows with accepted_records and rejected_records counts across several dataset groups from October 2026?","exampleUseCases":[{"title":"ETL pipeline data quality check","prompt":"I just ran my nightly ETL job and I want to audit the quality of the record routing output — can you check these 120 rows for quality issues, normalise any inconsistent group name strings, and flag any duplicate row IDs? The rows cover accepted and rejected record counts from 2026-11-01 through 2026-11-30."},{"title":"Duplicate key detection across dataset groups","prompt":"I suspect some of my routing records have duplicate row IDs across group-a and group-b datasets — can you run a duplicate key report on these 80 routing rows dated between 2026-09-01 and 2026-09-30 and let me know which ones are repeated?"},{"title":"String normalisation before data merge","prompt":"Before I merge my record routing tables, I need the string values in the dataset_group field normalised for consistency — can you run the string normalisation report on these 60 rows of accepted and rejected record data so everything is standardised?"}],"resultDescription":"Three independent reports delivered for the submitted batch of up to 200 record routing rows: (1) a record quality audit flagging anomalies or data issues in the accepted_records and rejected_records fields, (2) a string normalisation report cleaning and standardising text fields such as dataset_group, and (3) a duplicate key report identifying any repeated row_id or dataset group combinations. All analysis is performed locally with no external lookups.","failureModes":["Batch exceeds 200 rows — request will be rejected","Missing required fields (row_id, date, accepted_records, rejected_records) cause row-level validation errors","Invalid date format (not YYYY-MM-DD) causes parsing failure","accepted_records or rejected_records values outside the allowed numeric range cause rejection","Empty rows array returns an error"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously run quality auditing, string normalisation, and duplicate key detection on record routing data (accepted/rejected record counts by dataset group and date) in a single cheap call. It is ideal for post-ETL validation pipelines, pre-merge data hygiene checks, or routine data quality monitoring on routing datasets of up to 200 rows. All processing is local and offline — do not use it when you need live external lookups, ML-based predictions, or professional data assessments.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:41.813Z","isFirstParty":false,"canonicalSlug":"record-routing-quality-audit-string-normalisation-duplicate-key-report-c51cfeb1"}