ChargePoint API database

Esther Ling, 2018

Overview

This is a script to pull usage data from ChargePoint API and save it into an SQL database.

BlogPost

https://lefthandwriter.github.io/software/2018/06/22/Designing-EV-Database.html

Instructions

1. Insert your organization's username and password in the main() function.
2. Set the startTime and endTime as the beginning of the day, i.e. midnight 00:00:00. Example: datetime(2018, 1, 01, 00, 00, 00).
3. Edit the "startTime" and "endTime" parameters to the time range that you want to pull data from.
4. ChargePoint's API limits each call to a maximum of 100 sessions. I've coded this under the assumption that there are no more than 100 sessions per day (which you will need to modify if usage in your area is higher than this).

Table Schema

The database schema can be found in a Google Slide here.

Example

See Notebooks folder for an Exploratory Jupyter notebook. I was making use of plotnine, a Python package that is built to mimic ggplot (R).

Package Dependencies

1. Zeep
2. Sqlite3

ChargePoint API Doc

https://na.chargepoint.com/UI/downloads/en/ChargePoint_Web_Services_API_Guide_Ver4.1_Rev4.pdf