The Bold Reports allows you to connect to the JSON data source that retrieves data from JSON file, a string in JSON format or a external URL.
To configure the JSON data source, follow the below steps:
DATA
configuration panel, click on the NEW DATA
button.
JSON
data source type.
You can connect JSON data using the following three options,
Choose Inline
in Type
drop-down.
Specify a string that contains JSON data in the Inline
text area.
[
{
"ID": 1,
"IDBook": 1,
"FirstName": "First Name 1",
"LastName": "Last Name 1"
},
{
"ID": 2,
"IDBook": 1,
"FirstName": "First Name 2",
"LastName": "Last Name 2"
}
]
Click on the Connect
to proceed with query design pane. The query design pane will show the specified JSON data’s structure in left pane.
Drag and drop the table from the left pane in the query design view page and execute.
Click Finish
to save the data source with a relevant name to proceed with designing report.
File
option in Type
field. Now, the upload option will start displaying like below.
Connect
to proceed with query design pane.
Finish
to save the data source with a relevant name to proceed with designing report.
Choose External
option in Type
field.
Specify a external URL in the External
text area.
Click on the Connect
to proceed with query design pane. The query design pane will show the specified JSON data’s structure in left pane.
Drag and drop the table from the left pane in the query design view page and execute.
Click Finish
to save the data source with a relevant name to proceed with designing report.
Note: In schema tree, the nested fields in the JSON data will be shown as flat structure.