An external system calls up the URL of the laboratory database Webservice with username and password and gets back the data record of the evaluation.

To make an evaluation available as web services for external systems, go to Edit evaluation and select "Activate HTTP authentication" (see figure) and assign a user name and password for HTTP authentication (Information on HTTP authentication).











Once data retrieval via HTTP authentication is enabled, data can be retrieved from an external system using the following URLs (replacing the X in the URL with the number of the evaluation).

1. Retrieval as CSV record: https://labordatenbank.com/demo/stats/view/X/https
   
   
2. Fetch as JSON record: https://labordatenbank.com/demo/stats/view/X/https_json
   
   
3. Fetching with variables: https://labordatenbank.com/demo/stats/view/X/https_json/VAR0/VAR1/VAR2/VAR3/VAR4/DATE/

The following values are possible for the variable DATE: today, yesterday, last_3_days, this_month, last_month, last_6_month, last_12_month, this_year, last_year





The following is a sample code of how the retrieval of the evaluation could be implemented by an external system:







Windows PowerShell sample scripts for a download of a data set from an evaluation







Example 1

### Settings ###



$downloadDirectory = ".\download"



$uri = "http://labordatenbank.com/demo/stats/view/1/https_json"

$user = "testuser"

$pass = "testpassword"



#####################



$b64 = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("${user}:$pass"))

$headers = @{

    "Authorization" = "Basic $b64"

}



$download = Invoke-WebRequest -Uri $uri -Headers $headers -UseBasicParsing

$content = [System.Net.Mime.ContentDisposition]::new($download.Headers["Content-Disposition"])



$fileName = $content.FileName

$fullPath = Join-Path -Path $downloadDirectory -ChildPath $fileName



Invoke-WebRequest -Uri $uri -Headers $headers -OutFile $fullPath

Example 2

### Settings ###

$downloadDirectory = "XXX"

$uri = "https://labordatenbank.com/XXX/stats/view/XXX/https_json"

$user = "XXX"

$pass = "XXX"



$logFileName = "auswertungen.log"

$fullLogPath = Join-Path -Path $downloadDirectory -ChildPath $logFileName

Start-Transcript "$fullLogPath" -Append





Base64 decoding¶



$b64 = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("${user}:$pass"))

$headers = @{

"Authorization" = "Basic $b64"

}



Download¶



$download = Invoke-RestMethod -Uri $uri -Headers $headers -UseBasicParsing

if($downloadDirectory){

foreach($entry in $download){

$downloadLink = $entry.'Download-Link'

$fileName = $entry.Dateiname

$fullPath = Join-Path -Path $downloadDirectory -ChildPath $fileName



    Write-Host "<--- $fileName --->"



if(![System.IO.File]::Exists($fullPath)){

    Invoke-WebRequest -Uri $downloadLink -OutFile $fullPath



if($fullPath){

    Write-Host "$filename Downloaded successfully." -ForegroundColor Green

} else {

    Write-Host "Error when downloading the file." -ForegroundColor Red

}



} else {

Write-Host "The file $fileName already exists!" -ForegroundColor Red

}



}



} else {

Write-Host "The path could not be found!" -ForegroundColor Red

}



Stop-Transcript