{"uid":"cap_RFiUzMD08Ly08gc0C-1xc","slug":"data-reconciliation-duplicate-key-report-date-by-category-pivot-86d5a551","name":"Data Reconciliation — Duplicate Key Report + Date by Category Pivot","description":"Data reconciliation — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot 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-068?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_YQzcaAy3K_8HcBny6g87d","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":"Generates two analytical reports from supplied reconciliation rows: a duplicate key report and a date-by-category pivot table comparing source and target totals.","exampleAgentPrompt":"Check my reconciliation records for duplicate row IDs and also generate a date-by-category pivot for source_total — here are the rows: row-1, 2026-10-01, group-a, source 10, target 1; row-2, 2026-10-02, group-b, source 20, target 2; row-3, 2026-10-01, group-a, source 15, target 3.","exampleUseCases":[{"title":"ETL pipeline duplicate key audit","prompt":"I've got up to 200 rows from my ETL reconciliation run with row IDs, dates, dataset groups, and source vs target totals — can you run a duplicate key check and also pivot the source_total values by date and category so I can spot any mismatches?"},{"title":"Finance team month-end reconciliation review","prompt":"Here's my month-end reconciliation dataset with 150 rows across several dataset groups — please give me a duplicate row-ID report and a pivot of target_total by date and group so I can send the summary to my finance lead."},{"title":"Data migration validation check","prompt":"We just migrated data between systems and I need to verify the records — can you detect any duplicate row IDs and show me a date-by-category breakdown of source_total for these 80 reconciliation rows?"}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying any repeated row_id values across the supplied rows, and (2) a date-by-category pivot table showing the selected field (source_total or target_total) aggregated by date and dataset_group, covering up to 200 input rows.","failureModes":["Missing required fields (row_id, date, dataset_group, source_total, target_total) causes validation error","More than 200 rows submitted exceeds the maxItems limit and will be rejected","Invalid date format (not YYYY-MM-DD) fails pattern validation","Numeric values outside ±1,000,000,000,000 range are rejected","Empty rows array (minItems: 1) returns an error","Invalid field enum value (not source_total or target_total) causes schema rejection"],"whenToPreferThis":"Choose this endpoint when you need two specific analytical outputs — a duplicate key report and a date-by-category pivot — from a batch of reconciliation records (up to 200 rows) without any external data lookups. It is ideal for ETL validation, data migration checks, and finance reconciliation workflows where you supply source and target totals and want offline, deterministic analysis at very low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:07.238Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-duplicate-key-report-date-by-category-pivot-86d5a551"}