Use UtilityAPI to import usage data (US only)

OpenSolar supports integrating UtilityAPI to quickly import usage data for projects (USA only).

What is UtilityAPI?

UtilityAPI is an online platform that offers a simple, fast solution for requesting and downloading utility customer bills and interval data.

 Visit https://utilityapi.com/ for additional information.

Formats of UtilityAPI

There are two formats usage data can be imported in to OpenSolar from UtilityAPI:

1. Hourly interval data (OpenSolar will convert 15 mins and 30 mins data to hourly data)
2. Daily average for each month (In case the hourly data is not available, UtilityAPI converts the bill and total usage of each month to provide OpenSolar a daily average per month)

How to integrate UtilityAPI on OpenSolar?

1. To integrate you must have an account on UtilityAPI with the project data you want to import.
2. Go to User Settings in UtilityAPI and navigate to the API Tokens section.
3. Create a new API token.
4. Login to OpenSolar (Admin) and go to Control > Other > Integrations & API Keys
5. Copy and paste the API token from UtilityAPI to OpenSolar and click the save button.
6. You should now be able to see the Utility Import (Beta) button in the project page > Electricity Usage.
7. Click the button and select the relevant project. The data must already be active within the UtilityAPI platform.
8. This will import an annual hourly data or average daily value for each month.
   

Note: OpenSolar will convert 15 mins and 30 mins interval data from UtilityAPI to hourly data.