Datasource: JSON

JSON data source

The External JSON data source reads JSON from a URL that the Nextcloud server can reach. For URLs on a private network, see Data source reference.

Use it either as a real-time report source or in a data load that stores snapshots in an Internal Database dataset.

Options

• URL
• HTTP method: GET or POST
• Object path: slash-separated object keys; separate individual values with commas
• Content-Type and Custom headers: headers are written as Name: value,Name: value
• Authentication: user:password for Basic authentication
• Request body for POST requests
• Timestamp of data load for stored snapshots

For scalar values, use paths such as ocs/data/nextcloud/storage,ocs/data/nextcloud/shares. For an array, use braces to select the output fields, for example {BTC,tmsp,price}. A path before the braces selects a nested array: data/data{forecast,from,intensity/forecast}.

Example: Nextcloud monitoring API

1. Enable the Monitoring app and create an application password.
2. Use https://cloud.example/ocs/v2.php/apps/serverinfo/api/v1/info?format=json.
3. Set Authentication to user:app-password.
4. Set Object path to ocs/data/nextcloud/storage,ocs/data/nextcloud/shares.
5. Enable a timestamp only when storing historic snapshots.

Test the request before scheduling it. Do not put credentials in a public report link.