{"uid":"cap_G78RWA0-7jjpo_x5eHxR9","slug":"data-reconciliation-analytics-record-quality-audit-exact-row-38c6935d","name":"Data Reconciliation Analytics: Record Quality Audit + Exact Row Deduplication + Category Frequencies","description":"Data reconciliation — Record quality audit + Exact row deduplication + Category frequencies: Record quality audit + Exact row deduplication + Category frequencies 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-212?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}}},"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_voKbUKkocPs7O9G2JbHuF","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: a record quality audit, exact row deduplication, and category frequency analysis — all in a single call for up to 200 rows.","exampleAgentPrompt":"Can you audit the quality of my reconciliation records, deduplicate any exact duplicate rows, and give me category frequencies — I have up to 50 rows with row IDs, dates, dataset groups, and source/target totals I'll pass in?","exampleUseCases":[{"title":"ETL pipeline reconciliation audit","prompt":"I've got 80 reconciliation rows from my ETL pipeline with source and target totals for each day across two dataset groups — can you run a quality audit, flag any exact duplicate rows, and show me how many records fall into each category?"},{"title":"Finance month-end data cleanup","prompt":"Before I close out the month, can you check these 120 reconciliation records for quality issues, remove any exact duplicates, and give me a frequency count by dataset group so I know how balanced my data is?"},{"title":"Data migration validation check","prompt":"I just migrated records from our old system and have 60 rows with row IDs, dates, group labels, and source vs target totals — please audit record quality, deduplicate exact matches, and tell me how often each dataset group appears."}],"resultDescription":"Three independent analytical reports: (1) a record quality audit flagging missing, null, or malformed fields across the supplied rows; (2) exact row deduplication results identifying and removing fully identical rows; and (3) a category frequency table showing how often each dataset_group value appears across the dataset. All reports are computed locally on the supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) causes row-level rejection","Malformed date strings not matching YYYY-MM-DD pattern are flagged or rejected","source_total or target_total values outside the allowed range (-1e12 to 1e12) fail schema validation","Empty rows array returns an error","Additional properties in row objects are rejected due to additionalProperties:false"],"whenToPreferThis":"Choose this endpoint when you need three analytical operations — quality audit, deduplication, and category frequency analysis — on a single batch of reconciliation data (up to 200 rows) without making three separate API calls. It is ideal when your workflow involves ETL validation, finance reconciliation, or data migration checks where you want to assess data health, remove duplicates, and understand category distributions in one pass. It does not perform live data lookups, ML predictions, or external integrations.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:41.139Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-analytics-record-quality-audit-exact-row-38c6935d"}