{"uid":"cap_QaMwErGXHF_zEchr82Z4t","slug":"time-series-completeness-exact-row-deduplication-duplicate-key-report-69eb1982","name":"Time Series Completeness — Exact Row Deduplication + Duplicate Key Report","description":"Time series completeness — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied time series completeness records (observed_points, expected_points). 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-16-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","observed_points","expected_points"],"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},"expected_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","expected_points":1,"observed_points":10},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","expected_points":2,"observed_points":20},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","expected_points":3,"observed_points":15},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","expected_points":4,"observed_points":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_jMQyar4HjzNm2PzrhjbdU","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":"Runs two local analytical reports on supplied time series completeness records: exact row deduplication and duplicate key detection, for up to 200 rows.","exampleAgentPrompt":"I have a batch of time series completeness records with fields row_id, dataset_group, date, observed_points, and expected_points — can you run both an exact row deduplication and a duplicate key report on them? Here are up to 200 rows to check.","exampleUseCases":[{"title":"Cleaning ETL pipeline completeness logs","prompt":"Our ETL pipeline writes daily completeness records for each dataset group, but I think some rows got written twice. Can you run exact row deduplication and a duplicate key report on these 150 completeness records so I know which rows to drop and which keys are repeated?"},{"title":"Auditing multi-source data ingestion","prompt":"We're merging completeness records from two data sources and need to check for both fully identical rows and duplicate date+group keys before we load them into the warehouse. Here are the 80 rows — please give me both the dedup report and the duplicate key report."},{"title":"Daily data quality validation for sensor completeness","prompt":"Every morning I want to validate yesterday's sensor completeness records to catch any duplicate entries — can you run the exact row deduplication and duplicate key check on these 60 rows with their observed and expected point counts?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying fully identical rows across the submitted records, and (2) a duplicate key report identifying rows sharing the same key fields (e.g. date and dataset_group). Both reports are generated locally from the supplied data with no external lookups.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, date, dataset_group, observed_points, expected_points) cause schema validation failure","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Empty rows array returns an error","Values outside the allowed numeric range for observed_points or expected_points are rejected"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate row detection and duplicate key identification in a single call on time series completeness records (observed vs expected data points per date and group). It is especially useful for data pipeline validation, ETL deduplication, and completeness audit workflows where you have up to 200 rows and want two complementary deduplication reports without external data access or prediction.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:54.461Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-exact-row-deduplication-duplicate-key-report-69eb1982"}