{"uid":"cap_u_cr_ACk8nkmKS60TMq91","slug":"data-reconciliation-analytics-record-quality-audit-string-7ab56809","name":"Data Reconciliation Analytics: Record Quality Audit + String Normalisation + Grouped Numeric Summary","description":"Data reconciliation — Record quality audit + String normalisation + Grouped numeric summary: Record quality audit + String normalisation + Grouped numeric summary for supplied data reconciliation records (source_total, target_total). 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-11-194?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"}}},"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_DJ3fE9wdzUbqOF7Fedp9O","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 on up to 200 data reconciliation rows: a record quality audit, string normalisation, and a grouped numeric summary of source/target totals.","exampleAgentPrompt":"Can you run a full reconciliation analysis on these rows — I need a record quality audit, string normalisation on the group labels, and a grouped numeric summary of source_total across dataset groups? Here are up to 200 rows with row_id, date (YYYY-MM-DD), dataset_group, source_total, and target_total.","exampleUseCases":[{"title":"Finance team reconciliation data audit","prompt":"I have 150 rows of month-end reconciliation data with source_total and target_total figures — can you audit the record quality, normalise the dataset_group strings, and give me a grouped numeric summary of source_total broken down by group?"},{"title":"Data pipeline output validation","prompt":"We just ran an ETL pipeline and I need to check the output quality — please audit these reconciliation records for missing or invalid fields, normalise the group name strings, and summarise source_total and target_total by dataset_group."},{"title":"Identifying anomalies in intercompany data","prompt":"Here are 80 rows of intercompany reconciliation records. Can you run the three-report analysis — quality audit, string normalisation, and grouped numeric summary on target_total — so I can spot any data issues before we close the books?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging null values, format violations, and completeness issues per row; (2) a string normalisation report cleaning and standardising the dataset_group and other string fields; and (3) a grouped numeric summary aggregating source_total or target_total values by dataset_group, with counts and statistics. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["Rows array empty or missing — returns validation error","More than 200 rows submitted — rejected with max items error","date field does not match YYYY-MM-DD pattern — schema validation failure","row_id exceeds 80 characters or is empty — rejected","source_total or target_total outside ±1,000,000,000,000 range — rejected","Invalid field enum value (not 'source_total' or 'target_total') — rejected"],"whenToPreferThis":"Choose this endpoint when you need three combined analytical reports on a reconciliation dataset in a single API call without any external data lookups: specifically a quality audit, string normalisation, and grouped numeric summary. It is ideal for finance, data engineering, or ETL validation workflows where you want offline, deterministic analysis of up to 200 rows of source/target reconciliation data at very low cost ($0.01 USDC for all three reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:29.953Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-analytics-record-quality-audit-string-7ab56809"}