Background:
When using ActiveReportsJS, there are many types of endpoints that can be used to connect to a remote JSON data source. It is rather simple to bind a report to a REST API endpoint in the Standalone Report Designer.
Steps to Complete:
- Click "Add" in the Data Sources tab of the Standalone Report Designer.
- Insert the entire REST API URL into the "Endpoint" input box. Name the data source whatever you'd like and click "Save".
- Click the "Plus" icon to add a data set to the data source you just created.
- Name it whatever you'd like, and change the Json Path to select the correct data from the endpoint. If you'd like to grab all the data, it will look something like this: $.*. Click "Validate" to see the fields from that data set. If the fields are not being calculated correctly, you may need to edit the Json path.
- Congratulations! You have successfully connected a REST API data source and data set. From here, you can drag any of the fields from the Data Sets tab onto the surface of the report, or input them into a specific control.
If you need more help with this process, please create a support ticket with our customer engagement team here.
Christian Wirt