JsonDataSource Component

The JsonDataSource component enables data items to display JSON data located in a local file or saved directly into the report while using no code. At design time the component can be configured using the JsonDataSource Wizard. At run time the JsonDataSource automatically parses the JSON data.

The provided JSON data may omit properties with empty values. The result is that not all of the objects have the same list of properties. Due to this, no errors will be shown in the report if an undefined data field name is used inside an expression.

The data field names for this data source are case-sensitive. It is required to use the correct data field names in expressions, otherwise no data will be shown.

The JSON data source relies on and reuses some of the Web Service data source functionalities. To preview JSON data source reports in your application it is required to reference the Telerik.Reporting.WebServiceDataSource DLL or the corresponding NuGet package in the application.

Configuring the Component

External Data File Configuration:

Setting	Description
Source	The external data file containing the data. The URI to the file might be relative or absolute. Required if inline data string is not set.
Data Selector	The JSONPath string which will be used to query the JSON data. For more information please refer to How to Use JSONPath to filter JSON data

Inline Data String Configuration:

Setting	Description
Source	The inline data string containing the data. Required if external data file is not set.
Data Selector	The JSONPath string which will be used to query the JSON data. For more information please refer to How to Use JSONPath to filter JSON data

Supported developer platforms

• .NET Framework 4.6.2 and above
• .NET 6 and above
• .NET Standard 2.0 and above