{"uid":"cap_pTNbAs9lA2gve_RzjW_Fq","slug":"transformation-throughput-analytics-duplicate-key-report-daily-sum-1b7b020e","name":"Transformation Throughput Analytics — Duplicate Key Report + Daily Sum Series","description":"Transformation throughput — Duplicate key report + Daily sum series: Duplicate key report + Daily sum series for supplied transformation throughput records (processed_rows, duration_seconds). 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-13-060?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","processed_rows","duration_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"processed_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"duration_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","processed_rows":10,"duration_seconds":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","processed_rows":20,"duration_seconds":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","processed_rows":15,"duration_seconds":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","processed_rows":30,"duration_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["processed_rows","duration_seconds"],"type":"string","default":"processed_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_3MaTN16ArH77ti0Ww13yZ","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 transformation throughput records to produce a duplicate key report and a daily sum time series for processed_rows or duration_seconds, across up to 200 rows.","exampleAgentPrompt":"I have 150 rows of transformation throughput records with row_id, dataset_group, date, processed_rows, and duration_seconds — can you run a duplicate key report and give me a daily sum series for processed_rows on that data?","exampleUseCases":[{"title":"ETL pipeline duplicate row audit","prompt":"Here are my ETL pipeline throughput records for October — can you check for any duplicate row IDs and also give me a daily sum of processed_rows so I can see output trends over the month?"},{"title":"Daily duration aggregation for pipeline monitoring","prompt":"I've got about 80 rows of transformation logs with dates and duration_seconds — run a duplicate key check on them and give me the daily total duration_seconds so I can spot any anomalies."},{"title":"Data quality check before ingestion","prompt":"Before I ingest these 120 transformation throughput records into our warehouse, can you identify any duplicate row IDs and summarize the daily sums for processed_rows by date?"}],"resultDescription":"Returns two independent reports: (1) a duplicate key report listing any row_ids that appear more than once in the submitted data, and (2) a daily sum time series showing the total value of the selected field (processed_rows or duration_seconds) grouped by date — all computed locally on the supplied data, no external lookups.","failureModes":["Missing required fields (row_id, date, processed_rows, duration_seconds) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows returns an error or truncates input","Null numeric values may be excluded or treated as zero in aggregations","Empty rows array rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate detection report and a daily sum aggregation on transformation throughput data (processed_rows or duration_seconds) in a single low-cost call. Ideal for data engineering teams auditing ETL pipeline logs before ingestion, or monitoring daily throughput trends across dataset groups. Prefer this over general analytics APIs when your data fits the row_id/dataset_group/date/processed_rows/duration_seconds schema and you want two bundled analytical reports for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:00.527Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-duplicate-key-report-daily-sum-1b7b020e"}