{"uid":"cap_2uHc8e_EDAMLaNSc3j0V-","slug":"data-ingestion-batches-exact-row-deduplication-two-measure-correlation-fed189f0","name":"Data Ingestion Batches — Exact Row Deduplication + Two-Measure Correlation","description":"Data ingestion batches — Exact row deduplication + Two-measure correlation: Exact row deduplication + Two-measure correlation 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-050?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}}},"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_0sGae3aZCNHn6oB8isBF_","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 rows and computes correlation between received_rows and accepted_rows for up to 200 data ingestion batch records.","exampleAgentPrompt":"Can you deduplicate these ingestion batch records and tell me how correlated the received_rows and accepted_rows are? I have 4 rows: row-1 on 2026-10-01 for group-a with 10 received and 1 accepted, row-2 on 2026-10-02 for group-b with 20 received and 2 accepted, row-3 on 2026-10-03 for group-a with 15 received and 3 accepted, and row-4 on 2026-10-04 for group-b with 30 received and 4 accepted.","exampleUseCases":[{"title":"Pipeline acceptance rate correlation check","prompt":"I have a week of daily ingestion batch logs with received_rows and accepted_rows per dataset group — can you deduplicate them and tell me how strongly the two row counts are correlated?"},{"title":"Duplicate ingestion record cleanup","prompt":"My ETL pipeline accidentally emitted some duplicate batch records. I have 50 rows with row IDs, dates, group names, and received/accepted row counts — can you run exact deduplication and also compute the correlation between received and accepted rows for me?"},{"title":"Multi-group ingestion quality audit","prompt":"We have ingestion batch data across groups A and B from October — can you deduplicate the records and produce a correlation report between received_rows and accepted_rows so I can see how well our acceptance rate tracks incoming volume?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate records from the submitted batch, and (2) a Pearson or similar correlation report measuring the relationship between received_rows and accepted_rows across the deduplicated dataset. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, dataset_group, received_rows, accepted_rows) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Too few rows to compute meaningful correlation (e.g. single row) — degenerate correlation result","Null values in received_rows or accepted_rows may reduce correlation sample size","Payment of 0.01 USDC not received — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you have up to 200 data ingestion batch records with received_rows and accepted_rows metrics and need both exact duplicate removal and a correlation analysis between those two measures in a single low-cost call. Ideal for data engineers auditing pipeline throughput without needing an external analytics platform. Not suitable if you need more than 200 rows, more than two measures, predictive modeling, or live external data lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:25.356Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-exact-row-deduplication-two-measure-correlation-fed189f0"}