Today, I'm going to show you how to pull your own utility data on Silicon Valley Clean Energy's Data Hive platform.
SVCE and UtilityAPI designed the platform to let you request and download, at no cost, your interval data for all your accounts in SVCE territory. Data Hive is free to use, and allows you to download your data in a variety of useful formats.
Silicon Valley Clean Energy is the community electricity provider for thirteen communities in Santa Clara County: Campbell, Cupertino, Gilroy, Los Altos, Los Altos Hills, Los Gatos, Milpitas, Monte Sereno, Morgan Hill, Mountain View, Saratoga, Sunnyvale, and unincorporated Santa Clara County. [see map]
If your account's address is in any of these thirteen communities and if you're an SVCE customer, you can get your energy data for free from the SVCE Data Hive.
In essence, you'll need to register as a commercial user and then authorize yourself on Data Hive in order to request and collect utility data from your accounts. Once you're registered, I'll show you how to request and download utility data.
1) Visit utilityapi.com/register/svce
2) Scroll down; click on "Register as a Commercial User". This will pull up the registration form.
3) Fill out the registration form. It should only take you about a minute. The form will ask you for
Then you will be asked to create a password, which will serve as your login credentials.
Login credentials for what? For your new UtilityAPI dashboard! When you submit the
finished form, a UtilityAPI account will automatically be created for you so that you
will have a dashboard. The dashboard is not only where you request your own data,
but also where you can view and download data.
4) State your Scope of Use, which means, what are you going to be using this data for. For Third Parties, it's typically for a solar proposal, an EV charger, or an energy storage project. Since you are authorizing yourself, you can tell yourself whatever you want about your scope of use. The URL field is optional - skip it.
5) You may want to opt out of being listed in the public directory of third parties.
6) Agree to terms and conditions.
7) Click "Register." A UtilityAPI account will be created for you.
The first step is collecting a list of all the accounts you want to authorize.
Then determine who at your company is listed as the official contact on the accounts. Only that person is going to be able to get through the verification process without assistance. If you don't know your account numbers, who the official contact is, or the phone number or email associated in your utility accounts, please contact Rebecca Fang at SVCE.
Once you have this information, you're ready to use the dashboard to access your data. We'll assume you are the official contact on the accounts for the rest of the tutorial.
When you click "Securely share your utility data" and then "Continue to SVCE", we'll need to look up your account. We're going to use the list of account numbers you collected before to locate each account.
One Time Passcode (OTP) authentication
In order to make sure that you are the actual account holder, and thus, authorized to share your data, we use one time passcode authentication. You will get a code sent to you in the method you choose:
You then type the code in and click submit.
A note on looking up accounts:
In order to proceed, we need to find a unique match of information. If the same phone numbers, addresses or emails have been used to set up multiple accounts, then we must use the actual account number in order to authorize data sharing. That's why, at the beginning of this tutorial, we asked you to identify the list of account numbers you want to authorize.
If you don't know the phone number or email associated in your utility accounts, please contact Rebecca Fang at SVCE.
The final step in the authorization process is for you to set parameters about what kinds of data you want to share with yourself. The choices are
You then click the green "Authorize" button, and you're done.
You will receive an authorization receipt that includes a link to revoke authorization at any time. UtilityAPI will also email you (or notify you via webhooks if you're using the API itself) to let you know that you have newly authorized data sharing.
Return to your UtilityAPI dashboard. Go back to where it says My Dashboard, next to the "Request Data" button near the top.
The newest authorization will always appear at the very top of your dashboard, so you don't have to search for it. We're going to give you certain identifiers, so you don't have to figure out which meters you need the data for: Service Agreement ID, Account number, billing account number, address of each meter, what tarif each meter is on. From here, you'll have two choices:
You can click on Get Data, then Collect Historical Data. UtilityAPI will then begin historical data collection, or
You can click on Get Data, then Start Ongoing Monitoring. You will then be prompted to select the frequency you would like our software to pull the data going forward:
Click Start Monitoring to begin the data pull.
We always have our API documentation available at www.utilityapi.com/docs. This documentation is for companies who want to get a bit more technical on the back end, perhaps do an integration with their CRM software, like Salesforce, or push the data into their own proprietary software platform. We offer a standards-compliant Green Button solution, for those who are familiar with how that works. This is currently the only UL tested, GBA certified Green Button platform in the US.
If you have any questions at all, please do not hesitate to reach out via email to firstname.lastname@example.org