Phase 2 FFR Auction LinearOrders Masterdata 2020-2021
Phase 2 FFR Auction LinearOrders Masterdata 2020-2021
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=404a1de1-5fe9-4569-815a-394e83af96eb&limit=5
|
Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "404a1de1-5fe9-4569-815a-394e83af96eb" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = { resource_id: '404a1de1-5fe9-4569-815a-394e83af96eb', // 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=404a1de1-5fe9-4569-815a-394e83af96eb&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
MarketName
Title | Product name |
---|---|
Type | string |
Description | DLH LFS |
Comment | |
Example | DLH |
Unit | string |
BiddingLevelName
Title | Product name |
---|---|
Type | string |
Description | |
Comment | |
Example | DLH |
Unit |
MemberName
Title | Company |
---|---|
Type | string |
Description | Company name |
Comment | |
Example | Company name Ltd |
Unit |
OrderID
Title | Assigned order number |
---|---|
Type | number |
Description | Assigned order number |
Comment | |
Example | 100000000000000 |
Unit | number |
Portfolio
Title | Unit name |
---|---|
Type | string |
Description | |
Comment | |
Example | AG-XXX1 |
Unit | string |
OrderEntryTime
Title | OrderEntryTime |
---|---|
Type | datetime |
Description | |
Comment | |
Example | |
Unit |
OrderEntryUser
Title | OrderEntryUser |
---|---|
Type | string |
Description | |
Comment | |
Example | |
Unit |
SettlementCurrency
Title | SettlementCurrency |
---|---|
Type | |
Description | |
Comment | |
Example | |
Unit | £ |
OrderPeriodID
Title | OrderPeriodID |
---|---|
Type | number |
Description | |
Comment | |
Example | |
Unit |
TradeID
Title | TradeID |
---|---|
Type | number |
Description | |
Comment | |
Example | 100000000006477 |
Unit | number |
EFA
Title | EFA |
---|---|
Type | number |
Description | EFA |
Comment | |
Example | 1 |
Unit | number |
DeliveryStart
Title | DeliveryStart |
---|---|
Type | datetime |
Description | |
Comment | |
Example | 10/01/2020 23:00:00 |
Unit | hours |
DeliveryEnd
Title | DeliveryEnd |
---|---|
Type | |
Description | |
Comment | |
Example | 10/01/2020 23:00:00 |
Unit | datetime |
ExecutedVolume
Title | Volume cleared |
---|---|
Type | number |
Description | volume cleared for given order |
Comment | |
Example | 10 |
Unit | MW |
1P
Title | Price step |
---|---|
Type | |
Description | |
Comment | |
Example | 1 |
Unit | £/MW/h |
1V
Title | Volume step |
---|---|
Type | |
Description | |
Comment | |
Example | 10 |
Unit | MW |
2P
Title | Price step |
---|---|
Type | |
Description | |
Comment | |
Example | 10 |
Unit | £/MW/h |
2V
Title | volume step |
---|---|
Type | number |
Description | |
Comment | |
Example | 10 |
Unit | MW |
3P
Title | Price step |
---|---|
Type | number |
Description | |
Comment | |
Example | 10 |
Unit | £/MW/h |
3V
Title | Volume step |
---|---|
Type | number |
Description | |
Comment | |
Example | 10 |
Unit | MW |
4P
Title | Price Step |
---|---|
Type | |
Description | |
Comment | |
Example | 10 |
Unit | £/MW/h |
4V
Title | Volume Step |
---|---|
Type | |
Description | |
Comment | |
Example | 10 |
Unit | MW |