{
    "@odata.context": "http://localhost/odata/$metadata",
    "value": [
        ...
        {
            "name": "Path_Pipe",
            "kind": "EntitySet",
            "url": "Path_Pipe"
        },
        ...
    ]
}

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
    <edmx:DataServices>
        <Schema Namespace="ABB.Vtrin.OData" xmlns="http://docs.oasis-open.org/odata/ns/edm">
            . . .
            <EntityType Name="Path_Pipe" OpenType="true">
                <Key>
                    <PropertyRef Name="Name" />
                </Key>
                <Property Name="Id" Type="Edm.Guid" Nullable="false" />
                <Property Name="Name" Type="Edm.String" Nullable="false" />
                <Property Name="DisplayName" Type="Edm.String" />
                <Property Name="Parent_navigationIdProperty" Type="Edm.String" Nullable="false" />
                <Property Name="Equipment_navigationIdProperty" Type="Edm.String" Nullable="false" />
                <Property Name="References" Type="Collection(Edm.String)" Nullable="false" />
                <Property Name="Manufacturer" Type="Edm.String" />
                <Property Name="Diameter" Type="Edm.Double" />
                <Property Name="Flow" Type="Edm.Double" />
                <NavigationProperty Name="Parent" Type="ABB.Vtrin.OData.Path" />
                <NavigationProperty Name="Equipment" Type="ABB.Vtrin.OData.Equipment" />
                <Annotation Term="OData.Community.Keys.V1.AlternateKeys">
                    <Collection>
                        <Record Type="OData.Community.Keys.V1.AlternateKey">
                            <PropertyValue Property="Key">
                                <Collection>
                                    <Record Type="OData.Community.Keys.V1.PropertyRef">
                                        <PropertyValue Property="Alias" String="Id" />
                                        <PropertyValue Property="Name" PropertyPath="Id" />
                                    </Record>
                                </Collection>
                            </PropertyValue>
                        </Record>
                    </Collection>
                </Annotation>
            </EntityType>
            . . .
        </Schema>
    </edmx:DataServices>
</edmx:Edmx>

{
    "@odata.context": "http://localhost/odata/$metadata#Path_Pipe",
    "value": [
        {
            "@odata.id": "Path_Pipe('Example%20site.Water%20transfer%20system.Flowback%20pipe')",
            "@odata.editLink": "Path_Pipe('Example%20site.Water%20transfer%20system.Flowback%20pipe')",
            "Id": "bb3784ae-dcfe-434e-8a5b-46dfc322c718",
            "Name": "Example site.Water transfer system.Flowback pipe",
            "DisplayName": "Flowback pipe",
            "References": [],
            "Manufacturer": "Pumps & Pipes Inc.",
            "Diameter": 10.0,
            "Flow": 100.0,
            "[email protected]": "Path('Example%20site.Water%20transfer%20system')",
            "[email protected]": "Equipment('Pipe')"
        },
        {
            "@odata.id": "Path_Pipe('Example%20site.Water%20transfer%20system.Pipe')",
            "@odata.editLink": "Path_Pipe('Example%20site.Water%20transfer%20system.Pipe')",
            "Id": "1941ca91-3547-4da6-b404-cc2fc1592971",
            "Name": "Example site.Water transfer system.Pipe",
            "DisplayName": "Pipe",
            "References": [],
            "Manufacturer": "Pumps & Pipes Inc.",
            "Diameter": 20.0,
            "Flow": 0.0,
            "[email protected]": "Path('Example%20site.Water%20transfer%20system')",
            "[email protected]": "Equipment('Pipe')"
        }
    ]
}

{
    "@odata.context": "https://10.58.44.108/odata/$metadata#Path_Pipe/$entity",
    "@odata.id": "Path_Pipe('Example%20site.Water%20transfer%20system.Pipe')",
    "@odata.editLink": "Path_Pipe('Example%20site.Water%20transfer%20system.Pipe')",
    "Id": "1941ca91-3547-4da6-b404-cc2fc1592971",
    "Name": "Example site.Water transfer system.Pipe",
    "DisplayName": "Pipe",
    "References": [],
    "Manufacturer": "Pumps & Pipes Inc.",
    "Diameter": 20.0,
    "Flow": 0.0,
    "[email protected]": "Path('Example%20site.Water%20transfer%20system')",
    "[email protected]": "Equipment('Pipe')"
}

