ActiveReports 11
JSON Provider
ActiveReports 11 > ActiveReports User Guide > Concepts > Page Report/RDL Report Concepts > Data Sources and Datasets > Report Data Source Dialog > JSON Provider

The JSON Data Provider supports following options under the Connection section in Report Data Source dialog.

Content

In the Content tab, specify the type of JSON data source. The options available for specifying the JSON data are as follows:

Schema

The JSON schema describes the structure of a JSON data. In ActiveReports, the JSON data provider uses the JSON schema to obtain fields. For more information on JSON schema, please see http://json-schema.org/latest/json-schema-core.html.
The keywords of JSON schema that are supported in the JSON data provider are:

Note: Schema is the only required option to create a connection string.

In the Schema tab, select the JSON schema file corresponding to your JSON data. The options available for specifying the JSON schema are:

Connection String

JSON connection string has two parts - jsondoc or jsondata and schemadoc or schemadata.

Note: If you are using an expression in the connection string, you should use single quotes (') instead of double quotes (") in jsondoc or jsondata and schemadoc or schemadata.

For example, the following connnection string is invalid:

="jsondata={  "Name": "Name"};schemadata={    "$schema": "http://json-schema.org/draft-04/schema#",
    "definitions": {},    "id": "http://example.com/example.json",
    "properties": {        "Name": {            "id": "/properties/Name",
            "type": "string"        }    },    "type": "object"}"


Use the following instead:

="jsondata={  'Name': 'Name'};schemadata={    '$schema': 'http://json-schema.org/draft-04/schema#',
    'definitions': {},    'id': 'http://example.com/example.json',
    'properties': {        'Name': {            'id': '/properties/Name',
            'type': 'string'        }    },    'type': 'object'}"