Trade Results

This resource view is not available at the moment. Click here for more information.

Download resource

Integrate this resource

Access this data via a web API. Further information in the CKAN API guide (opens in new tab).

Endpoints

The Data API can be accessed via the following actions of the CKAN action API.

Create
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_create

Update / Insert
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_upsert

Query
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search

Querying
First 5 results:
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=d2eb8939-1509-44b8-8ab2-108f80aa4d14&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=d2eb8939-1509-44b8-8ab2-108f80aa4d14&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "d2eb8939-1509-44b8-8ab2-108f80aa4d14",
        "limit": 5,
        "q": "jones"
      }'
  
  
    using System;
    using System.Net.Http;
    using System.Text;
    using System.Text.Json;
    using System.Threading.Tasks;

    var data = new {
      resource_id = "d2eb8939-1509-44b8-8ab2-108f80aa4d14", // the resource id
      limit = 5, // get 5 results
      q = "jones" // query for 'jones'
    };

    var url = "https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search";

    using var client = new HttpClient();
    var json = JsonSerializer.Serialize(data);
    var content = new StringContent(json, Encoding.UTF8, "application/json");

    try {
      var response = await client.PostAsync(url, content);
      response.EnsureSuccessStatusCode();
      var responseBody = await response.Content.ReadAsStringAsync();
      var result = JsonSerializer.Deserialize<JsonElement>(responseBody);
      Console.WriteLine($"Total results found: {result.GetProperty("result").GetProperty("total")}");
    } catch (HttpRequestException e) {
      Console.WriteLine($"Error fetching data: {e.Message}");
    }
  
  
    const data = {
      resource_id: 'd2eb8939-1509-44b8-8ab2-108f80aa4d14', // the resource id
      limit: 5, // get 5 results
      q: 'jones' // query for 'jones'
    };

    const url = new URL('https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search');
    Object.keys(data).forEach(key => url.searchParams.append(key, data[key]));

    fetch(url)
      .then(response => response.json())
      .then(result => {
        console.log('Total results found: ' + result.result.total);
      })
      .catch(error => {
        console.error('Error fetching data:', error);
      });
  
  
    import urllib.request
    import urllib.error
    import json

    url = 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=d2eb8939-1509-44b8-8ab2-108f80aa4d14&limit=5&q=title:jones'  
    
    try:
        with urllib.request.urlopen(url) as response:
            data = json.loads(response.read().decode('utf-8'))
            print(f"Total results found: {data['result']['total']}")
    except urllib.error.URLError as e:
        print(f"Error fetching data: {e}")
  
  
    $data = [
      'resource_id' => 'd2eb8939-1509-44b8-8ab2-108f80aa4d14', // the resource id
      'limit' => 5, // get 5 results
      'q' => 'jones' // query for 'jones'
    ];

    $url = 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search';

    $ch = curl_init($url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data));
    curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);

    $response = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);

    if ($httpCode === 200) {
      $result = json_decode($response, true);
      echo "Total results found: " . $result['result']['total'];
    } else {
      echo "Error fetching data: HTTP " . $httpCode;
    }
  

Data Dictionary

Data Dictionary: Column definitions and metadata for this resource
Column Type Label Description Example
Accepted Capacity [kW] numeric kW

Accepted capacity

6
Awarded Availability Price numeric £/MW/h

Awarded utilisation price per MW per hour

64.9
Awarded Utilisation Price numeric £/MWh

Awarded utilisation ceiling price per MWh

3896.3
CMZ Code text nan

Unique Constraint Management Zone code

CMZ_T3B_SWE_0007
Company Name text nan

Flexibility Provider Name

EV DOT ENERGY LTD
Delivery End Date timestamp nan

Delivery window end date

31/10/2023
Delivery End Time text nan

Delivery window end time

17:00:00
Delivery Start Date timestamp nan

Delivery window start date

01/10/2023
Delivery Start Time text nan

Delivery window start time

16:30:00
Flexibility Product text nan

Main flexibility product

Scheduled Availability, Operational Utilisation - Day Ahead Notice
Number of Assets numeric nan

Number of assets in trade

5
Offered Availability Price numeric £/MW/h

Offered availability ceiling price per MW per hour

61.66
Offered Capacity [kW] numeric kW

Offered capacity

6
Offered Utilisation Price numeric £/MWh

Offered utilisation ceiling price per MWh

3702
Service Days text nan

Days of the week with flexibility services requriements

Monday,Tuesday,Wednesday,Thursday,Saturday
Technology Type text nan

Technology type of assets in trade

EV charge point
Tendered Capacity [kW] numeric kW

Tendered capacity required

4000
Tendered Ceiling Availability Price numeric £/MW/h

Tendered availability ceiling price per MW per hour

64.9
Tendered Ceiling Utilisation Price numeric £/MWh

Tendered utilisation ceiling price per MWh

3896.3
Total Asset Installed Capacity numeric kW

Total installed capacity across assets

35
Trade Close Date timestamp nan

Trade closing date

06/08/2023
Trade Open Date timestamp nan

Trade opening date

23/06/2023
Trade Opportunity Name text nan

Name of trade opportunity

T7A - 2023/24 - Scheduled Availability Operational Utilisation Day Ahead Notice - West Bridgford
Trade Outcome text nan

Outcome of trade, if applicable

Accepted
Trade Window Name text nan

Name of the trade window

"October 2023"