POST http://localhost/odata/Path_Pipe
{
    "Name": "Factory.Pipes.Drain Pipe",
    "Diameter": 15,
    "Manufacturer": "Pumps & Pipes Inc."
}

{
    "@odata.context": "https://localhost/odata/$metadata#Path_Pipe/$entity",
    "@odata.id": "Path_Pipe('Factory.Pipes.Drain%20Pipe')",
    "@odata.editLink": "Path_Pipe('Factory.Pipes.Drain%20Pipe')",
    "Id": "b79a9fe9-94f8-4e51-b765-60496de8cca5",
    "Name": "Factory.Pipes.Drain Pipe",
    "DisplayName": "Drain Pipe",
    "References": [],
    "Diameter": 15.0,
    "Flow": 0.0,
    "Manufacturer": "Pumps & Pipes Inc.",
    "[email protected]": "Path('Factory.Pipes')",
    "[email protected]": "Equipment('Pipe')"
}

PATCH http://localhost/odata/Path_Pipe('Factory.Pipes.Drain Pipe')
{
    "DisplayName": "Pipe 1"
}

{
    "@odata.context": "https://localhost/odata/$metadata#Path_Pipe/$entity",
    "@odata.id": "Path_Pipe('Factory.Pipes.Pipe%201')",
    "@odata.editLink": "Path_Pipe('Factory.Pipes.Pipe%201')",
    "Id": "b79a9fe9-94f8-4e51-b765-60496de8cca5",
    "Name": "Factory.Pipes.Pipe 1",
    "DisplayName": "Pipe 1",
    "References": [],
    "Diameter": 15.0,
    "Flow": 0.0,
    "Manufacturer": "Pumps & Pipes Inc.",
    "[email protected]": "Path('Factory.Pipes')",
    "[email protected]": "Equipment('Pipe')"
}

PATCH http://localhost/odata/Path_Pipe?$filter=Parent/Name eq 'Factory.Pipes'
{
    "Diameter": 12
}

{
    "@odata.context": "https://localhost/odata/$metadata#Path_Pipe",
    "value": [
        {
            "@odata.id": "Path_Pipe('Factory.Pipes.Astra')",
            "@odata.editLink": "Path_Pipe('Factory.Pipes.Astra')",
            "Id": "9f12e4e9-3215-4be8-b9dc-23e139f503b4",
            "Name": "Factory.Pipes.Astra",
            "DisplayName": "Astra",
            "References": [],
            "Diameter": 12.0,
            "Flow": 0.0,
            "Manufacturer": "Seegson",
            "[email protected]": "Path('Factory.Pipes')",
            "[email protected]": "Equipment('Pipe')"
        },
        {
            "@odata.id": "Path_Pipe('Factory.Pipes.Pipe%201')",
            "@odata.editLink": "Path_Pipe('Factory.Pipes.Pipe%201')",
            "Id": "b79a9fe9-94f8-4e51-b765-60496de8cca5",
            "Name": "Factory.Pipes.Pipe 1",
            "DisplayName": "Pipe 1",
            "References": [],
            "Diameter": 12.0,
            "Flow": 0.0,
            "Manufacturer": "Pumps & Pipes Inc.",
            "[email protected]": "Path('Factory.Pipes')",
            "[email protected]": "Equipment('Pipe')"
        }
    ]
}

DELETE http://localhost/odata/Path_Pipe('Factory.Pumps.Pipe 2')

DELETE  http://localhost/odata/Path_Pipe?$filter=Manufacturer eq 'Pumps %26 Pipes Inc.'

POST http://localhost/odata/WriteGraphData()
{
	"classname": "EquipmentHistory",
	"XValues": ["2020-03-02T13:00:00Z", "2020-03-02T14:00:00Z"],
	"YValues": [1500, 2000],
	"Statuses": ["OK", "OK"],
	"wherestring": "Path=? AND Property=?",
	"whereargs": ["Example site.Water transfer system.Tank area.Target tank", "Level"]
}

{
    "@odata.context": "http://localhost/odata/$metadata#Collection(ABB.Vtrin.OData.WriteGraphDataResultType)",
    "value": [
        {
            "xvalue": "26/11/2018 7.34.47",
            "result": "Not found"
        }
    ]
}

http://localhost/odata/ReplaceGraphDataRange()
{
	"classname": "EquipmentHistory",
	"startx" : "2020-03-02T12:00:00Z",
	"endx" : "2020-03-02T15:00:00Z",
	"XValues": ["2020-03-02T12:00:00Z", "2020-03-02T15:00:00Z"],
	"YValues": [2500, 3000],
	"Statuses": ["OK", "OK"],
	"wherestring": "Path=? AND Property=?",
	"whereargs": ["Example site.Water transfer system.Tank area.Target tank", "Level"]
}

