Skip to main content
GET
A year of each supply point's consumption on one line: a column per month, the year's total and the whole of the year before, with where the supply point is a level at a time. A month is every reading taken in it on the site's own clock. A supply point has a line for each year it was read in and the year after, so one that stopped being read still appears, blank.

Headers

Range
string

Limiting and Pagination

Range-Unit
string
default:items

Limiting and Pagination

Prefer
enum<string>

Preference

Available options:
count=none

Query Parameters

supply_point_id
string
supply_point_code
string
supply_point_name
string
commodity_id
string
commodity_name
string
unit_code
string
site_id
string
site_name
string
location_level_1
string
location_level_2
string
location_path
string
asset_id
string
asset_number
string
year
string
jan_consumption
string
feb_consumption
string
mar_consumption
string
apr_consumption
string
may_consumption
string
jun_consumption
string
jul_consumption
string
aug_consumption
string
sep_consumption
string
oct_consumption
string
nov_consumption
string
dec_consumption
string
total_consumption
string
previous_year_consumption
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

apr_consumption
number<numeric>
asset_id
string<uuid>

Note: This is a Foreign Key to asset_contracts.asset_id.

asset_number
string<character varying>
Maximum string length: 80
aug_consumption
number<numeric>
commodity_id
string<uuid>

Note: This is a Foreign Key to commodities.id.

commodity_name
string<character varying>
Maximum string length: 120
dec_consumption
number<numeric>
feb_consumption
number<numeric>
jan_consumption
number<numeric>
jul_consumption
number<numeric>
jun_consumption
number<numeric>
location_level_1
string<text>
location_level_2
string<text>
location_path
string<text>
mar_consumption
number<numeric>
may_consumption
number<numeric>
nov_consumption
number<numeric>
oct_consumption
number<numeric>
previous_year_consumption
number<numeric>
sep_consumption
number<numeric>
site_id
string<uuid>

Note: This is a Foreign Key to entry_currencies.for_site_id.

site_name
string<character varying>
Maximum string length: 200
supply_point_code
string<character varying>
Maximum string length: 60
supply_point_id
string<uuid>

Note: This is a Foreign Key to supply_points.id.

supply_point_name
string<character varying>
Maximum string length: 150
total_consumption
number<numeric>
unit_code
string<character varying>
Maximum string length: 30
year
string<text>