page

No

The number of the page to query. If omitted, the default value of 1 is taken (the first page).

page_size

No

The number of rows returned per-page. When omitted, the default value of 1000 items per page is used. The valid range for this parameter is 1-1000. Exceeding this range will coerce the value to the closest accepted value.

includeDataTypes

No (default: false)

This parameter is only relevant for CSV file requests.

If set to true, then the CSV will receive an extra row after headers but before the data, which describe the actual column types (as indicated by the database engine).

If you omit this parameter or set it to false, the returned CSV will not have this extra information, but will be then cross-compatible with other CSV-capable software.

ApiKey

Yes

Your API key (see chapter Authentication and authorization for more information how to get it).

Accept

Yes

This determines the format of the data. Available supported values are:

application/json
text/comma-separated-values

$dataHubApiKey = "M6KNS9Z-3404R00-Q42E4SG-1G4HKWT";

$dataHubHostName = "https://datahub.local";

$dataHubPort = 443;

$tableName = "CatalogSoftware";

$pageSize = 10;
$page = 1;

$urlAddress = "{0}:{1}/v1/resultDatabase/table/{2}/paged?page={3}&page_size={4}" -f $dataHubHostName,$dataHubPort,$tableName, $page, $pageSize

$headers = @{};

$headers["ApiKey"] = $dataHubApiKey;

$headers["Accept"] = "application/json";

$request = Invoke-WebRequest -Uri $urlAddress -Headers $headers -Method Get;

if ($request.StatusCode -eq 200)

{

    $parsedContent = ConvertFrom-Json($request);

    Write-Host "Available columns:";

    foreach ($item in $parsedContent.columns)

    {

        Write-Host (" * {0} ({1}) " -f $item.name, $item.type);

    }

    Write-Host "";

    Write-Host "Number of records:";

    Write-Host $parsedContent.records.Count;

    Write-Host "";

    Write-Host "Pages":

    Write-Host (" * First:    {0}" -f $parsedContent.pagination.first);

    Write-Host (" * Previous: {0}" -f $parsedContent.pagination.previous);

    Write-Host (" * Next:     {0}" -f $parsedContent.pagination.next);

    Write-Host (" * Last:     {0}" -f $parsedContent.pagination.last);

}

else

{

    throw "Could not download the file. HTTP code $($req.StatusCode)";    

}