export database as json from deta.sh to stdout

deta-export-database.ps1

param (
    [Parameter(Mandatory = $true)]
    [string] $ProjectKey,

    [Parameter(Mandatory = $true)]
    [string] $BaseName
)

$BaseUrl = "https://database.deta.sh/v1"

$ProjectId = $ProjectKey.Substring(0, $ProjectKey.IndexOf('_'))

$RootUrl = "$BaseUrl/$ProjectId/$BaseName"

$Items = @{ }

while ($true) {
    $Payload = @{ }

    if ($Last) {
        $Payload.Add("last", $Last)
    }

    $Response = Invoke-RestMethod `
        -Method POST  `
        -Uri "$RootUrl/query" `
        -Headers @{
            "X-API-Key" = $ProjectKey
            "Content-Type" = "application/json"
        } `
        -Body $($Payload | ConvertTo-Json)

    foreach ($Item in $Response.Items)
    {
        $Items.Add($Item.Key, $Item)
    }

    if (!$Response.paging.last) {
        break
    }
    else {
        $Last = $Response.paging.last
    }
}

Write-Output $(ConvertTo-Json $Items)