Get EV Charging Events API

This API fetches and delivers EV charging events to a customer's data lake/business system. It can be used for the following use cases:

Distribution system planning. A list of charging events including kW peak, time, and kWh will help distribution system planners create better models and proactively upgrade or defer upgrades down to the secondary of distribution transformers, as required.
EV programs. Knowledge of EV charging loads will help EV program groups target appropriate customers and design better rates for EV programs, optimizing marketing O&M and participation in programs.
Data scientists. Forecasting loads and creating models of EV charging behavior may be performed by data scientists in utilities for distribution system planning and EV program impacts.
Controls. Use of the real-time EV charging events to inform transformer protection, VVO, DERMS, or other applications.

Get Bulk request and response examples

This is used to request a large data file in the format of your choice (Parquet, Orc, Json, CSV) for downloading when the request can take several minutes to complete.

Data product ID. 4ddaf70e-b61d-4396-8508-00ee50c1ddd7
Data latency. Three minutes or greater, depending on query parameters.
Maximum result size. Millions.
Data availability. Last 13 months.

Example request

Copy

POST /data-products/4ddaf70e-b61d-4396-8508-00ee50c1ddd7/subscriptions/{subscriptionId}/batch-request
{
    "FileType": "Csv",
    "Tokens":
    {
        "StartRecievedDatetime": "2023-1-1",
        "EndRecievedDatetime": "2023-1-31",
        "StartEventDate": "2023-1-1",
        "EndEventDate": "2023-1-31",
        "EntityType": "Transformer",
        "EntityId": "X1-01-A",
    }
}

Example response CSV

Copy

RecievedTime,ServicePointId,MeterId,MeterNumber,ElectronicSerialNumber,TransformerId,PremiseId,ChargeStartTime,ChargeEndTime,ChargeW,ChargeDuration,ChargeEnergy
2023-09-13T00:29:55.55Z,9000372474,1000634831,1000634831,2.16.840.1.114416.15.80.1000634831,4929542183-90777887,P9000372474,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,1237.375166,22,56.24432574
2023-09-13T00:29:55.55Z,9000502815,1000838385,1000838385,2.16.840.1.114416.15.80.1000838385,--,P9000502815,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,2985.646248,3,995.215416
2023-09-13T00:29:55.55Z,9000053282,1000092413,1000092413,2.16.840.1.114416.15.80.1000092413,2594744147-91918635,P9000053282,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,626.8082122,11,56.98256474
2023-09-13T00:29:55.55Z,9000585414,1000448760,1000448760,2.16.840.1.114416.15.80.1000448760,2662535221-10734063,P9000585414,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,954.9134745,21,45.47207021
2023-09-13T00:29:55.55Z,9000594308,1000508737,1000508737,2.16.840.1.114416.15.80.1000508737,2949637457-92808645,P9000594308,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,0,0,0
2023-09-13T00:29:55.55Z,9000580263,1000071660,1000071660,2.16.840.1.114416.15.80.1000071660,2435841314-92195447,P9000580263,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,2681.166077,6,446.8610128
2023-09-13T00:29:55.55Z,9000372477,1000836297,1000836297,2.16.840.1.114416.15.80.1000836297,4495046038-10795431,P9000372477,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,5927.567965,6,987.9279942
2023-09-13T00:29:55.55Z,9000007738,1000561269,1000561269,2.16.840.1.114416.15.80.1000561269,2604141857-10581404,P9000007738,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,3120.183721,5,624.0367441
2023-09-13T00:29:55.55Z,9000389087,1000326772,1000326772,2.16.840.1.114416.15.80.1000326772,2768938379-10477102,P9000389087,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,1557.510999,16,97.34443744
2023-09-13T00:29:55.55Z,9000530026,1000062826,1000062826,2.16.840.1.114416.15.80.1000062826,2302540356-10169202,P9000530026,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,4566.031821,5,913.2063642
2023-09-13T00:29:55.55Z,9000098919,1000567185,1000567185,2.16.840.1.114416.15.80.1000567185,3393042722-93886808,P9000098919,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,732.997967,19,38.57884037
2023-09-13T00:29:55.55Z,9001805366,1000846429,1000846429,2.16.840.1.114416.15.80.1000846429,--,P9001805366,2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,4364.345477,1,4364.345477

Get Synchronous request and response examples

This is used to request a smaller data set 'on demand' with very low latency.

Data latency. 1-5 seconds.
Maximum result size. 1,000 rows.
Data availability. Last 13 months.

Example request

Copy

GET /v1/{tenantid}/di/apps/evaware/events
     
     {
         "StartRecievedDatetime": "2023-1-1",
         "EndRecievedDatetime": "2023-1-31",
         "EntityType": "Transformer",
         "EntityId": "X1-01-A"
     }

Example response

Copy

