{"uid":"cap_3mA9hBKR3aIRkqxTcdAVb","slug":"data-reconciliation-analytics-record-quality-audit-string-83807227","name":"Data Reconciliation Analytics: Record Quality Audit + String Normalisation + Numeric Row Ordering","description":"Data reconciliation — Record quality audit + String normalisation + Numeric row ordering: Record quality audit + String normalisation + Numeric row ordering 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-196?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_jj61UleDFzPMmHrZfV4vO","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 reconciliation data (up to 200 rows): record quality audit, string normalisation, and numeric row ordering — no external lookups or predictions.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and numeric row ordering on these reconciliation rows? I have 4 rows with row IDs row-1 through row-4, dates from 2026-10-01 to 2026-10-04, dataset groups group-a and group-b, source_totals of 10, 20, 15, and 30, target_totals of 1, 2, 3, and 4, and I want the numeric ordering done on source_total.","exampleUseCases":[{"title":"Monthly finance reconciliation quality check","prompt":"I have 150 rows of monthly finance reconciliation data with source and target totals — can you run a record quality audit, string normalisation, and numeric ordering by source_total on all of them so I can spot data issues before the month-end close?"},{"title":"ETL pipeline output validation","prompt":"After our ETL pipeline ran last night, I need to audit the record quality, normalise the dataset_group strings, and sort by target_total for the 80 reconciliation rows it produced — can you run all three reports?"},{"title":"Reconciliation discrepancy investigation","prompt":"We suspect some of our reconciliation rows have bad string formatting and inconsistent numeric values — can you run a quality audit, string normalisation, and numeric row ordering on source_total for these 30 rows from dataset groups 'Alpha', 'alpha', and 'ALPHA' so we can confirm?"}],"resultDescription":"Three independent analytical reports delivered together: (1) a record quality audit flagging completeness, nulls, and formatting issues; (2) a string normalisation report standardising text fields like dataset_group; (3) a numeric row ordering report ranking rows by the selected field (source_total or target_total). All computed locally using shared analytical engines — no external data is fetched.","failureModes":["Exceeds 200-row limit — request rejected with validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) — schema validation failure","Date field does not match YYYY-MM-DD pattern — rejected with pattern mismatch error","Numeric values outside ±1,000,000,000,000 range — schema validation failure","Empty rows array (minItems: 1 not met) — validation error","Invalid field enum value (must be source_total or target_total) — schema rejection","Payment failure — x402 payment not processed, request blocked"],"whenToPreferThis":"Choose this endpoint when you need three reconciliation-specific reports in a single call at minimal cost ($0.01 USDC for all three) — specifically the combination of record quality audit, string normalisation, and numeric row ordering. Prefer this over single-report sibling endpoints when you need all three outputs simultaneously on the same dataset without making separate API calls. Best suited for datasets up to 200 rows where offline, local computation is sufficient and no live lookups or external enrichment are needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:00.550Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-analytics-record-quality-audit-string-83807227"}