{"uid":"cap_0GPnRsuqp19yJ5AEqtj41","slug":"data-reconciliation-date-by-category-pivot-keyed-dataset-comparison-f3ed24bc","name":"Data Reconciliation — Date-by-Category Pivot + Keyed Dataset Comparison","description":"Data reconciliation — Date by category pivot + Keyed dataset comparison: Date by category pivot + Keyed dataset comparison 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-188?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"},"other":{"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":21,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":17,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":33,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":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_cffdgO0zHid7wXhR5mEa3","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 two analytical reports on reconciliation data: a date-by-category pivot table and a row-keyed comparison between two datasets (source_total vs target_total), up to 200 rows each.","exampleAgentPrompt":"I have two datasets of up to 200 reconciliation rows, each with a row_id, date, dataset_group, source_total, and target_total — can you pivot them by date and category, and also run a keyed comparison between the two datasets to show where source_total differs from target_total?","exampleUseCases":[{"title":"Monthly finance reconciliation audit","prompt":"I've got two sets of transaction records for October 2026, each with row IDs, dates, category groups, and source vs target totals — run a date-by-category pivot and a row-keyed comparison so I can see exactly where the numbers diverge."},{"title":"ETL pipeline data quality check","prompt":"After running our ETL pipeline I have a source dataset and a target dataset, both with up to 150 rows tagged by group and date — can you compare them row by row and also pivot the source_total by date and dataset_group so I can spot any load errors?"},{"title":"Cross-system ledger reconciliation","prompt":"We pull ledger totals from two different systems every day — here are both datasets with row IDs and group labels. Please pivot the figures by date and category, and compare the two datasets keyed by row_id to flag any mismatches in the target_total field."}],"resultDescription":"Returns two independent analytical reports: (1) a date-by-category pivot table aggregating the selected field (source_total or target_total) across dataset_group and date dimensions, and (2) a keyed row-by-row comparison between the primary dataset (rows) and the secondary dataset (other), highlighting differences and variances between source_total and target_total values. Both reports are computed locally with no external data lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required row fields (row_id, date, dataset_group, source_total, target_total) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","source_total or target_total outside allowed range (-1T to +1T) — validation error","Empty rows array (minItems: 1 not met) — rejection","Mismatched row_ids between rows and other arrays may result in unmatched comparison entries"],"whenToPreferThis":"Choose this endpoint when you need both a pivot-table summary by date and category AND a row-keyed side-by-side comparison of two reconciliation datasets in a single API call. It is ideal for financial reconciliation, ETL validation, and audit workflows where source and target totals must be compared across up to 200 rows. Prefer this over single-report endpoints when you need both analytical views at a bundled $0.01 price point with no external dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:26.949Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-date-by-category-pivot-keyed-dataset-comparison-f3ed24bc"}