NSL-DayAhead-20240416-001

NGESO's Network Transfer Capacity restrictions submitted to Day-ahead and Intraday auctions

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
`https://api.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=0a19cff7-b27f-48cd-a8ee-b99a7ddf2d5e&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "0a19cff7-b27f-48cd-a8ee-b99a7ddf2d5e" LIMIT 5`

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
  resource_id: '0a19cff7-b27f-48cd-a8ee-b99a7ddf2d5e', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.nationalgrideso.com/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.nationalgrideso.com/api/3/action/datastore_search?resource_id=0a19cff7-b27f-48cd-a8ee-b99a7ddf2d5e&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Hourly Time Period (GMT)

Title	Hourly Time Period (GMT)
Type	string
Description	Hourly time period for which restriction applies
Comment	Hourly time period for which restriction applies
Example	22:00 to 23:00
Unit	N/A

Flow (MW) To GB

Title	Flow (MW) To GB
Type	int
Description	Maximum flow in this direction
Comment	Maximum flow in this direction
Example	500
Unit	MW

Flow (MW) From GB

Title	Flow (MW) From GB
Type	int
Description	Maximum flow in this direction
Comment	Maximum flow in this direction
Example	500
Unit	MW

Reason For Reduction

Title	Reason For Reduction
Type	string
Description	Reason for NTC restriction
Comment	Reason for NTC restriction
Example	test reason
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

NSL-DayAhead-20240416-001

CKAN Data API

Data Explorer

Data Explorer

Table Information

Hourly Time Period (GMT)

Flow (MW) To GB

Flow (MW) From GB

Reason For Reduction