Weekly Trade Results Summary

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=72b618d2-34c2-4347-8786-111d1cc93ce2&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=72b618d2-34c2-4347-8786-111d1cc93ce2&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "72b618d2-34c2-4347-8786-111d1cc93ce2",
        "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 = "72b618d2-34c2-4347-8786-111d1cc93ce2", // 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: '72b618d2-34c2-4347-8786-111d1cc93ce2', // 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=72b618d2-34c2-4347-8786-111d1cc93ce2&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' => '72b618d2-34c2-4347-8786-111d1cc93ce2', // 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

46
Awarded Availability Price numeric £/MWh

Awarded utilisation price per MWh

64.29
Awarded Utilisation Price numeric £/MWh

Awarded utilisation ceiling price per MWh

3857.34
CMZ Code text nan

Unique Constraint Management Zone code

CMZ_T3B_SWE_0007
Company Name text nan

Flexibility Provider Name

Axle Energy Limited
Earliest End Time text Not provided- Not provided- Not provided-
Earliest Start Time text Not provided- Not provided- Not provided-
Flexibility Product text nan

Main flexibility product

Dynamic
Number of Assets numeric nan

Number of assets in trade

36
Offered Availability Price numeric £/MWh

Offered availability ceiling price per MWh

64.29
Offered Capacity [kW] numeric kW

Offered capacity

46
Offered Utilisation Price numeric £/MWh

Offered utilisation ceiling price per MWh

3857.34
Peak Tendered Capacity [kW] numeric Not provided- Not provided- Not provided-
Technology Type text nan

Technology type of assets in trade

EV charge point
Tendered Ceiling Availability Price numeric £/MWh

Tendered availability ceiling price per MWh

64.94
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

266.4000034
Trade Close Date timestamp nan

Trade closing date

26/12/2023
Trade Open Date timestamp nan

Trade opening date

21/12/2023
Trade Opportunity Delivery End Date timestamp Not provided- Not provided- Not provided-
Trade Opportunity Delivery Start Date timestamp Not provided- Not provided- Not provided-
Trade Opportunity Name text nan

Name of trade opportunity

W/C 01/01/2024 - Dynamic - Hayle/Camborne
Trade Outcome text nan

Outcome of trade, if applicable

Accepted
Trade Window Name text Not provided- Not provided- Not provided-