{
    "@odata.context": "http://localhost/odata/$metadata#Collection(ABB.Vtrin.OData.WriteGraphDataResultType)",
    "value": [
        {
            "xvalue": "2016-01-04T10:10:00Z",
            "result": "outside range"
        }
    ]

import requests
import json
from requests.exceptions import HTTPError
from datetime import datetime, timedelta
from pathlib import Path
import pprint


# Some functions representing examples for basic use cases of the Vtrin server OData API in Python. It uses an HTTPS connection, so the Vtrin server has to be configured to allow
# plain text passwords.
# Also some TODO:s in this code have to be modified for this to work.


class ConnectionInformation():
   def __init__(self,
               session,
               address):
      self.session = session
      self.address = address


def WriteGraphData(connectionInfo):

   print();
   print("================");
   print("Starting write graph data example");

   linkToServer = f"https://{connectionInfo.address}/odata/WriteGraphData()"

   # First writing one datapoint
   data = {
      "classname": "EquipmentHistory",
      # TODO: Replace dates below with dates (Eg. current date) to where data can be written
      "XValues": ["2019-05-26T11:00:00Z"],
      "YValues": ["5"],
      "Statuses": ["OK"],
      "wherestring": "Path=? AND Property=?",
      # TODO: Replacce TESTSERVER with your computername
      "whereargs": ["ABB.System Monitoring.TESTSERVER.Disks.C:", "Load"]
   }

   # Converting to JSON
   data = json.dumps(data)

   try:
      headers = {"Content-Type": "application/json"}
      response = connectionInfo.session.post(linkToServer, data=data, headers=headers)

   # If the response was successful, no exception will be raised
      response.raise_for_status()
   except requests.HTTPError as e:
      print(f'https error occurred: {e}')
   else:
      pprint.pprint(f"Write was successful! {response}")



def FetchGraphData(connectionInfo):

   print();
   print("================");
   print("Starting fetch graph data example");


   linkToServer = f"https://{connectionInfo.address}/odata/"

   # Creating the data
   className = "EquipmentHistory";
   xProperty = "Time";
   yProperty = "Value";
   filter = "";
   # TODO: Replace dates below with dates (Eg. current date) from where data can be found
   startx = "2018-09-01T00:00:00Z";
   endx = "2018-09-06T00:00:00Z";
   whereString = "Path=%3F AND Property=%3F";
   # TODO: Replacce TESTSERVER with your computername
   whereStringArgs = ["ABB.System Monitoring.TESTSERVER.Disks.C:", "Load"];
   xPixels = 0
   yPixels = 0

   # Building query
   query = linkToServer + f"FetchGraphData(classname='{className}', xproperty='{xProperty}', yproperty='{yProperty}', startx='{startx}', endx='{endx}', wherestring='{whereString}', whereargs={whereStringArgs})"

   try:
      response = connectionInfo.session.get(query)

      # If the response was successful, no exception will be raised
      response.raise_for_status()
   except requests.HTTPError as e:
      print(f'https error occurred: {e}')
   else:
      # Fetches X values from response
      xValues = json.loads(response.content)['value'][0]['XValues']

      pprint.pprint(f"X values: {xValues.__len__()}")


def IterateAndFilterExample(connectionInfo):

   print();
   print("================");
   print("Starting iterate and filter example");

   linkToServer = f"https://{connectionInfo.address}/odata/"
   query = linkToServer + f"UIUnit?$filter=Id eq 'Ah'"

   try:
      response = connectionInfo.session.get(query)

      # If the response was successful, no exception will be raised
      response.raise_for_status()
   except requests.HTTPError as e:
      print(f'https error occurred: {e}')
   else:
      pprint.pprint(json.loads(response.content))




def ClientDrivenPagingExample(connectionInfo):

   print();
   print("================");
   print("Starting client driven paging example");


   linkToServer = f"https://{connectionInfo.address}/odata/"
   query = linkToServer + f"UIUnit?$skip=1&$top=1"

   try:
      response = connectionInfo.session.get(query)

      # If the response was successful, no exception will be raised
      response.raise_for_status()
   except requests.HTTPError as e:
      print(f'https error occurred: {e}')
   else:
      pprint.pprint(json.loads(response.content))



def OrderByExample(connectionInfo):

   print();
   print("================");
   print("Starting order by example");


   linkToServer = f"https://{connectionInfo.address}/odata/"
   query = linkToServer + f"Variable?$top=5&$orderby=Name desc"

   try:
      response = connectionInfo.session.get(query)

      # If the response was successful, no exception will be raised
      response.raise_for_status()
   except requests.HTTPError as e:
      print(f'https error occurred: {e}')
   else:
      pprint.pprint(json.loads(response.content))


def main():

   # Related to the connection and authentication
   print("Enter server ip-address:")
   address = input()
   print(f"Enter username for {address}:")
   username = input()
   print("Enter password:")
   password = input()

   # A session with which https requests will be made
   session = requests.Session()

   # Creating a object containing information about connection
   connectionInfo = ConnectionInformation(session, address)

   # Adding uathentication to session
   connectionInfo.session.auth = (username, password)

   # For own servers verification is recommended
   # TODO: Change certificate path to server certificate path
   path_to_cert = Path("C:\\PATH TO CERT\\CERT.crt")
   connectionInfo.session.verify = path_to_cert


   # Test functions
   WriteGraphData(connectionInfo)
   FetchGraphData(connectionInfo)
   IterateAndFilterExample(connectionInfo)
   ClientDrivenPagingExample(connectionInfo)
   OrderByExample(connectionInfo)

if __name__ == "__main__":
   main()

#Install packages
#Install packages
install.packages('httr')
install.packages('rjson')

# The code is best run in R studio, as it seems to have access to Windows Certificate Store which helps in allowing HTTPS connections

library('httr')
library('rjson')

username = "myusername"
password = "mypassword"
address = "https://testserver/odata/"


# Function performing the fetching
read_info <- function(url){
  response <- GET(url, authenticate(username, password, type="basic"))
  return(content(response, "text"))
}

# Converts request response to JSON format
result_to_json <- function(string){
  return(fromJSON(string, flatten = TRUE))
}

# Converts JSON to a data frame
json_to_df <- function(json){
  return(as.data.frame(json))
}


# Function that concatenates the complete address
complete_address <- function(query){
  return(paste(address, query, sep=""))
}


# Iterate and filter example (spaces have to be written in hexadecimal i.e. %20)
filtered_data <- read_info(complete_address("UIUnit?$filter=Id%20eq%20'Ah'"))
filtered_data_json <- result_to_json(filtered_data)


# Order-by example
ordered_data <- read_info(complete_address("Variable?$top=100&$orderby=Name desc"))
ordered_data_json <- result_to_json(ordered_data)
ordered_data_df <- json_to_df(ordered_data_json)


# Client driven paging example
paged_data <- read_info(complete_address("UIUnit?$skip=1&$top=1"))
paged_data_json <- result_to_json(paged_data)
paged_data_df <- json_to_df(paged_data_json)


# Fetching historical data from the database
historical_data <- read_info(complete_address('FetchGraphData(classname=\'ProcessHistory\',wherestring=\'Path=%3F%20AND%20Property=%3F\',whereargs=[\'ABB.System Monitoring.TESTSERVER.Disks.C:\',\'Load\'],endx=\'2019-12-27T18:59:00Z\')'))
historical_data_json <- result_to_json(historical_data)
# Inserting all relevant values to a data frame
x <- historical_data_json['value'][[1]]['XValues']
y <- historical_data_json['value'][[1]]['YValues']
s <- historical_data_json['value'][[1]]['Statuses']

historical_data_df <- data.frame(x[[1]], y[[1]],  s[[1]])
names(historical_data_df)[1] <- "X Values"
names(historical_data_df)[2] <- "Y values"
names(historical_data_df)[3] <- "Statuses"

using ABB.Vtrin.OData;
using System;
using System.Text;
using System.Threading.Tasks;
using System.Net;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Net.Http.Formatting;
using System.Xml;
using Newtonsoft.Json;

/// <summary>
/// Some functions representing examples for basic use cases of the Vtrin server OData API in C#. It uses an HTTPS connection, so the Vtrin server has to be configured to allow
/// plain text passwords.
/// Also some TODO:s in this code have to be modified for this to work.
/// </summary>


namespace ABBODataExamples
{

   class Example
   {
      // This method shows how we use the generated proxy class to iterate and filter with the OData system query option $filter, which is mapped to LINQ Where.
      public static void IterateAndFilterExample(string address)
      {

         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting iterate and filter example");

         string query = address + "/UIUnit?$filter=Id eq 'Ah'";

         Connection.GetContentAsync(query).GetAwaiter().GetResult();

      }


      // This method shows how we use the generated proxy class to order with the OData system query option $orderby, which is mapped to LINQ Orderby.
      public static void OrderByExample(string address)
      {

         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting order by example");

         string query = address + "UIUnit?$skip=1&$top=1";

         Connection.GetContentAsync(query).GetAwaiter().GetResult();

      }


      // This method shows how we use the generated proxy class to do client driven paging with the OData system query options $skip and $top, which is mapped to LINQ Skip and Take.
      public static void ClientDrivenPagingExample(string address)
      {

         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting client driven paging example");

         string query = address + "Variable?$top=5&$orderby=Name desc";

         Connection.GetContentAsync(query).GetAwaiter().GetResult();
      }

      public static void FetchGraphDataExample(string address)
      {
         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting fetch graph data example");


         // Creating the data
         string className = "EquipmentHistory";
         string xProperty = "Time";
         string yProperty = "Value";
         // TODO: Replace dates below with dates (Eg. current date) to where data can be found
         string startx = "2019-06-10T00:00:00Z";
         string endx = "2019-06-18T00:00:00Z";
         string whereString = "Path=%3F AND Property=%3F";
         // TODO: Replacce TESTSERVER with your computername
         string whereStringArgs = "['ABB.System Monitoring.TESTSERVER.Disks.C:', 'Load']";

         string query = address + "FetchGraphData(classname='"+ className + "', xproperty='" + xProperty + "', yproperty='" + yProperty + "', startx='" + startx + "', endx='" + endx + "', wherestring='" + whereString + "', whereargs=" + whereStringArgs.ToString() + ")";

         Connection.GetContentAsync(query).GetAwaiter().GetResult();

      }
   }
   class Connection
   {
      public static System.String username;
      public static System.String password;

      public static async Task GetContentAsync(string address)
      {

         try
         {
            // Starting the  connection and inputting necessary information
            HttpClient httpClient = new HttpClient();

            httpClient.BaseAddress = new Uri(address);
            httpClient.DefaultRequestHeaders.Accept.Clear();
            httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
            String encoded = System.Convert.ToBase64String(System.Text.Encoding.GetEncoding("ISO-8859-1").GetBytes(username + ":" + password));
            httpClient.DefaultRequestHeaders.Add("Authorization", "Basic " + encoded);

            HttpResponseMessage response = await httpClient.GetAsync(httpClient.BaseAddress);


            if (response.IsSuccessStatusCode)
            {
               // Fetching content and converting to Json
               string result = await response.Content.ReadAsStringAsync();
               var json = JsonConvert.DeserializeObject<object>(result);
               Console.WriteLine(json);
            }
            else
            {
               Console.WriteLine("Connection status code " + response.StatusCode);
            }

         }
         catch
         {
            Console.WriteLine("Connection error!");
         }
      }

   }




   class LowerLevelExampleForWiki
   {
      public static void Main(string[] args)
      {
         Console.WriteLine("Enter server ip - address:");
         System.String ip = Console.ReadLine();
         string address = "https://" + ip + "/odata";

         Console.WriteLine("Enter username for " + address + ":");
         Connection.username = Console.ReadLine();

         Console.WriteLine("Enter password:");
         Connection.password = Console.ReadLine();

         Example.IterateAndFilterExample(address);
         Example.OrderByExample(address);
         Example.ClientDrivenPagingExample(address);
         Example.FetchGraphDataExample(address);
         Console.ReadLine();
      }

   }
}

//See why deprecated from AHL-936
using ABB.Vtrin.OData;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

/// <summary>
/// Some functions representing examples for basic use cases of the Vtrin server OData API in C# using the Linq library. It uses an HTTPS connection, so the Vtrin server has to be configured to allow
/// plain text passwords.
/// Also some TODO:s in this code have to be modified for this to work.
///
/// This example requires OData v4 Client Code Generator from https://marketplace.visualstudio.com/items?itemName=bingl.ODatav4ClientCodeGenerator. It is only available for Visual Studio 2015 and 2017.
/// </summary>

namespace ABBODataExamples
{
   class Example
   {

      // This method shows how we use the generated proxy class to iterate and filter with the OData system query option $filter, which is mapped to LINQ Where.
      public static void IterateAndFilterExample(DefaultContainer container)
      {

         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting iterate and filter example");


         // Prepearing fetch
         var uiUnitQuery = container.UIUnit;

         // Server filtering using the query option $filter. This is done by using Linq's Where method.
         var filteredUnits = uiUnitQuery.Where(unit => unit.Id.Equals("Ah"));

         foreach(UIUnit unit in filteredUnits) Console.WriteLine("Filtering with method 1: " + unit.LongName);

         // It can also be done this way
         filteredUnits = from unit in uiUnitQuery
                         where unit.Id.Equals("Ah")
                         select unit;

         foreach (UIUnit unit in filteredUnits) Console.WriteLine("Filtering with method 2: " + unit.LongName);

      }


      // This method shows how we use the generated proxy class to order with the OData system query option $orderby, which is mapped to LINQ Orderby.
      public static void OrderByExample(DefaultContainer container)
      {

         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting order by example");

         // Unordered as reference
         var unOrderedPaths = container.Path;

         // order with this ...
         var orderedPaths = container.Path.OrderByDescending(path => path.DisplayName);

         Console.Write("Unordered: "); foreach (Path path in unOrderedPaths.Take(5)) Console.Write(" " + path.DisplayName + ","); Console.WriteLine("...");
         Console.Write("Ordered: "); foreach (Path path in orderedPaths.Take(5)) Console.Write(" " + path.DisplayName + ","); Console.WriteLine("...");

      }


      // This method shows how we use the generated proxy class to do client driven paging with the OData system query options $skip and $top, which is mapped to LINQ Skip and Take.
      public static void ClientDrivenPagingExample(DefaultContainer container)
      {

         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting client driven paging example");

         // Get the first unit like this ...
         var firstUnit = (from unit in container.UIUnit
                          select unit).Take(1);

         foreach (UIUnit unit in firstUnit) Console.WriteLine("Here we only take the first unit: " + unit.LongName);

         // Another way of getting a unit ...
         var secondUnit = container.UIUnit.Skip(1).Take(1);

         foreach (UIUnit unit in secondUnit) Console.WriteLine("Here we only take the second unit: " + unit.LongName);
      }

      public static void FetchGraphDataExample(DefaultContainer container)
      {
         Console.WriteLine();
         Console.WriteLine("================");
         Console.WriteLine("Starting fetch graph data example");


         // Creating the data
         string className = "EquipmentHistory";
         string xProperty = "Time";
         string yproperty = "Value";
         string filter = "";
         // TODO: Replace dates below with dates (Eg. current date) to where data can be found
         string startx = "2019-06-10T00:00:00Z";
         string endx = "2019-06-18T00:00:00Z";
         string whereString = "Path=%3F AND Property=%3F";
         // TODO: Replacce TESTSERVER with your computername
         string[] whereStringArgs = { "ABB.System Monitoring.TESTSERVER.Disks.C:", "Load" };

         var graphDataQuery = container.FetchGraphData(className, whereString, whereStringArgs, endx, startx, xProperty, yproperty, filter, RETURN_FORMAT.ALL, RETURN_FORMAT.ALL);

         // Extracting the values from response
         var result = graphDataQuery.GetValue();
         Console.Write("X values: "); foreach(var x in result.XValues.Take(5)) Console.Write( " " + x.TimeOfDay + ","); Console.WriteLine("...");
         Console.Write("Y values: "); foreach (var y in result.YValues.Take(5)) Console.Write(" " + y + ","); Console.WriteLine("...");
         Console.Write("Status values formated: "); foreach (var s in result.StatusesFormated.Take(5)) Console.Write(" " + s + ","); Console.Write("...");
      }

   }


   class Program {

      public static void Main(string[] args)
      {
         DefaultContainer container = new DefaultContainer(new Uri("http://testserver/odata/"));

         Example.IterateAndFilterExample(container);
         Example.OrderByExample(container);
         Example.ClientDrivenPagingExample(container);
         Example.FetchGraphDataExample(container);
         Console.ReadLine();
      }

   }
}

let
	code_line_1 remember to end a statement with a comma
	code_line_2 remember to end a statement with a comma
	etc no comma at the last line
	in
	the_final_output

let
  Q_START = "'",
  Q_END = "'",
  token_comma = ",",
  token_NOTHING = "",

// all 'classnames' point to 'ProcessHistory'
classnames = "["
& Q_START & "ProcessHistory" & Q_END & token_comma /* 1 */
& Q_START & "ProcessHistory" & Q_END & token_comma
& Q_START & "ProcessHistory" & Q_END & token_comma
& Q_START & "ProcessHistory" & Q_END & token_comma
& Q_START & "ProcessHistory" & Q_END & token_comma /* 5 */
& Q_START & "ProcessHistory" & Q_END & token_comma
& Q_START & "ProcessHistory" & Q_END & token_comma
& Q_START & "ProcessHistory" & Q_END & token_comma
& Q_START & "ProcessHistory" & Q_END & token_comma
& Q_START & "ProcessHistory" & Q_END & token_comma /* 10 */
& Q_START & "ProcessHistory" & Q_END
& "]",

// START: 2021-01-24
startx = Q_START & "2021-01-12T06:00:00Z" & Q_END ,

// END: 2021-01-25
endx = Q_START & "2021-01-29T19:00:00Z" & Q_END ,

// filter by Variable and History
wherestrings = "["
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma /* 1 */
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma /* 5 */
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma
& Q_START & "Variable=%3F AND History=%3F" & Q_END & token_comma /* 10 */
& Q_START & "Variable=%3F AND History=%3F" & Q_END
& "]",

// Variables=SYS_CPU0_Time,SYS_CPU2_Time,SYS_CPU3_Time  History is 'CurrentHistory'
whereargs = "["
& "'SYS_CPU0_Time','CurrentHistory'" & token_comma /* 1 */
& "'SYS_CPU2_Time','CurrentHistory'" & token_comma
& "'SYS_CPU3_Time','CurrentHistory'" & token_comma
& "'SYS_CPU_TotalTime','CurrentHistory'"  & token_comma
& "'SYS_CPU_TotalTime_OPC','CurrentHistory'"  & token_comma /* 5 */
& "'SYS_CVMC_CPU','CurrentHistory'"  & token_comma
& "'SYS_CVMC_CPU_OPC','CurrentHistory'"  & token_comma
& "'SYS_EcCtsServer_CPU','CurrentHistory'"  & token_comma
& "'SYS_NETSERVER_CPU','CurrentHistory'"  & token_comma
& "'SYS_TRANSFORMATOR_CPU','CurrentHistory'"  & token_comma /* 10 */
& "'SYS_VTRIN_CPU','CurrentHistory'"
& "]",

// 'Time' for all variables
xpropertys = "["
& Q_START & "Time" & Q_END & token_comma /* 1 */
& Q_START & "Time" & Q_END & token_comma
& Q_START & "Time" & Q_END & token_comma
& Q_START & "Time" & Q_END & token_comma
& Q_START & "Time" & Q_END & token_comma /* 5 */
& Q_START & "Time" & Q_END & token_comma
& Q_START & "Time" & Q_END & token_comma
& Q_START & "Time" & Q_END & token_comma
& Q_START & "Time" & Q_END & token_comma
& Q_START & "Time" & Q_END & token_comma /* 10 */
& Q_START & "Time" & Q_END
& "]",

// 'Value' for all variables
ypropertys = "["
& Q_START & "Value" & Q_END & token_comma /* 1 */
& Q_START & "Value" & Q_END & token_comma
& Q_START & "Value" & Q_END & token_comma
& Q_START & "Value" & Q_END & token_comma
& Q_START & "Value" & Q_END & token_comma /* 5 */
& Q_START & "Value" & Q_END & token_comma
& Q_START & "Value" & Q_END & token_comma
& Q_START & "Value" & Q_END & token_comma
& Q_START & "Value" & Q_END & token_comma
& Q_START & "Value" & Q_END & token_comma /* 10 */
& Q_START & "Value" & Q_END
& "]",

// Apply filter 'AVG1hour' to all variables
queryfilters= "["
& Q_START & "AVG1hour" & Q_END & token_comma /* 1 */
& Q_START & "AVG1hour" & Q_END & token_comma
& Q_START & "AVG1hour" & Q_END & token_comma
& Q_START & "AVG1hour" & Q_END & token_comma
& Q_START & "AVG1hour" & Q_END & token_comma /* 5 */
& Q_START & "AVG1hour" & Q_END & token_comma
& Q_START & "AVG1hour" & Q_END & token_comma
& Q_START & "AVG1hour" & Q_END & token_comma
& Q_START & "AVG1hour" & Q_END & token_comma
& Q_START & "AVG1hour" & Q_END & token_comma /* 10 */
& Q_START & "AVG1hour" & Q_END
& "]",

// yformat is FORMATED (FORMATED,UNFORMATED,ALL)
yformat = "ABB.Vtrin.OData.RETURN_FORMAT'FORMATED'" ,

// statusformat is FORMATED (FORMATED,UNFORMATED,ALL)
statusformat = "ABB.Vtrin.OData.RETURN_FORMAT'FORMATED'",

// empty
FINAL_FILTER = "",

// data is read from "hepsu.ankkalinna.fi.abb.com"
site_address = "https://hepsu.ankkalinna.fi.abb.com/odata",

relative_path = "/" & "FetchGraphDataMerge" & "("
  & "classnames=" & classnames
  & token_comma
  & "startx=" & startx
  & token_comma
  & "endx=" & endx
  & token_comma
  & "wherestrings=" & wherestrings
  & token_comma
  & "whereargs=" & whereargs
  & token_comma
  & "xpropertys=" & xpropertys
  & token_comma
  & "ypropertys=" & ypropertys
  & token_comma
  & "queryfilters=" & queryfilters
  & token_comma
  & "yformat=" & yformat
  & token_comma
  & "statusformat=" & statusformat
  & ")",

//
  source = Web.Contents(site_address,
  [
    RelativePath = relative_path
  ]
  ),
  Json_output = Json.Document(source),

#"Converted to Table" = Record.ToTable(Json_output),
  Value = #"Converted to Table"{1}[Value],
  Value1 = Value{0},
  // ------------------
  XValues = Value1[XValues],
  YValuesFormated = Value1[YValuesFormated],
  StatusesFormated = Value1[StatusesFormated],

// ------------------
  #"yValuesDecimalSeparator" = List.Transform(#"YValuesFormated",each Text.Replace(_,",",".")),
  #"yValuesListSeparator" = List.Transform(#"yValuesDecimalSeparator", each Text.Replace(_,";",",")),
  #"yValues1" = List.Transform(#"yValuesListSeparator", each Text.Replace(_,"{","")),
  #"yValues2" = List.Transform(#"yValues1", each Text.Replace(_,"}","")),
  #"yTableInitial" = Table.FromList(#"yValues2"),
  #"yTableIndex" = Table.AddIndexColumn(#"yTableInitial", "Index", 1, 1),
  #"yTableOrdered" = Table.ReorderColumns(#"yTableIndex",{
    "Index",
    "Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10",
    "Column11"
    }),
  #"yTableRenamedCols" = Table.RenameColumns(#"yTableOrdered",{
    {"Column1", "CPU_0"},
    {"Column2", "CPU_2"},
    {"Column3", "CPU_3"},
    {"Column4", "CPU_TotalTime"},
    {"Column5", "SYS_CPU_TotalTime_OPC"},
    {"Column6", "SYS_CVMC_CPU"},
    {"Column7", "SYS_CVMC_CPU_OPC"},
    {"Column8", "SYS_EcCtsServer_CPU"},
    {"Column9", "SYS_NETSERVER_CPU"},
    {"Column10", "SYS_TRANSFORMATOR_CPU"},
    {"Column11", "SYS_VTRIN_CPU"}
    }),

// --------------------
#"xTable1" = Table.FromList(#"XValues", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"xTable2" = Table.AddColumn(#"xTable1","KEY_Time_UTC", each [Column1]),
// Note field KEY_Time_UTC. It is a copy of the original 'Time' value before 'datetime' conversion of applied to 'Time'.
// You will need KEY_Time_UTC, if you wish to combine multiple ODATA queries.
// You can not use 'Time' for joining: 'Time' field will eventually contain duplicate values, due to Daylight Saving Time.
#"xTableInitial" = Table.TransformColumnTypes(#"xTable2",{{"Column1", type datetime}}),
#"xTableIndex" = Table.AddIndexColumn(#"xTableInitial", "Index", 1, 1),
#"xTableOrdered" = Table.ReorderColumns(#"xTableIndex",{"Index", "Column1"}),
#"xTableRenamedCols" = Table.RenameColumns(#"xTableOrdered",{{"Column1", "Time"}}),

// ----------------------------------------------------
  #"JoinedDataTable" = Table.Join(#"xTableRenamedCols","Index", #"yTableRenamedCols", "Index"),

// ----------------------------------------------------
  Output = Table.RemoveColumns(#"JoinedDataTable",{"Index"})  /* 'Index' column is not needed anymore */

in
  Output