Phase 2 FFR Auction BlockOrders Masterdata 2019-2020
Phase 2: FFR auction BlockOrders Masterdata 2019-2020
CKAN Data API
Access resource data via a web API with powerful query support.
Further information in the main CKAN Data API and DataStore documentation.
The Data API can be accessed via the following actions of the CKAN action API.
Query example (first 5 results) |
---|
https://api.neso.energy/api/3/action/datastore_search?resource_id=979329c3-5587-4b08-a900-5520b58b2d8f&limit=5
|
Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "979329c3-5587-4b08-a900-5520b58b2d8f" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = { resource_id: '979329c3-5587-4b08-a900-5520b58b2d8f', // the resource id limit: 5 // get 5 results }; $.ajax({ url: 'https://api.neso.energy/api/3/action/datastore_search', data: data, dataType: 'jsonp', success: function(data) { alert('Total results found: ' + data.result.total) } });
A simple ajax (JSONP) request to the data API using jQuery.
import urllib2 url = 'https://api.neso.energy/api/3/action/datastore_search?resource_id=979329c3-5587-4b08-a900-5520b58b2d8f&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
MarketName
Title | Product name |
---|---|
Type | string |
Description | Product name |
Comment | |
Example | DLH |
Unit |
BiddingLevelName
Title | Product name |
---|---|
Type | string |
Description | Product name |
Comment | |
Example | DLH |
Unit |
MemberName
Title | Company |
---|---|
Type | string |
Description | |
Comment | |
Example | Company name Ltd |
Unit | string |
OrderID
Title | Assigned order number |
---|---|
Type | number |
Description | |
Comment | |
Example | 100000000000000 |
Unit | number |
Portfolio
Title | Unit name |
---|---|
Type | string |
Description | Registered unit number |
Comment | |
Example | AG-XXX1 |
Unit | string |
OrderEntryTime
Title | Order entry |
---|---|
Type | |
Description | |
Comment | |
Example | ESO-103-A |
Unit | number |
OrderEntryUser
Title | Related entry User |
---|---|
Type | string |
Description | |
Comment | |
Example | ESO-103-A |
Unit | number |
SettlementCurrency
Title | SettlementCurrency |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit | £ |
ClearingPrice
Title | Clearing Price |
---|---|
Type | number |
Description | Clearing Price |
Comment | |
Example | 10 |
Unit | £/MW/h |
Price
Title | Offered price |
---|---|
Type | number |
Description | |
Comment | |
Example | 5 |
Unit | £/MW/h |
MAR
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
Status
Title | Status of order |
---|---|
Type | number |
Description | |
Comment | |
Example | Rejected / Accepted |
Unit |
BlockCode
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
BlockCodePRM
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
Paradoxically
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
OrderPeriodID
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
TradeID
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
EFA
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
DeliveryStart
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
DeliveryEnd
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
ExecutedVolume
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
Volume
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
Invalid
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |
Bid Validity
Title | |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit |