{"uid":"cap_LhqvKb6vvVj6PdcsZCx5O","slug":"time-series-completeness-duplicate-key-report-adjacent-row-changes-a0b61d41","name":"Time Series Completeness — Duplicate Key Report + Adjacent Row Changes","description":"Time series completeness — Duplicate key report + Adjacent row changes: Duplicate key report + Adjacent row changes 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-062?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},"field":{"enum":["observed_points","expected_points"],"type":"string","default":"observed_points"}}},"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_hbnq1YVhZMadLnQFFbEED","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 analytical reports on time series completeness data: a duplicate key detection report and an adjacent row change analysis, processing up to 200 rows of observed vs. expected data points.","exampleAgentPrompt":"Check my time series completeness records for duplicate row IDs and adjacent row changes — here are up to 50 rows with fields row_id, dataset_group, date, observed_points, and expected_points; run both reports on the observed_points field.","exampleUseCases":[{"title":"Auditing sensor data completeness logs","prompt":"I have daily completeness records for my IoT sensors — each row has a row_id, dataset_group, date, observed_points, and expected_points. Can you run the duplicate key report and adjacent row changes analysis on up to 150 rows using the observed_points field so I can spot data gaps and repeated entries?"},{"title":"Validating ETL pipeline output integrity","prompt":"After our nightly ETL job, I need to verify the completeness records it produced — around 80 rows with row_id, dataset_group, date, observed_points, and expected_points. Run the duplicate key and adjacent row change reports on the expected_points field to check if anything looks off."},{"title":"Monitoring content delivery metric completeness","prompt":"We track daily content delivery completeness across multiple groups and I want to check for duplicate keys and sequential fluctuations in our observed_points across 120 rows — each has a row_id, dataset_group, date, observed_points, and expected_points. Can you run both analytical reports?"}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying rows with repeated key combinations within the dataset, and (2) an adjacent row changes report showing value differences between consecutive rows for the selected field (observed_points or expected_points). Results cover up to 200 input rows and are computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, observed_points, or expected_points) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers schema validation failure","Null values in the selected field may produce incomplete adjacent change calculations","Empty rows array (minItems: 1 not met) causes rejection","Numeric values outside allowed range (-1T to +1T) fail schema validation"],"whenToPreferThis":"Choose this endpoint when you need both duplicate key detection and adjacent row change analysis on time series completeness data (observed vs. expected point counts) in a single cost-efficient call. It is best suited for data quality audits of completeness logs across dated, grouped records where you want to spot key collisions and sequential value shifts without any external data enrichment or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:08.913Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-duplicate-key-report-adjacent-row-changes-a0b61d41"}