{"uid":"cap_fV-2BsE1vQAA2zIkNxwUG","slug":"data-reconciliation-exact-row-deduplication-base-100-series-b3e37fdf","name":"Data Reconciliation: Exact Row Deduplication + Base-100 Series","description":"Data reconciliation — Exact row deduplication + Base-100 series: Exact row deduplication + Base-100 series 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-047?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"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_Iq7r68t_-gNQw0_80AgAI","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 supplied reconciliation rows and generates a Base-100 indexed series for source_total or target_total fields, producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"Take these reconciliation rows for group-a and group-b across October 2026 — up to 4 rows with source_total and target_total values — deduplicate any exact duplicates and give me a Base-100 series indexed from the first row using source_total.","exampleUseCases":[{"title":"Monthly finance reconciliation deduplication","prompt":"I have 150 rows of monthly source and target financial totals by dataset group for 2025 — can you deduplicate any exact duplicate rows and produce a Base-100 series indexed from row 0 on source_total so I can see the normalized trend?"},{"title":"Detecting duplicate entries in ETL output","prompt":"Our ETL pipeline sometimes emits duplicate records — run exact row deduplication on these 80 reconciliation rows grouped by region and date, then give me a Base-100 index on target_total starting from row 0."},{"title":"Normalizing multi-group reconciliation data","prompt":"I've got reconciliation data across two dataset groups — 'sales' and 'returns' — for Q3 2024 with source and target totals. Deduplicate the rows and show me a Base-100 indexed series on source_total from the first entry so I can compare relative movement."}],"resultDescription":"Returns two analytical reports: (1) an exact-row-deduplicated version of the supplied reconciliation rows, identifying and removing duplicate entries; and (2) a Base-100 indexed series for the chosen field (source_total or target_total), rebased so the selected base_index row equals 100, allowing relative comparison across dates and groups. No external lookups or predictions are made.","failureModes":["More than 200 rows supplied — exceeds maxItems limit","Missing required fields (row_id, dataset_group, date, source_total, or target_total) — validation error","Date not in YYYY-MM-DD format — pattern mismatch error","base_index out of range (0–199) — validation error","All rows are duplicates leaving an empty dataset after deduplication","source_total or target_total out of allowed range (±1,000,000,000,000)"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a Base-100 normalized series in a single call for up to 200 reconciliation rows containing source and target totals. It is ideal for financial or ETL reconciliation workflows where you need to clean duplicate records and simultaneously produce a rebased index for trend comparison — all offline with no external data dependencies. Prefer alternatives if you need trailing means, IQR outlier detection, or missing-value fill instead of Base-100 indexing.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:52.575Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-base-100-series-b3e37fdf"}