Phase 2 FFR Auction ResultSummary Masterdata-2019-2020
Phase 2 FFR Auction ResultSummary 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=8b5fa222-f39f-4eea-9475-728ea8365ff3&limit=5
|
| Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "8b5fa222-f39f-4eea-9475-728ea8365ff3" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = {
resource_id: '8b5fa222-f39f-4eea-9475-728ea8365ff3', // 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=8b5fa222-f39f-4eea-9475-728ea8365ff3&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
Service
| Title | Product name |
|---|---|
| Type | string |
| Description | Product name |
| Comment | |
| Example | DLH |
| Unit |
EFA Date
| Title | Delivery Date |
|---|---|
| Type | datetime |
| Description | Delivery Date |
| Comment | |
| Example | 01/09/2020 |
| Unit | day |
Delivery Start
| Title | Delivery Start |
|---|---|
| Type | datetime |
| Description | Start of delivery date and time |
| Comment | |
| Example | 06/12/2019 23:00:00 |
| Unit | datetime |
Delivery End
| Title | Delivery End |
|---|---|
| Type | datetime |
| Description | End of delivery date and time |
| Comment | |
| Example | 07/12/2019 03:00:00 |
| Unit | datetime |
EFA
| Title | EFA |
|---|---|
| Type | number |
| Description | EFA |
| Comment | |
| Example | 1 |
| Unit | number |
Cleared Volume
| Title | Cleared Volume |
|---|---|
| Type | number |
| Description | Total cleared volume |
| Comment | |
| Example | 100 |
| Unit |
Clearing Price
| Title | Clearing Price |
|---|---|
| Type | number |
| Description | |
| Comment | |
| Example | 10 |
| Unit | number |