{"uid":"cap_SlhnieyHQAmnfwoqqp_Ti","slug":"export-validation-duplicate-key-report-numeric-interval-filter-75082730","name":"Export Validation — Duplicate Key Report + Numeric Interval Filter","description":"Export validation — Duplicate key report + Numeric interval filter: Duplicate key report + Numeric interval filter for supplied export validation records (valid_rows, exported_rows). 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-14-059?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","valid_rows","exported_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"valid_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"exported_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","valid_rows":10,"dataset_group":"group-a","exported_rows":1},{"date":"2026-10-02","row_id":"row-2","valid_rows":20,"dataset_group":"group-b","exported_rows":2},{"date":"2026-10-03","row_id":"row-3","valid_rows":15,"dataset_group":"group-a","exported_rows":3},{"date":"2026-10-04","row_id":"row-4","valid_rows":30,"dataset_group":"group-b","exported_rows":4}],"maxItems":200,"minItems":1},"field":{"enum":["valid_rows","exported_rows"],"type":"string","default":"valid_rows"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_MQkHtJAJP1EsUyLTqbgIU","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":"Analyzes up to 200 export validation rows to produce two reports: a duplicate key detection report and a numeric interval filter for valid_rows or exported_rows fields.","exampleAgentPrompt":"Check my export validation records for duplicate row IDs and also filter rows where valid_rows is between 0 and 100 — here are my rows: row-1 for group-a on 2026-10-01 with valid_rows=10 and exported_rows=1, row-2 for group-b on 2026-10-02 with valid_rows=20 and exported_rows=2, and row-1 for group-a on 2026-10-03 with valid_rows=15 and exported_rows=3.","exampleUseCases":[{"title":"Audit pipeline export for duplicate IDs","prompt":"I have a batch of 50 export validation records from our nightly pipeline — can you run a duplicate key check on the row IDs and also tell me which rows have valid_rows between 5 and 500? The field to filter on is valid_rows, minimum 5, maximum 500."},{"title":"Validate dataset group export completeness","prompt":"Here are 120 export validation rows across two dataset groups. Flag any duplicate row_ids for me, and filter down to just the rows where exported_rows falls between 0 and 50 so I can see which ones barely exported anything."},{"title":"QA check before data warehouse load","prompt":"Before I load these export records into the warehouse, can you find any duplicate row IDs and filter out rows where valid_rows is outside the range 10 to 1000? I'll send you up to 200 rows — filter field is valid_rows, min 10, max 1000."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying rows sharing the same row_id, and (2) a numeric interval filter report listing rows where the chosen field (valid_rows or exported_rows) falls within the specified minimum–maximum range. No external lookups or predictions are made; all analysis is performed locally on the supplied data.","failureModes":["Input array has zero rows (minItems:1 not met) — request rejected","More than 200 rows submitted (maxItems:200 exceeded) — request rejected","Date field does not match YYYY-MM-DD pattern — validation error","row_id missing or empty — validation error","field value is not 'valid_rows' or 'exported_rows' — enum validation error","minimum or maximum values exceed ±1,000,000,000,000 — validation error","Payment of 0.01 USDC not included — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous data-quality checks on export validation records: duplicate key detection and numeric range filtering, and your dataset is 200 rows or fewer. It is ideal for pipeline QA steps where you want to catch duplicate identifiers and isolate rows within a valid numeric band in a single cheap call. Prefer alternatives if you need string normalization, row ordering, outlier flagging, or grouping operations not covered here.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:22.903Z","isFirstParty":false,"canonicalSlug":"export-validation-duplicate-key-report-numeric-interval-filter-75082730"}