{"uid":"cap_nhXjCjqKsmlz19sG-N-vk","slug":"aggregation-checks-record-quality-audit-exact-row-deduplication-daily-1f272a04","name":"Aggregation Checks — Record Quality Audit + Exact Row Deduplication + Daily Sum Series","description":"Aggregation checks — Record quality audit + Exact row deduplication + Daily sum series: Record quality audit + Exact row deduplication + Daily sum series for supplied aggregation checks records (source_sum, aggregate_sum). 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-17-215?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_sum","aggregate_sum"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_sum":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"aggregate_sum":{"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_sum":10,"aggregate_sum":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_sum":20,"aggregate_sum":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_sum":15,"aggregate_sum":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_sum":30,"aggregate_sum":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_sum","aggregate_sum"],"type":"string","default":"source_sum"}}},"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_NBfwxi-YQLVDSxYvohuIN","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 analytical reports on aggregation check records: a record quality audit, exact row deduplication, and a daily sum series — all computed locally against user-supplied data for up to 200 rows.","exampleAgentPrompt":"Can you run a record quality audit, exact row deduplication, and daily sum series on my aggregation check data? I have rows with row_id, dataset_group, date, source_sum, and aggregate_sum — here are up to 200 records, and I want to analyze the source_sum field.","exampleUseCases":[{"title":"ETL pipeline aggregation validation","prompt":"I just ran my nightly ETL job and I need to check if the aggregation output looks clean — can you audit the record quality, find any exact duplicate rows, and give me the daily sum series for source_sum across these 200 rows of aggregation check data?"},{"title":"Daily rollup data deduplication","prompt":"My data team suspects there are duplicate entries in our daily rollup table. Can you run an exact row deduplication report on these records? They have row_id, dataset_group, date, source_sum, and aggregate_sum fields."},{"title":"Source vs aggregate discrepancy investigation","prompt":"I want to see if my source sums and aggregate sums are tracking correctly over time. Can you run the daily sum series report on these aggregation check records using the aggregate_sum field — I have about 150 rows across several dataset groups?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging data issues, (2) an exact row deduplication report identifying duplicate records, and (3) a daily sum series summarizing the selected numeric field (source_sum or aggregate_sum) by date — all computed locally against the supplied rows with no external calls.","failureModes":["Fewer than 1 or more than 200 rows submitted — request rejected","Missing required fields (row_id, dataset_group, date, source_sum, aggregate_sum) — validation error","Date values not matching YYYY-MM-DD pattern — schema validation failure","Numeric values outside allowed range (-1T to 1T) — rejected","Invalid field enum value (not source_sum or aggregate_sum) — schema error"],"whenToPreferThis":"Choose this endpoint when you need to run all three of these analytical operations — quality audit, exact deduplication, and daily sum series — together on aggregation check data with source_sum and aggregate_sum columns, in a single low-cost call. Ideal for ETL validation pipelines, data reconciliation workflows, or any scenario where you want to batch three standard data quality checks on up to 200 rows for $0.01 USDC without making external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:53:33.372Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-record-quality-audit-exact-row-deduplication-daily-1f272a04"}