In This Topic
This article explains connecting a Section report to a JSON data source.
Connect to a JSON Data Source
- In the designer, select the Data Source icon on the Detail section of the report or click the gray area around the design surface and select the Edit Data Source link in the Properties pane.
- In the Report Data Source dialog that appears, select the JSON tab to connect to a JSON data source.
- Click the Build button next to the Connection String section to open the Configure JSON Data Source dialog box.
- To specify the Data Path of the file, click the Open button and navigate to the desired folder on your system. For example, you can connect to the 'Customers.json' sample data source which can be downloaded from GitHub.
For more information, see the Configuration Settings for JSON Data Source.
- Click OK to save the changes and close the Configure JSON Data Source dialog box.
The Connection String section displays the generated connection string as shown below.
Connection String |
Copy Code
|
jsondoc=C:\Customers.json
|
- In the JSON Path field, enter a valid JSON Path expression or click the Build button to generate the path using the JSON query designer.
JSON Path |
Copy Code
|
$.Customers
|
For more information on JSON Path expressions, please visit this article.
- Click the OK button to save the changes.
Configuration Settings for JSON Data Source
The JSON Data Provider provides the following configuration settings in the Configure JSON Data Source dialog box.
- Data Path: Path or URL of an external JSON data file or select the file available on the system using the Open button. You can also pass parameters (including report parameters) to the URL. For example, https://demodata.mescius.io/northwind/odata/v1/customers?$top=7&$orderby=Country.
The connection string generated starts with the keyword jsondoc.
- HTTP Headers: Contains information related to authorization. Here you provide the expected content type, bearer token, etc. necessary for establishing the connection. For example, providing credentials to log in to a service/URI to retrieve data.
- HTTP Method: The HTTP request method, it can either be set to GET (included in URL) or POST (included in Request Body). POST requests allow defining a body as an expression to obtain data.
- Request Body: Body for the POST request method. The text area is enabled only when the HTTP Method is set to POST.