{"uid":"cap_HfFxPZ_upoW_yYlG4idsN","slug":"energy-readings-duplicate-key-report-f5ae5fc6","name":"Energy Readings Duplicate Key Report","description":"Energy readings - Duplicate key report: Duplicate key report for Energy readings. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded duplicate key report deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-energy-readings-key-duplicates?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","meter","date","kwh","cost"],"properties":{"kwh":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"cost":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"meter":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1}},"additionalProperties":false},"default":[{"kwh":10,"cost":1,"date":"2026-10-01","meter":"group-a","row_id":"row-1"},{"kwh":20,"cost":2,"date":"2026-10-02","meter":"group-b","row_id":"row-2"},{"kwh":15,"cost":3,"date":"2026-10-03","meter":"group-a","row_id":"row-3"},{"kwh":30,"cost":4,"date":"2026-10-04","meter":"group-b","row_id":"row-4"}],"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_i-IoEJvN4i2FYU8Kb44Yu","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":"Identifies duplicate composite keys (meter + date combinations) across a batch of up to 200 energy reading records","exampleAgentPrompt":"Check this batch of energy readings for duplicate meter-and-date key combinations — I have 5 records: row-1 meter-A 2026-10-01 10 kWh $1, row-2 meter-B 2026-10-02 20 kWh $2, row-3 meter-A 2026-10-01 15 kWh $3, row-4 meter-C 2026-10-03 30 kWh $4, row-5 meter-B 2026-10-02 25 kWh $5.","exampleUseCases":[{"title":"Audit uploaded meter data before ingestion","prompt":"Before I load these 150 energy meter readings into our database, can you scan them for any duplicate meter-and-date combinations so I can fix conflicts first? Here are the records with row IDs, meter names, dates, kWh, and costs."},{"title":"Detect ETL pipeline duplicates","prompt":"Our ETL job processed energy readings from two sources and I think some rows got duplicated — can you run a duplicate key check on this batch of 80 records to tell me which meter-date pairs appear more than once?"},{"title":"Validate energy billing data quality","prompt":"I'm preparing monthly billing data for 120 meters and need to make sure no meter has two readings logged on the same date — can you identify any duplicate meter-date keys in this dataset?"}],"resultDescription":"A report identifying which records share duplicate composite keys (meter + date), including the affected row IDs and the conflicting key values, enabling the caller to locate and resolve data collisions within the submitted batch of up to 200 energy reading records.","failureModes":["Batch exceeds 200 items — request rejected with validation error","row_id missing or empty — record fails schema validation","date not in YYYY-MM-DD format — schema pattern validation error","No duplicates found — report returns empty duplicate list (not an error)","Numeric fields (kwh, cost) out of allowed range — validation error"],"whenToPreferThis":"Choose this endpoint when you need fast, local duplicate-key detection on energy meter reading records (meter + date composite key) without sending data to external enrichment services. It is ideal for pre-ingestion data quality checks, ETL pipeline validation, and billing data audits where privacy or latency matters. Prefer alternatives if you need forecasting, anomaly detection, or enrichment beyond key-collision reporting.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:10:32.481Z","isFirstParty":false,"canonicalSlug":"energy-readings-duplicate-key-report-f5ae5fc6"}