{"uid":"cap_0PACYgQleDRNvq6_lL3Di","slug":"numeric-precision-comparisons-duplicate-key-report-grouped-numeric-216c5f8e","name":"Numeric Precision Comparisons — Duplicate Key Report + Grouped Numeric Summary","description":"Numeric precision comparisons — Duplicate key report + Grouped numeric summary: Duplicate key report + Grouped numeric summary for supplied numeric precision comparisons records (source_value, transformed_value). 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-20-056?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_value","transformed_value"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"transformed_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_value":10,"dataset_group":"group-a","transformed_value":1},{"date":"2026-10-02","row_id":"row-2","source_value":20,"dataset_group":"group-b","transformed_value":2},{"date":"2026-10-03","row_id":"row-3","source_value":15,"dataset_group":"group-a","transformed_value":3},{"date":"2026-10-04","row_id":"row-4","source_value":30,"dataset_group":"group-b","transformed_value":4}],"maxItems":200,"minItems":1},"field":{"enum":["source_value","transformed_value"],"type":"string","default":"source_value"}}},"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_8df39VTC5u_4VJQfy_CG9","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 local analytical reports on supplied numeric precision comparison rows: a duplicate key report and a grouped numeric summary, for up to 200 rows.","exampleAgentPrompt":"Run a duplicate key report and grouped numeric summary on these rows: row-1 (group-a, 2026-10-01, source=10, transformed=1), row-2 (group-b, 2026-10-02, source=20, transformed=2), row-3 (group-a, 2026-10-03, source=15, transformed=3) — use source_value as the target field.","exampleUseCases":[{"title":"ETL pipeline duplicate audit","prompt":"I have 150 rows from my ETL job with row IDs, dataset groups, dates, source values, and transformed values — can you run a duplicate key check and a grouped numeric summary on them using the source_value field?"},{"title":"Data transformation QA review","prompt":"After my data transformation run, I need to check for any duplicate row IDs and get a grouped summary of the transformed_value field across my three dataset groups — here are the 80 rows with their source and transformed numbers."},{"title":"Numeric precision batch analysis","prompt":"Can you analyze these 50 numeric precision comparison records grouped by dataset_group? I want to know if any row IDs are duplicated and get a summary of the source_value figures by group."}],"resultDescription":"Two independent analytical reports: (1) a duplicate key report identifying any row_id values that appear more than once in the supplied data, and (2) a grouped numeric summary aggregating the selected numeric field (source_value or transformed_value) broken down by dataset_group — all computed locally with no external lookups.","failureModes":["Empty or malformed rows array returns a validation error","Row count exceeding 200 items is rejected","Invalid date format (non YYYY-MM-DD) causes schema rejection","Numeric values outside ±1,000,000,000,000 are rejected","Missing required fields (row_id, dataset_group, date) cause item-level errors","Invalid field enum value (not source_value or transformed_value) returns an error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of numeric precision comparison data (source vs transformed values) and need both a duplicate key audit and a grouped numeric summary in a single call, without requiring any external data sources, predictions, or live lookups. It is ideal for data quality checks in ETL pipelines, transformation validation workflows, or batch audits of numeric datasets grouped by category.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:15.324Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-duplicate-key-report-grouped-numeric-216c5f8e"}