{"uid":"cap_ffEVqG0o8uRMPiPwUrpN0","slug":"data-reconciliation-exact-row-deduplication-iqr-outlier-flags-1b299ea7","name":"Data Reconciliation — Exact Row Deduplication + IQR Outlier Flags","description":"Data reconciliation — Exact row deduplication + IQR outlier flags: Exact row deduplication + IQR outlier flags for supplied data reconciliation records (source_total, target_total). 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-11-049?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_Oi1h0Z8xB1MNO5p51GFmA","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":"Deduplicates rows exactly and flags IQR-based outliers in source_total/target_total reconciliation data, returning 2 independent analytical reports for up to 200 rows.","exampleAgentPrompt":"I have a set of reconciliation records with source_total and target_total values across multiple dataset groups — can you run exact row deduplication and IQR outlier flagging on them and give me 2 analytical reports? Here are up to 200 rows across groups like 'group-a' and 'group-b' from October 2026.","exampleUseCases":[{"title":"Financial reconciliation anomaly detection","prompt":"I've got 150 rows of daily reconciliation data with source_total and target_total figures for two ledger groups from 2026-01-01 through 2026-05-31 — can you deduplicate the exact rows and flag any IQR outliers in the source_total field, and give me both reports?"},{"title":"ETL pipeline data quality check","prompt":"After running our ETL last night I have a dataset of 80 reconciliation records across three dataset groups with source and target totals — please remove any exact duplicate rows and identify which target_total values fall outside the IQR range so I can investigate before publishing."},{"title":"Month-end close duplicate and outlier audit","prompt":"For our month-end close review I need to check 200 reconciliation rows from November 2026 across our 'actuals' and 'budget' groups — run exact deduplication and IQR outlier detection on the source_total column and return both analytical reports."}],"resultDescription":"Two independent analytical reports: (1) a deduplication report identifying and removing exact duplicate rows from the submitted reconciliation records, and (2) an IQR outlier flagging report marking rows where source_total or target_total values fall outside the interquartile range, computed entirely from the supplied data with no external lookups.","failureModes":["Input exceeds 200 rows — request will be rejected or truncated","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Missing required fields (row_id, dataset_group, date, source_total, target_total) results in rejection","source_total or target_total values outside ±1,000,000,000,000 range rejected","Fewer than 1 row submitted — minimum not met","row_id or dataset_group strings exceeding 80 characters cause validation error","Payment of 0.01 USDC not completed — request not processed"],"whenToPreferThis":"Choose this endpoint when you have up to 200 reconciliation records with source_total and target_total fields and need both exact-match deduplication and IQR-based statistical outlier flagging in a single low-cost call. It is ideal for ETL validation, financial reconciliation audits, and data quality checks where you want deterministic, locally computed analytics without external data lookups or ML predictions. Prefer this over general-purpose data tools when you specifically need paired deduplication + IQR outlier reports on reconciliation-structured data for under $0.01.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:08.733Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-iqr-outlier-flags-1b299ea7"}