[
{
   "RecievedTime": "2023-09-13T00:29:55.55Z",
   "ServicePointId": 9000372474,
   "MeterId": 1000634831,
   "MeterNumber": 1000634831,
   "ElectronicSerialNumber": "2.16.840.1.114416.15.80.1000634831",
   "TransformerId": "4929542183-90777887",
   "PremiseId": "P9000372474",
   "ChargeStartTime": "2023-09-13T00:29:55.55Z",
   "ChargeEndTime": "2023-09-13T00:29:55.55Z",
   "ChargeW": 1237.375166,
   "ChargeDuration": 22,
   "ChargeEnergy": 56.24432574
},
{
   "RecievedTime": "2023-09-13T00:29:55.55Z",
   "ServicePointId": 9000502815,
   "MeterId": 1000838385,
   "MeterNumber": 1000838385,
   "ElectronicSerialNumber": "2.16.840.1.114416.15.80.1000838385",
   "TransformerId": "--",
   "PremiseId": "P9000502815",
   "ChargeStartTime": "2023-09-13T00:29:55.55Z",
   "ChargeEndTime": "2023-09-13T00:29:55.55Z",
   "ChargeW": 2985.646248,
   "ChargeDuration": 3,
   "ChargeEnergy": 995.215416
},
{
   "RecievedTime": "2023-09-13T00:29:55.55Z",
   "ServicePointId": 9000053282,
   "MeterId": 1000092413,
   "MeterNumber": 1000092413,
   "ElectronicSerialNumber": "2.16.840.1.114416.15.80.1000092413",
   "TransformerId": "2594744147-91918635",
   "PremiseId": "P9000053282",
   "ChargeStartTime": "2023-09-13T00:29:55.55Z",
   "ChargeEndTime": "2023-09-13T00:29:55.55Z",
   "ChargeW": 626.8082122,
   "ChargeDuration": 11,
   "ChargeEnergy": 56.98256474
},
{
   "RecievedTime": "2023-09-13T00:29:55.55Z",
   "ServicePointId": 9000585414,
   "MeterId": 1000448760,
   "MeterNumber": 1000448760,
   "ElectronicSerialNumber": "2.16.840.1.114416.15.80.1000448760",
   "TransformerId": "2662535221-10734063",
   "PremiseId": "P9000585414",
   "ChargeStartTime": "2023-09-13T00:29:55.55Z",
   "ChargeEndTime": "2023-09-13T00:29:55.55Z",
   "ChargeW": 954.9134745,
   "ChargeDuration": 21,
   "ChargeEnergy": 45.47207021
},
{
   "RecievedTime": "2023-09-13T00:29:55.55Z",
   "ServicePointId": 9000594308,
   "MeterId": 1000508737,
   "MeterNumber": 1000508737,
   "ElectronicSerialNumber": "2.16.840.1.114416.15.80.1000508737",
   "TransformerId": "2949637457-92808645",
   "PremiseId": "P9000594308",
   "ChargeStartTime": "2023-09-13T00:29:55.55Z",
   "ChargeEndTime": "2023-09-13T00:29:55.55Z",
   "ChargeW": 0,
   "ChargeDuration": 0,
   "ChargeEnergy": 0
}
]

Parameters

Table 21
Name	Description	Operators	Required	Type	Format	Default	Range	Origination
StartEventDate	Start date being queried as Min(EventDate)	Greater than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	2020-01-01T00:00:00.0Z	(Current UTC Date) to (Current UTC Date - 13 months)	Edge app
EndEventDate	End date being queried as Max(EventDate)	Less than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	9999-12-31T00:00:00.0Z	(Current UTC Date) to (Current UTC Date - 13 months)	Edge app
StartReceivedDatetime	Min ReceivedTime data	Greater than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	2020-01-01T00:00:00.0Z	(Current UTC Date) to (Current UTC Date - 13 months)	App Platform
EndReceivedDatetime	Max ReceivedTime data	Less than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	9999-12-31T00:00:00.0Z	(Current UTC Date) to (Current UTC Date - 13 months)	App Platform
EntityType	Servicepoint, Meter, ESN, Transformer, premises, None	Equals	No	String	N/A	N/A	N/A	CIS MDMS GIS
EntityId	Dependent on EntityType	In list	No	String	N/A	N/A	N/A	CIS MDMS GIS

Data values

Table 22
Name	Description	Type	Units	Range	Format	Nullable	Origination
ReceivedTime	When the data was received by the App Platform	Datetime	N/A	N/A	YYYY-MM-DDTHH:MM:SSZ	No	App Platform
ServicePointId	Service Point ID as of EventDate	String	N/A	N/A	N/A	No	CIS MDMS GIS
MeterId	Meter ID as of EventDate	String	N/A	N/A	N/A	No	CIS MDMS GIS
MeterNumber	Meter Number as of EventDate	String	N/A	N/A	N/A	Yes	CIS MDMS GIS
ElectronicSerialNumber	Electronic Serial Number	String	N/A	N/A	N/A	No	CIS MDMS GIS
TransformerId	Transformer ID as of EventDate	String	N/A	N/A	N/A	Yes	CIS MDMS GIS
PremiseId	Premise ID as of EventDate	String	N/A	N/A	N/A	Yes	CIS MDMS GIS
ChargeStartTime	Start datetime of EV charging event	Datetime	N/A	N/A	YYYY-MM-DDTHH:MM:SSZ	No	Edge app
ChargeEndTime	End datetime of EV charging event	Datetime	N/A	N/A	YYYY-MM-DDTHH:MM:SSZ	No	Edge app
ChargeW	W of EV charging event	Real	W	>0	N.NN	Yes	Edge app
ChargeDuration	Duration of the charge in hours	Integer	Hours	>0	N	Yes	Edge app
ChargeEnergy	Wh of EV charging event	Real	Watt-hours	>0	N.NN	Yes	Edge app