Historic GTMA Trades Data - Apr 2020 - March 2021
-
Historic GTMA Trades Data - Apr 2020 - March 2021
This file includes all historic GTMA (Grid Trade Master Agreement) trades between April 2020 to March 2021. This data file will be updated on a monthly basis.
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://data.nationalgrideso.com/api/3/action/datastore_search
|
---|---|
Query (via SQL) |
https://data.nationalgrideso.com/api/3/action/datastore_search_sql
|
Query example (first 5 results)
Query example (via SQL statement)
A simple ajax (JSONP) request to the data API using jQuery.
var data = { resource_id: '8e14ae8e-2091-4abc-a2e6-a4b82e5519ab', // the resource id limit: 5 // get 5 results }; $.ajax({ url: 'https://data.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://data.nationalgrideso.com/api/3/action/datastore_search?resource_id=8e14ae8e-2091-4abc-a2e6-a4b82e5519ab&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()