Contract Volume 2021-07-14 v2
-
Contract Volume 2021-07-14 v2
Index-Linked Contract Volume update 2021.07.14, SPLN-1
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: '46a496df-12af-4dcd-a400-fa16ce1b3317', // 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=46a496df-12af-4dcd-a400-fa16ce1b3317&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()