{"uid":"cap_NDat56Jk6ce2m6QeIDx1k","slug":"data-reconciliation-analytics-record-quality-audit-string-7129d029","name":"Data Reconciliation Analytics — Record Quality Audit + String Normalisation + Equal-Width Histogram","description":"Data reconciliation — Record quality audit + String normalisation + Equal-width histogram: Record quality audit + String normalisation + Equal-width histogram 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-202?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"bins":{"type":"integer","default":5,"maximum":30,"minimum":1},"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_vAoUrOAUIuODUTICfrpn3","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 row data: a record quality audit, string normalisation, and an equal-width histogram — all in a single call for up to 200 rows.","exampleAgentPrompt":"Run a record quality audit, string normalisation, and an equal-width histogram with 10 bins on my reconciliation data — here are the rows: [{row_id: 'r1', dataset_group: 'finance', date: '2024-01-15', source_total: 5000, target_total: 4980}, {row_id: 'r2', dataset_group: 'finance', date: '2024-01-16', source_total: 6200, target_total: null}], and use source_total as the histogram field.","exampleUseCases":[{"title":"Pre-close data quality check","prompt":"I've got 150 reconciliation rows from our month-end close — can you run a quality audit, normalise the string fields, and give me a 5-bin histogram on source_total so I can see where the values cluster?"},{"title":"Detecting nulls before ETL pipeline","prompt":"Before I push these 80 rows through the ETL, run a record quality audit and string normalisation on them, and also give me a 10-bin histogram on target_total — I want to catch any nulls or formatting issues now."},{"title":"Comparing distribution of source vs target totals","prompt":"Here are 200 rows of reconciliation data across three dataset groups — run the quality audit and string normalisation, then generate a 15-bin equal-width histogram on source_total so I can see the value distribution."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging missing values, formatting errors, and anomalies per row; (2) a string normalisation report showing standardised text fields; and (3) an equal-width histogram report showing bin edges and counts for the chosen numeric field (source_total or target_total), across up to 200 input rows.","failureModes":["More than 200 rows submitted — request rejected, reduce input size","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error returned","Invalid date format (not YYYY-MM-DD) — schema validation failure","Bins value outside 1–30 range — rejected with schema error","All values null for histogram field — histogram report may be empty or degenerate","Malformed JSON body — HTTP 400 error"],"whenToPreferThis":"Choose this endpoint when you need a bundled, low-cost ($0.01 USDC) set of three data profiling reports — quality audit, string normalisation, and histogram — on reconciliation row data in a single call. Ideal for pre-ETL validation, month-end close checks, or any pipeline where source and target totals need to be profiled without external lookups or predictions. Prefer over individual analytics endpoints when all three report types are needed simultaneously for the same dataset.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:52.275Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-analytics-record-quality-audit-string-7129d029"}