{"uid":"cap_lNS_e8uKpg85p1vqdetv0","slug":"data-ingestion-batches-exact-row-deduplication-numeric-interval-filter-3e1c58e9","name":"Data Ingestion Batches — Exact Row Deduplication + Numeric Interval Filter","description":"Data ingestion batches — Exact row deduplication + Numeric interval filter: Exact row deduplication + Numeric interval filter for supplied data ingestion batches records (received_rows, accepted_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-01-043?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","received_rows","accepted_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"accepted_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"received_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","accepted_rows":1,"dataset_group":"group-a","received_rows":10},{"date":"2026-10-02","row_id":"row-2","accepted_rows":2,"dataset_group":"group-b","received_rows":20},{"date":"2026-10-03","row_id":"row-3","accepted_rows":3,"dataset_group":"group-a","received_rows":15},{"date":"2026-10-04","row_id":"row-4","accepted_rows":4,"dataset_group":"group-b","received_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["received_rows","accepted_rows"],"type":"string","default":"received_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_KiRVuXPuOTyRwKnS_AByH","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":"Deduplicates data ingestion batch records by exact row and filters them by a numeric interval on received_rows or accepted_rows, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Deduplicate my ingestion batch records and filter for rows where received_rows is between 5 and 100 — here's my data: row-1, group-a, 2026-10-01, received_rows=10, accepted_rows=1; row-2, group-b, 2026-10-02, received_rows=20, accepted_rows=2; row-1, group-a, 2026-10-01, received_rows=10, accepted_rows=1 (duplicate).","exampleUseCases":[{"title":"Cleaning duplicate pipeline ingestion logs","prompt":"I have 150 rows of daily ingestion batch logs and I need to remove exact duplicate entries, then filter down to only records where received_rows is between 0 and 50 — can you run both reports on this dataset?"},{"title":"QA check on accepted rows volume","prompt":"Run a deduplication pass and a numeric filter on my ingestion batch data — I want to see which records have accepted_rows between 100 and 10000, and I also need to know which rows were duplicates."},{"title":"Monitoring ingestion anomalies by dataset group","prompt":"Can you deduplicate these ingestion batch records for my group-a and group-b datasets and filter for any rows where received_rows falls outside the 10 to 500 range, so I can spot anomalies?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate rows from the supplied ingestion batch data, and (2) a numeric interval filter report listing rows where the selected field (received_rows or accepted_rows) falls within the specified minimum–maximum range. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected due to maxItems constraint","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) causes rejection","Minimum greater than maximum may produce empty filter results","Numeric values outside ±1,000,000,000,000 bounds cause validation error","Payment of 0.01 USDC not attached causes 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously deduplicate ingestion batch records by exact row equality AND filter those records by a numeric interval on received_rows or accepted_rows, all in a single $0.01 call returning two coordinated reports. Ideal for data engineering QA workflows, ETL pipeline auditing, and ingestion anomaly detection on batches up to 200 rows where no external data lookup or prediction is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:25.904Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-exact-row-deduplication-numeric-interval-filter-3e1c58e9"}