Niagara Mohawk Power Corporation d/b/a National Grid (NY) Data Access Guide
National Grid's New York utility (Niagara Mohawk) serves ~1.7M electric and ~600K gas customers across Upstate NY. It is a leader in data access: a Green Button Connect My Data program on the UtilityAPI platform (OAuth, 15-minute interval data), 24-month billing/usage exports, mature ANSI X12 EDI for ESCOs/DERS, and a NY System Data Portal for DER hosting capacity.
How to Get Your Niagara Mohawk Power Corporation d/b/a National Grid (NY) Data: All Access Methods
| Method | 1st Party | 3rd Party | Customer Types | Data Types | Latency | Format |
|---|---|---|---|---|---|---|
| My Account Portal | ✓ | — | Residential & business | Billing, monthly usage | Real-time | PDF, Excel/CSV |
| Green Button Connect My Data | ✓ | ✓ | All + authorized third parties | 15-min interval, billing | Near real-time | XML/JSON (ESPI), CSV |
| EDI 814/867 | — | ✓ | ESCOs / DER suppliers | Enrollment, consumption, interval | Scheduled batches | ANSI X12 |
| Energy Profiler Online | ✓ | — | Business ($600/yr) | Interval load, day-ahead prices | Real-time | Web portal |
| NY System Data Portal | ✓ | ✓ | DER developers | Hosting capacity, feeder/substation | Dynamic | Web, ArcGIS REST API |
Billing Data Access
National Grid NY provides online billing access via My Account / My Business Account, with PDF bills and bulk Excel export of up to 24 months of bill and payment data.
What Data Is on Your Niagara Mohawk Power Corporation d/b/a National Grid (NY) Bill
- Individual bills (PDF)
- Bulk bill + payment export (up to 24 months)
- Monthly electric and gas usage
- Green Button XML usage (ESPI)
How to Download Niagara Mohawk Power Corporation d/b/a National Grid (NY) Bills (Business & Commercial)
- 01Log into My Business Account and Link Account with the 10-digit account number
- 02Verify via text/email/security questions
- 03Export billing rows (24 months) in Excel across linked accounts
- 04For automated access, authorize a third party via Green Button Connect (OAuth)
How to Download Niagara Mohawk Power Corporation d/b/a National Grid (NY) Bills (Residential)
- 01Go to https://www.nationalgridus.com and Sign In/Register (Create My Account)
- 02Open Bills & Payments > Bill History
- 03View bills (magnifying glass) and download PDFs
- 04Use 'Export All Billing Rows' for up to 24 months in Excel
- 05Open Track Usage for electric/gas monthly consumption
Third-Party Access to Niagara Mohawk Power Corporation d/b/a National Grid (NY) Billing Data
Green Button Connect (OAuth)
- 01Register as a third-party/ESE on National Grid GBCMD portal
- 02Complete sandbox testing and certification
- 03Obtain customer OAuth authorization
- 04Retrieve data via UtilityAPI platform
Customer file sharing
- 01Customer exports billing rows as Excel/CSV
- 02Customer securely shares file with consultant
- 03Consultant analyzes data
Want to understand the charges on your bill?
See the Niagara Mohawk Power Corporation d/b/a National Grid (NY) Rate Schedules & Tariff Guide →Interval Data & Smart Meters
National Grid NY has deployed AMI smart meters with 15-minute interval capability; over 1 million electric meters were installed by November 2025, with gas modules rolling out from April 2025. Interval data is available via Green Button (download or OAuth Connect), the low-code API dashboard, and EDI.
How to Download Niagara Mohawk Power Corporation d/b/a National Grid (NY) Interval Data via Green Button
- 01Log into My Account and open Manage Data / Green Button Connect
- 02Choose Download My Data: CSV or XML (Green Button)
- 03Select period (last 13 months for AMI) and Electric and/or Gas
- 04Download; or use the low-code API dashboard for XML/JSON via green button tokens
Interval data is essential for rate comparison and TOU analysis.
See which Niagara Mohawk Power Corporation d/b/a National Grid (NY) rate schedule is best for your usage pattern →Third-Party API Access
National Grid NY's primary programmatic third-party access is Green Button Connect My Data, powered by UtilityAPI (utility ID NGNY). OAuth 2.0 with per-customer authorization returns consumption, billing, and 15-minute interval data in JSON/XML.
Available Niagara Mohawk Power Corporation d/b/a National Grid (NY) API Endpoints
| Function | Endpoint | Method | Format |
|---|---|---|---|
| List authorized accounts | /accounts | GET | JSON |
| Get consumption data | /accounts/{id}/consumption | GET | JSON/XML |
| Get billing data | /accounts/{id}/bills | GET | JSON |
How to Register as a Niagara Mohawk Power Corporation d/b/a National Grid (NY) API Vendor
- 01Register as third-party/ESE (or via UtilityAPI)
- 02Complete sandbox testing and certification
- 03Transition to live mode after National Grid approval
- 04Obtain customer OAuth authorization
- 05Pull data via UtilityAPI dashboard, direct API, or bulk request
EDI (Electronic Data Interchange)
Supported Niagara Mohawk Power Corporation d/b/a National Grid (NY) EDI Transaction Sets
| Code | Name | Purpose |
|---|---|---|
| 814 | Enrollment Request & Response | Customer enrollment/drop/change with an ESCO (bi-directional). |
| 814HU | Consumption History Request | Request historical usage data. |
| 867HU | Consumption History Response | Provide up to 24 months of consumption history. |
| 867MIU | Monthly Interval Usage | Provide monthly aggregated interval consumption. |
| 867HIU | Historic Interval Usage | Provide historical 15-minute interval usage. |
| 810 | Invoice | Billing/invoice transmission. |
| 824 | Service Order | Service order modifications (bi-directional). |
How to Enroll in Niagara Mohawk Power Corporation d/b/a National Grid (NY) EDI
- 01Obtain NY PSC approval (Retail Access Application; Cases 15-M-0127, 12-M-0476) and NYISO acceptance (electric)
- 02Register business entities (NY DOS, EIN, DUNS, W-9)
- 03Execute Trading Partner Agreement, Data Security Agreement, and related forms
- 04Complete Phase II multi-utility batch testing
- 05Complete Phase III National Grid certification testing
- 06Receive EDI certification and go live
Rate Schedules & Tariff Analysis
National Grid (Niagara Mohawk) separates regulated delivery charges (set in PSC No. 220 electric and PSC No. 219 gas tariffs) from energy supply, which customers buy at the utility's monthly market price or from a competitive ESCO. Electric C&I customers are tiered by demand: SC-2 (<100 kW), SC-3 (>100 kW), SC-3A (>2,000 kW), each priced by service voltage; SC-7 is a standby rate for self-generating customers. Gas C&I customers are tiered by annual therm volume across SC-2 (small) and SC-5/6/7/8 (large firm, interruptible, transportation). For large electric customers, demand charges and voltage-level customer charges dominate the controllable bill.
Niagara Mohawk Power Corporation d/b/a National Grid (NY) Rate Schedule List
| Schedule | Applicability |
|---|---|
| Electric SC-2 | Small C&I, <100 kW |
| Electric SC-3 | Demand-metered C&I, >100 kW |
| Electric SC-3A | Large/primary, >2,000 kW |
| Gas SC-2 | Small general gas |
| Gas SC-5/6/7/8 | Large firm/interruptible/transportation gas |
Niagara Mohawk Power Corporation d/b/a National Grid (NY) Rate Features & TOU Details
- Two regulated tariffs: Electric PSC No. 220 and Gas PSC No. 219, both under NY PSC oversight
- Electric C&I tiered by monthly demand — SC-2 (<100 kW), SC-3 (>100 kW, 12 consecutive months), SC-3A (>2,000 kW)
- SC-2 customers exceeding 2,000 kWh/month for four consecutive months move to demand pricing (SC-2D)
- Voltage-differentiated customer/demand charges: SC-3A customer charge ranges $4,150–$10,350/mo by voltage (eff 09-01-2025)
- Electric SC-7 standby service for on-site generation (1-year minimum term)
- Gas classes by annual therm volume: Firm SC-5, Interruptible SC-6, Transportation SC-7, Large-Volume SC-8
- Delivery vs supply unbundled — supply via utility market price or ESCO
- Optional EV Phase-In Rate available on demand classes (SC-2D, SC-3, SC-3A)
For a deeper analysis including cost optimization strategies and historical rate trends:
Read the full Niagara Mohawk Power Corporation d/b/a National Grid (NY) Rate Optimization Guide →Sources
Other Data Access Programs
EPA Portfolio Manager Integration
Whole-building benchmarking; submit an Energy Usage Release Form to upload aggregated consumption to ENERGY STAR Portfolio Manager.
- 01Create Portfolio Manager account and add properties
- 02Submit Energy Usage Release Form to EnergyEfficiency@nationalgrid.com
- 03Receive monthly aggregated data uploads
Integrated Energy Data Resource (IEDR)
NY statewide energy data platform (Case 20-M-0082, NYSERDA-led) for standardized multi-utility data access; Phase 2 under development.
- 01Monitor NYSERDA IEDR program for third-party onboarding
- 02Expect OAuth/Green Button-based access
Community Distributed Generation (CDG)
CDG sponsors can request customer usage history via EDI or Green Button Connect.
- 01Contact the CDG portal
- 02Choose EDI bulk pulls or per-customer Green Button OAuth
Limitations & Considerations
- ⚠Green Button Connect was in beta as of 2025 (stable but evolving).
- ⚠Customer-facing interval history is ~13 months; 24 months for monthly/billing.
- ⚠Direct third-party billing access requires OAuth or customer file sharing.
- ⚠ESCO EDI enrollment requires PSC approval and Phase II/III certification (multi-week).
- ⚠IEDR statewide platform is still under development (Phase 2).
Niagara Mohawk Power Corporation d/b/a National Grid (NY) Data Access FAQ
Does National Grid NY support Green Button?▾
Yes. National Grid NY offers Green Button Download My Data (CSV/XML) for customers and Green Button Connect My Data (OAuth) for third parties on the UtilityAPI platform (utility ID NGNY). It was the first IOU-level Green Button-certified utility.
How granular is the interval data?▾
AMI provides 15-minute electric interval data with roughly 13 months of history. Gas modules add gas interval/consumption data. Access is via Green Button download, GBCMD OAuth, EDI 867HIU/867MIU, or Energy Profiler Online.
Can a C&I customer choose its electricity supplier?▾
Yes. New York is deregulated: customers can choose an ESCO for supply while National Grid (Niagara Mohawk) provides regulated delivery. ESCOs must be PSC-approved and exchange data via ANSI X12 EDI.
How do third parties get automated data access?▾
Register for Green Button Connect, complete sandbox certification, then obtain customer OAuth authorization to pull 15-minute interval and billing data via UtilityAPI. ESCOs/DER suppliers can alternatively use EDI 814/867 transactions.
What is the NY System Data Portal?▾
An ArcGIS REST-based portal exposing distribution feeder/substation data and DER hosting capacity for developers, useful for siting solar, storage, and EV projects.
The Best Way to Access Data from Niagara Mohawk Power Corporation d/b/a National Grid (NY)
Nectar connects to Niagara Mohawk Power Corporation d/b/a National Grid (NY) and 7,000+ utility providers — billing, interval, and rate data delivered automatically. No portals, no forms, no manual downloads.
Nectar for Energy & Sustainability Teams
Managing utility data for commercial or industrial buildings? Nectar offers a free energy data audit — we'll review your current setup and show you where automation can save your team hours every month.
Get a Free AuditNectar for Developers & Consultants
Building energy tools or advising clients on utility data? Nectar works with technology partners and consultants who need reliable data infrastructure.
Partner with Us