Using JSON file or a web service as a Data Provider is handled with the PowerShell Data Provider in exMon. In this sample we will use data from OpenWeatherMap.org. If the JSON data is located in a file on the server or accessible on a network drive, you can use "Get-Content" to retrieve the data. Query text:
$items = Get-Content -Path C:\TEMP\JsonWeather.txt | ConvertFrom-Json

$items.list | Select-Object -Property name,visibility,@{label="temperature";expression={$_.main.temp}}

  If the JSON data is accessible from the web, you can use "WebClient" to download the data.
$queryString = "https://samples.openweathermap.org/data/2.5/group?id=524901,703448,2643743&units=metric&appid=b6907d289e10d714a6e88b30761fae22"

$web_client = new-object system.net.webclient
$items = $web_client.DownloadString($queryString) | ConvertFrom-Json

$items.list | Select-Object -Property name,visibility,@{label="temperature";expression={$_.main.temp}}
In both samples above, the results are readily available in exMon as shown below. JSON Data