{"uid":"cap_lO5BV9stiBoPZUm17xT9L","slug":"numeric-precision-comparisons-record-quality-audit-exact-row-4406f9fa","name":"Numeric Precision Comparisons — Record Quality Audit & Exact Row Deduplication","description":"Numeric precision comparisons — Record quality audit + Exact row deduplication: Record quality audit + Exact row deduplication 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-002?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}}},"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_4bMaOj0uYMTO-_IdsZEBX","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":"Audits data quality and deduplicates rows for up to 200 numeric source/transformed value pairs, returning two independent analytical reports offline.","exampleAgentPrompt":"I have a batch of up to 200 rows from our ETL pipeline with row IDs, dataset groups, dates, source values, and transformed values — can you run a record quality audit and exact row deduplication check on them and give me both reports?","exampleUseCases":[{"title":"ETL transformation validation audit","prompt":"I just ran a numeric transformation on our sales dataset and need to verify data quality — here are 150 rows with row IDs, dataset group 'sales-q4', dates from 2024-01-01 to 2024-03-31, and both source and transformed values. Can you audit the record quality and flag any exact duplicate rows?"},{"title":"Deduplication check on financial records","prompt":"We imported 80 transaction records with source amounts and post-processing transformed amounts across two groups, 'accounts-payable' and 'accounts-receivable', for dates in October 2025. Can you check for exact duplicate rows and give me a data quality report on all of them?"},{"title":"Data pipeline QA before warehouse load","prompt":"Before we load this batch into the warehouse, can you run a quality audit and deduplication pass on these 60 rows from our 'pricing-engine' dataset group? Each row has a date, a source price, and a transformed price after normalization — I need both the quality and dedup reports."}],"resultDescription":"Two independent reports: (1) a record quality audit flagging issues such as null values, out-of-range numbers, or precision anomalies in source_value and transformed_value columns; and (2) an exact row deduplication report identifying which rows are exact duplicates based on all supplied fields. Both reports cover up to 200 rows and are generated locally without external lookups.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, date, source_value, transformed_value, dataset_group) — validation error","Date fields not matching YYYY-MM-DD pattern — schema validation failure","Numeric values outside ±1,000,000,000,000 range — schema rejection","Empty rows array — minItems constraint violation","Payment of 0.01 USDC not completed — 402 response blocking access"],"whenToPreferThis":"Choose this endpoint when you need both a data quality audit and exact row deduplication in a single call on a batch of up to 200 rows with numeric source and transformed values. Ideal for ETL pipeline validation, pre-load QA checks, or verifying numeric precision after transformation steps. Best when you have structured row data with identifiable groups and dates and need two independent offline reports without any external API calls or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:06.758Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-record-quality-audit-exact-row-4406f9fa"}