ActiveReports 16 .NET Edition
ActiveReports 16 User Guide / Concepts / Page Report/RDL Report Concepts / Data Binding / Connect to a Data Source / JSON Provider
In This Topic
    JSON Provider
    In This Topic

    This article explains connecting a Page or an RDL report to a JSON data source.

    Connect to a JSON Data Source

    1. In the designer, go to the Report Explorer, right-click the Data Sources node and select the Add Data Source option or click the Add button and then select the Data Source option.
    2. In the Report Data Source dialog that appears, select the General page and enter the name of the data source in the Name field. By default, the data source name is set to DataSource1. This name appears as a child node to the Data Sources node in the Report Explorer.
    3. Under the Type field, select Json Provider.
      Json Provider
    4. In the Connection Properties tab, set the type of Json data to 'External file or URL'.
    5. Click the dropdown next to the Select or type the file name or URL field and select the <Browse...> option to specify the json file path. For example, you can connect to the 'customers.json' sample datasource which can be downloaded from GitHub.

      The Connection String tab displays the generated connection string as shown below:
      jsondoc=C:\customers.json
      For more information, see the Configuration Properties for Json Data Source section.
    6. Verify the generated connection string by clicking the Validate DataSource icon Validate Icon in Report Data Source Dialog Box.
    7. Click OK to save the changes and close the Report Data Source dialog.

    Configuration Settings for JSON Data Source

    The JSON Data Provider provides the following configuration settings under the Connection section in the Report Data Source dialog.

    The Content tab describes the type of JSON data you want to use for connecting to a data source. The options available for specifying the JSON data are as follows:

    The Schema tab describes the options available for specifying the JSON schema in ActiveReports.

    The JSON schema describes the structure of the JSON data. In ActiveReports, the JSON data provider uses the JSON schema to obtain fields. For more information on JSON schema, please see https://json-schema.org/understanding-json-schema/.
    JSON data provider does not support the following schema keywords, such as:

    The Connection String tab displays the JSON connection string based on the defined configuration settings in the Content and Schema tab.