{"uid":"cap_-8unr6BrrcWBL1XUdS1DO","slug":"data-ingestion-batches-duplicate-key-report-daily-sum-series-428f00cb","name":"Data Ingestion Batches — Duplicate Key Report + Daily Sum Series","description":"Data ingestion batches — Duplicate key report + Daily sum series: Duplicate key report + Daily sum series 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-060?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_A3WBPapUFm7-A_iwYH1xp","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 a duplicate key report and a daily sum time series for received_rows or accepted_rows.","exampleAgentPrompt":"Check my ingestion batch records for duplicate row IDs and also give me a daily sum of received_rows — here are my records: [{\"row_id\":\"row-1\",\"dataset_group\":\"group-a\",\"date\":\"2026-10-01\",\"received_rows\":10,\"accepted_rows\":1},{\"row_id\":\"row-2\",\"dataset_group\":\"group-b\",\"date\":\"2026-10-02\",\"received_rows\":20,\"accepted_rows\":2}].","exampleUseCases":[{"title":"Audit pipeline batch logs for duplicates","prompt":"I have a list of ingestion batch records with row IDs, dataset groups, dates, and row counts — can you run a duplicate key check and show me the daily sum of received_rows across all of them?"},{"title":"Daily accepted rows trend for ETL monitoring","prompt":"Here are my last 30 days of ingestion batch records. I want to see a daily sum series for accepted_rows and flag any duplicate row IDs so I can clean them up."},{"title":"Data quality check before downstream load","prompt":"Before I push these ingestion batches downstream, can you scan them for any duplicate row_id values and give me a day-by-day total of received_rows so I can spot any anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report listing any row_id values that appear more than once in the submitted records, and (2) a daily sum time series showing the total of the selected field (received_rows or accepted_rows) aggregated by date across all submitted rows. Both reports are computed locally without external lookups.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — request rejected","Invalid date format (not YYYY-MM-DD) — schema validation failure","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) — validation error","Invalid field enum value (not received_rows or accepted_rows) — schema rejection","Numeric values outside allowed range (±1,000,000,000,000) — validation error","Payment not provided or insufficient — 402 payment required"],"whenToPreferThis":"Choose this endpoint when you need two specific analyses — duplicate key detection and daily sum aggregation — performed together on data ingestion batch records in a single cost-effective call. It is ideal for ETL monitoring, pipeline auditing, and data quality checks where you supply your own batch records (up to 200 rows) and need results quickly without external lookups or live data connections. It is not suitable if you need more than 200 rows processed, real-time pipeline monitoring, or analytical operations beyond duplicate detection and daily summation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:36.932Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-duplicate-key-report-daily-sum-series-428f00cb"}