{"uid":"cap_5NDlPu8iAxndk1SXQ-RXg","slug":"record-routing-analytics-string-normalisation-keyed-dataset-comparison-49863c90","name":"Record Routing Analytics — String Normalisation + Keyed Dataset Comparison","description":"Record routing — String normalisation + Keyed dataset comparison: String normalisation + Keyed dataset comparison for supplied record routing records (accepted_records, rejected_records). 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-19-036?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},"other":{"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":21,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":17,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":33,"rejected_records":4}],"maxItems":200,"minItems":0}}},"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_gUEJ48SFSCvQbke_42KLA","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 string normalisation and keyed dataset comparison on two supplied record routing datasets (accepted_records, rejected_records) and returns 2 independent analytical reports for up to 200 rows each.","exampleAgentPrompt":"Can you run a string normalisation and keyed dataset comparison on my two record routing datasets — the primary has rows for group-a and group-b from 2026-10-01 to 2026-10-04 with accepted and rejected record counts, and the secondary has the same keys but slightly different accepted/rejected values? I need both reports.","exampleUseCases":[{"title":"ETL pipeline discrepancy audit","prompt":"I have two snapshots of my routing pipeline data for October — both have the same row IDs and dataset groups, but the accepted_records and rejected_records counts differ slightly between them. Can you run a keyed comparison and string normalisation on both datasets so I can see exactly where they diverge?"},{"title":"Daily routing acceptance rate review","prompt":"Here are my record routing logs for group-a and group-b across the past week, split into a primary and a secondary dataset — can you normalise the strings and compare the two datasets by key so I get a report on accepted vs rejected record differences per group?"},{"title":"Data quality check before pipeline merge","prompt":"Before I merge these two routing datasets, I need a normalisation pass and a keyed comparison on both — they each have up to 150 rows with accepted_records and rejected_records fields by date and dataset_group. Can you run both analytical reports and flag any mismatches?"}],"resultDescription":"Returns 2 independent analytical reports: (1) a string normalisation report covering the supplied routing record fields, and (2) a keyed dataset comparison report contrasting the primary and secondary datasets row by row, grouped by dataset_group and date, for up to 200 rows per dataset. No live lookups or external data are involved — all analysis is performed locally on the supplied data.","failureModes":["Exceeding 200 rows per dataset causes rejection","Missing required fields (row_id, dataset_group, date, accepted_records, rejected_records) causes validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array (minItems:1 not met) causes error","Malformed JSON payload returns error"],"whenToPreferThis":"Choose this endpoint when you have two structured record routing datasets with accepted/rejected record counts keyed by row_id, dataset_group, and date, and you need both string normalisation and a keyed comparison report in a single call for up to 200 rows. It is ideal for ETL audits, pipeline reconciliation, and data quality checks where no external lookups or live data are needed and the analysis is purely on supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:31.830Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-string-normalisation-keyed-dataset-comparison-49863c90"}