{"uid":"cap_CC_S6YuseM5CfA-IiJywq","slug":"energy-readings-exact-row-deduplication-8210c37d","name":"Energy Readings Exact Row Deduplication","description":"Energy readings - Exact row deduplication: Exact row deduplication 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 exact row deduplication deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-energy-readings-deduplicate?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_dVlrfAEupMeWlcbeFDogy","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":"Removes exact duplicate rows from a batch of up to 200 energy meter readings, returning only unique records based on all typed fields.","exampleAgentPrompt":"I have a list of energy meter readings with fields for meter ID, date, kWh, and cost, and I suspect there are exact duplicate rows in the data — can you deduplicate them and give me back only the unique records? Here are the rows: [{\"row_id\":\"r1\",\"meter\":\"meter-A\",\"date\":\"2026-10-01\",\"kwh\":10,\"cost\":1.5},{\"row_id\":\"r2\",\"meter\":\"meter-A\",\"date\":\"2026-10-01\",\"kwh\":10,\"cost\":1.5},{\"row_id\":\"r3\",\"meter\":\"meter-B\",\"date\":\"2026-10-02\",\"kwh\":25,\"cost\":3.0}].","exampleUseCases":[{"title":"Pipeline deduplication before analytics","prompt":"Before I run my monthly energy analytics, can you deduplicate these 150 meter readings — I think our data pipeline is injecting duplicate rows for meters like 'substation-7' on certain dates, and I want only unique rows based on all fields including kWh and cost?"},{"title":"Billing data cleanup for reconciliation","prompt":"I'm reconciling energy invoices and my export has exact duplicate billing rows mixed in — please deduplicate these records where each row has a meter ID, date, kWh consumed, and a cost value, and return just the distinct ones."},{"title":"Smart meter log deduplication before storage","prompt":"Our smart meter logger sometimes double-writes readings when it reconnects — can you take these energy readings with row IDs, meter names, dates, kWh, and cost fields, and remove any exact duplicate entries before we store them?"}],"resultDescription":"The endpoint returns the deduplicated set of energy reading records — rows that are exact duplicates (matching on all fields: meter, date, kwh, cost) are removed, leaving only unique rows. The response includes the surviving unique records with their original row_ids and typed field values, along with counts of input vs output rows.","failureModes":["Fewer than 1 row supplied — validation error returned","More than 200 rows submitted — request rejected with max-items error","Invalid date format (not YYYY-MM-DD) — pattern validation failure","row_id missing or empty string — minLength validation error","Non-numeric kwh or cost values outside ±1,000,000,000,000 range — schema rejection","Malformed JSON body — parse error response","Payment not attached or insufficient USDC — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need fast, local exact-match deduplication of structured energy meter readings (up to 200 rows) without any external enrichment or forecasting. It is ideal for data pipeline cleaning steps, pre-storage deduplication, or reconciliation tasks where the data is already typed and you need a simple, deterministic result at very low cost ($0.01 USDC). Prefer alternatives if you need fuzzy/approximate deduplication, records exceeding 200 rows, or enrichment with external data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:04:34.391Z","isFirstParty":false,"canonicalSlug":"energy-readings-exact-row-deduplication-8210c37d"}