{"uid":"cap_5owXp188ZlK2XhlTyiBT8","slug":"data-ingestion-batches-exact-row-deduplication-adjacent-row-changes-9e6d80ea","name":"Data Ingestion Batches — Exact Row Deduplication + Adjacent Row Changes","description":"Data ingestion batches — Exact row deduplication + Adjacent row changes: Exact row deduplication + Adjacent row changes 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-046?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"}}},"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_np4sTIMIGQ-4lLWBY5fpK","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 data ingestion batch records to produce two reports: exact row deduplication and adjacent row change detection across received_rows and accepted_rows fields.","exampleAgentPrompt":"I have a batch of data ingestion records with received_rows and accepted_rows — can you run exact row deduplication and adjacent row change detection on them? Here are 4 rows: 2026-10-01 row-1 group-a received=10 accepted=1, 2026-10-02 row-2 group-b received=20 accepted=2, 2026-10-03 row-3 group-a received=15 accepted=3, 2026-10-04 row-4 group-b received=30 accepted=4. Use received_rows as the analysis field.","exampleUseCases":[{"title":"Deduplicate ETL pipeline ingestion logs","prompt":"I have 50 ingestion batch records from our ETL pipeline and I suspect some rows are exact duplicates. Can you run deduplication and adjacent row change detection on them using the accepted_rows field? I'll send you the rows with their dataset_group, date, received_rows, and accepted_rows values."},{"title":"Audit sequential changes in accepted rows","prompt":"Here's a week's worth of ingestion batch data across two dataset groups — can you check for exact duplicate entries and flag where adjacent rows show changes in received_rows? The dataset has about 120 rows with row IDs, dates, and row counts."},{"title":"Data quality check before warehouse load","prompt":"Before I load this batch into the warehouse, I want to run a quick data quality check — can you identify any exact duplicate rows and detect adjacent row changes in the accepted_rows field across these 80 ingestion records organized by dataset_group and date?"}],"resultDescription":"Returns two independent analytical reports for the submitted batch: (1) an exact row deduplication report identifying which rows are identical across all fields, and (2) an adjacent row changes report flagging where consecutive rows differ in the selected field (received_rows or accepted_rows). Up to 200 rows are supported per call; no external lookups or predictions are made.","failureModes":["Batch exceeds 200 rows — request will be rejected; split into smaller batches","Missing required fields (row_id, dataset_group, date, received_rows, or accepted_rows) cause validation errors","Invalid date format (must be YYYY-MM-DD) triggers schema rejection","Numeric values outside ±1,000,000,000,000 range are rejected","Empty rows array (minItems: 1 not met) returns an error","Invalid field enum value (must be 'received_rows' or 'accepted_rows') causes failure"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local analytical reports on data ingestion batch records specifically tracking received_rows and accepted_rows — without any external API calls, live lookups, or ML predictions. It is cost-effective at $0.01 USDC for two simultaneous reports on up to 200 rows, making it ideal for quick data quality checks within ETL or data pipeline workflows where deduplication and sequential change detection are needed together.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:44.546Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-exact-row-deduplication-adjacent-row-changes-9e6d80ea"}