SDS P4 API

<back to all web services

UsageReading

Get usagereading

The following routes are available for this service:
GET/api/v5/meteringpoints/{Ean}/usagereading/{Aggregation}/{DateFrom}Get usage/reading of a single asset with the selected aggregation starting from DateFrom
GET/api/v5/meteringpoints/{Ean}/usagereading/{Aggregation}/{DateFrom}/{DateTo}Get usage/reading of a single asset with the selected aggregation and period
UsageReading Parameters:
NameParameterData TypeRequiredDescription
EanpathEAN (18 numbers)NoRequest of details of specific meteringpoint with Ean
AggregationpathEnumYesAggregation level. The None-'level' will give the most detailed level available for the requested asset. If a level is requested that is not available or can be calculate, no data is returned. Enum options: None, Hour
DateFrompathDate: yyyy-mm-ddYesStart date the usages are requested for
DateTopathDate: yyyy-mm-ddNoEnd date the usages are requested for (this is included in the response). If no date is provided the DateTo will seven days from the DateFrom.
PayloadFormatqueryEnumNoThe output can be generated in a few formats. UsageReturnCombined: return values will be subtracted from the usage, UsageReturn: separate columns form usage and return (if available) and UsageReturnAndTariff: for both usage and return a column for tariff1 and tariff2. Default value: UsageReturnCombined
SourcequeryEnumNoSee filter. Usages are available from the Detail channel. Default value: Detail
AddDateNLqueryBooleanNoAdd column with Dutch day (Default: false)
AddTimestampsqueryBooleanNoAdd columns with CreatedOn and LastUpdated (Default: false)
AddEanqueryBooleanNoAdd column with ean (Default: false)
RegistersInRowsqueryBooleanNoCreate a row for each register instead of a column/field for each register (Default: false)
CalculateDetailTariffqueryBooleanNoGridoperator doesn't provided tariff information for the detail channel, but this can be calculated (Default: false)
AlsoReadingqueryBooleanNoIf want to get the reading as well with the usages
CacheKeyquerystringNoCacheKey used for Internal logic
Generic Parameters:
NameParameterData TypeRequiredDescription
ApiKeyformStringYesApi-key. Used to provide credentials to the api. Can also be provided through the request headers with key: X-API-KEY
OnlyPayloadformBooleanNoNormally the result of the request is put inside a resultobject with some status information about the request. If you want the output as csv this outer object can be irritating. Default value: FALSE
ShowRequestformBooleanNoShow the request as interpreted by the api. Useful to see how filters / dates are parsed. If no value us provided, the default value is: FALSE
DateTimeFormatformEnumNoFormat all DateTime in the response object. If used in browser, sometimes ISO8601 is not correctly transformed. Enum options: ISO8601 (DEFAULT), UTC, NL, NLOffset, Unix, UnixMillis
DateTimeFormat Enum:
ISO8601
UTC
NL
NLOffset
IN
INOffset
Unix
UnixMillis
AggregationForAPI Enum:
None
Hour
Day
Week
Month
Year
PayloadFormat Enum:
UsageReturnCombined
UsageReturn
UsageReturnAndTariff
MeasurementSource Enum:
Detail
Day
Month
Unknown

To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv

HTTP + JSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /api/v5/meteringpoints/{Ean}/usagereading/{Aggregation}/{DateFrom} HTTP/1.1 
Host: p4v8.smartdatasolutions.nl 
Accept: text/jsv