DashboardJsonDataSource Class

A data source that retrieves data stored in JSON format.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v20.2.Core.dll

NuGet Packages: DevExpress.Dashboard.Core, DevExpress.WindowsDesktop.Dashboard.Core

Declaration

C#

public class DashboardJsonDataSource :
    JsonDataSource,
    IDashboardDataSource,
    IDashboardComponent,
    IComponent,
    IDisposable,
    ISupportInitialize,
    ISupportPrefix,
    IDashboardDataSourceInternal,
    IExternalSchemaConsumer,
    IFederationDataProvider

VB.NET

Public Class DashboardJsonDataSource
    Inherits JsonDataSource
    Implements IDashboardDataSource,
               IDashboardComponent,
               IComponent,
               IDisposable,
               ISupportInitialize,
               ISupportPrefix,
               IDashboardDataSourceInternal,
               IExternalSchemaConsumer,
               IFederationDataProvider

Remarks

The DashboardJsonDataSource allows you to extract JSON data from a Web-service endpoint URI, text file, or a string in JSON format.

Important

The DashboardJsonDataSource object requires the open source Newtonsoft.Json library. Install the Newtonsoft.Json NuGet package in Visual Studio.

Design Time

Follow the step-by-step instruction How to create JSON Data Source at design time.

Runtime

1. Create the DashboardJsonDataSource instance with a simple constructor.
2. Use the JsonSource property to specify the JSON data location.
3. Use the RootElement property to specify a root JSON node.
4. Call the Fill method to retrieve data.
5. Add the created data source to the dashboard’s Dashboard.DataSources collection.
6. Assign the created data source to the dashboard item’s DataDashboardItem.DataSource property.

View Example: How to Bind a Dashboard to the JSON Data Source at Runtime

The code sample below illustrates how to retrieve JSON data from different sources:

C#

using DevExpress.DashboardCommon;
using DevExpress.DataAccess.Json;
// ...
public void InitializeDashboard() {
    Dashboard dashboard = new Dashboard();
    DashboardJsonDataSource jsonDataSourceFromWeb = CreateJsonDataSourceFromWeb();
    DashboardJsonDataSource jsonDataSourceFromFile = CreateJsonDataSourceFromFile();
    DashboardJsonDataSource jsonDataSourceFromString = CreateJsonDataSourceFromString();

    dashboard.DataSources.Add(jsonDataSourceFromWeb);
    dashboard.DataSources.Add(jsonDataSourceFromFile);
    dashboard.DataSources.Add(jsonDataSourceFromString);
}

public static DashboardJsonDataSource CreateJsonDataSourceFromWeb()
{
    var jsonDataSource = new DashboardJsonDataSource();
    jsonDataSource.JsonSource = new UriJsonSource(new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json"));
    jsonDataSource.RootElement = "Customers";
    jsonDataSource.Fill();
    return jsonDataSource;
}

public static DashboardJsonDataSource CreateJsonDataSourceFromFile()
{
    var jsonDataSource = new DashboardJsonDataSource();
    Uri fileUri = new Uri("customers.json", UriKind.RelativeOrAbsolute);
    jsonDataSource.JsonSource = new UriJsonSource(fileUri);
    jsonDataSource.RootElement = "Customers";
    jsonDataSource.Fill();
    return jsonDataSource;
}

public static DashboardJsonDataSource CreateJsonDataSourceFromString()
{
  var jsonDataSource = new DashboardJsonDataSource();
  string json = "{\"Customers\":[{\"Id\":\"ALFKI\",
  \"CompanyName\":\"Alfreds Futterkiste\",\"ContactName\":\"Maria Anders\",
  \"ContactTitle\":\"Sales Representative\",\"Address\":\"Obere Str. 57\",
  \"City\":\"Berlin\",\"PostalCode\":\"12209\",\"Country\":\"Germany\",
  \"Phone\":\"030-0074321\",\"Fax\":\"030-0076545\"}],\"ResponseStatus\":{}}";
  jsonDataSource.JsonSource = new CustomJsonSource(json);
  jsonDataSource.RootElement = "Customers";
  jsonDataSource.Fill();
  return jsonDataSource;
}

VB.NET

Imports DevExpress.DashboardCommon
Imports DevExpress.DataAccess.Json
' ...
Public Sub InitializeDashboard()
    Dim dashboard As New Dashboard()
    Dim jsonDataSourceFromWeb As DashboardJsonDataSource = CreateJsonDataSourceFromWeb()
    Dim jsonDataSourceFromFile As DashboardJsonDataSource = CreateJsonDataSourceFromFile()
    Dim jsonDataSourceFromString As DashboardJsonDataSource = CreateJsonDataSourceFromString()

    dashboard.DataSources.Add(jsonDataSourceFromWeb)
    dashboard.DataSources.Add(jsonDataSourceFromFile)
    dashboard.DataSources.Add(jsonDataSourceFromString)
End Sub

Public Shared Function CreateJsonDataSourceFromWeb() As DashboardJsonDataSource
    Dim jsonDataSource = New DashboardJsonDataSource()
    jsonDataSource.JsonSource = New UriJsonSource(New Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json"))
    jsonDataSource.RootElement = "Customers"
    jsonDataSource.Fill()
    Return jsonDataSource
End Function

Public Shared Function CreateJsonDataSourceFromFile() As DashboardJsonDataSource
    Dim jsonDataSource = New DashboardJsonDataSource()
    Dim fileUri As New Uri("customers.json", UriKind.RelativeOrAbsolute)
    jsonDataSource.JsonSource = New UriJsonSource(fileUri)
    jsonDataSource.RootElement = "Customers"
    jsonDataSource.Fill()
    Return jsonDataSource
End Function

Public Shared Function CreateJsonDataSourceFromString() As DashboardJsonDataSource
    Dim jsonDataSource = New DashboardJsonDataSource()
    Dim json As String = "{""Customers"":[{""Id"":""ALFKI"",""CompanyName"":""Alfreds Futterkiste"",""ContactName"":""Maria Anders"",""ContactTitle"":""Sales Representative"",""Address"":""Obere Str. 57"",""City"":""Berlin"",""PostalCode"":""12209"",""Country"":""Germany"",""Phone"":""030-0074321"",""Fax"":""030-0076545""}],""ResponseStatus"":{}}"
    jsonDataSource.JsonSource = New CustomJsonSource(json)
    jsonDataSource.RootElement = "Customers"
    jsonDataSource.Fill()
    Return jsonDataSource
End Function

Implements

IDataComponent

IDashboardDataSource

Inheritance

Object

MarshalByRefObject

Component

DevExpress.DataAccess.DataComponentBase

JsonDataSource

DashboardJsonDataSource