Personal tools

Difference between revisions of "API"

From PhotoVoltaic Logger new generation

Jump to: navigation, search
m (Data readout)
m (Parameters)
Line 59: Line 59:
 
|-
 
|-
 
| <tt>start</tt> || Start timestamp for readout || string || <tt>00:00</tt> ||
 
| <tt>start</tt> || Start timestamp for readout || string || <tt>00:00</tt> ||
<tt>YYYY-mm-dd HH:ii:ss<br />seconds since 1970<br />[http://php.net/manual/en/datetime.formats.relative.php relative] from now<br />sunrise<ref name="daylight">needs location defined in in <tt>config/config.php</tt></ref></tt>
+
<tt>YYYY-mm-dd HH:ii:ss<br />seconds since 1970<br />[http://php.net/manual/en/datetime.formats.relative.php relative] from now<br />sunrise<ref name="daylight">needs the <tt>location</tt> defined in in <tt>config/config.php</tt></ref></tt>
 
|-
 
|-
 
| <tt>end</tt> || End timestamp for readout || string || <tt>24:00</tt> ||
 
| <tt>end</tt> || End timestamp for readout || string || <tt>24:00</tt> ||

Revision as of 09:31, 28 February 2014

Abstract

An application programming interface (API) is a protocol intended to be used as an interface by software components to communicate with each other." -- Wikipedia:API

The API is implemented as a RESTful API, so it uses HTTP requests to store and read data. Thus, REST uses HTTP for all four CRUD (Create/Read/Update/Delete) operations.

PVLng supports all of them:

  • PUT = create
  • GET = read
  • POST = update
  • DELETE = delete

Data storage

For data storage we have two possibilities:

  • Web front end for the master data, like channels and their relationships
  • HTTP REST API for the operational channel data with HTTP PUT requests

The storage API accepts only one parameter data and routes it to the requested channel.

By default (load live data) system date and time will be used.

The model behind the channel represents the interface to the database.

Data readout

This section describes only the readout of measuring data via API, see the detailed API help for more supported actions.

The data readout from the system must be done with HTTP GET requests.

The readout API analyzes the requests, identifies the channel and returns the extracted data.

The model behind the channel provides a defined interface to query data.

Requested format

The returned content type is detected by the requested file extension

Extension Format Content type
.json JSON (default, if no extension is set) application/json
.csv Semicolon separated values application/csv
.tsv TAB separated values application/tsv
.txt Space separated values
(proposed for single attribute requests)
text/plain

Parameters

All parameters are optional.

Parameter name Description Format default Examples
start Start timestamp for readout string 00:00

YYYY-mm-dd HH:ii:ss
seconds since 1970
relative from now
sunrise[1]

end End timestamp for readout string 24:00

YYYY-mm-dd HH:ii:ss
seconds since 1970
relative from now
sunset[1]

period Example string <empty>

[0-9.]+minutes
[0-9.]+hours
[0-9.]+days
[0-9.]+weeks
[0-9.]+month
[0-9.]+quarters
[0-9.]+years
last[2]
readlast[3]
all

attributes Return channel attributes as 1st data set / line bool[4] 0 Example
full Return all[5] data, not only timestamp and value bool[4] 0 Example
short JSON: Return data as numeric indexed array, not as object with named keys bool[4] 0 Example
  1. 1.0 1.1 needs the location defined in in config/config.php
  2. returns the last reading for selected start-end range, can be empty, if no data in range, also relevant for meter channels
  3. returns the last reading, ignores start-end range
  4. 4.0 4.1 4.2 All of (1|x|yes|on|true) are interpreted case-insensitive as TRUE.
  5. datetime, timestamp, data, min, max, count, timediff, consumption