Hello there
We've created a small powershell script for retreiving a CSV file from M$ SNDS, and entering the data into PRTG.
''' $url = "https://xxx" $headers = 'channel','DateFrom','DateTo','rcpt','data','receipients','status','compliantrate','trapperiod','samplehelo','samplemailfrom' $innerbox = @{ "result" = Invoke-WebRequest $url | Select-Object -ExpandProperty Content | ConvertFrom-Csv -Header $headers } @{"prtg" = $innerbox}|ConvertTo-Json -Compress -Depth 100 ''' The result looks correct to my eyes: ''' {"prtg":{"result":[{"channel":"1.2.3.48","DateFrom":"1/13/2020 1:00 AM","DateTo":"1/13/2020 11:00 PM","rcpt":"2883","data":"2883","rece ipients":"2860","status":"GREEN","compliantrate":"\u003c 0.1%","trapperiod":"","samplehelo":"","samplemailfrom":"0"}]}} '''
But in PRTG I get the message:
XML: The returned XML does not match the expected schema. (code: PE233) -- JSON: The returned JSON does not match the expected structure (Result is missing). (code: PE231)
Add comment