Get-ListDataAsStream.ps1

function Get-ListDataAsStream {
    param (
        [Parameter(Mandatory)]
        [string]
        $SiteUrl,
        [Parameter(Mandatory)]
        [string]
        $ListName,
        [Parameter(Mandatory)]
        [string] 
        $CAMLQuery,
        [Parameter(Mandatory = $false)]
        [string]
        $NextLink
    )
 
    $QueryUrl = "$SiteUrl/_api/web/lists/GetbyTitle('$ListName')/RenderListDataAsStream"
    Write-Information -MessageData:"QueryUrl:$QueryUrl"
    if ($NextLink -and $NextLink.StartsWith('?')) {
        $NextLink = $NextLink.Substring(1)
        Write-Information -MessageData:"Paging:$NextLink"
    }

    $body = @{
        parameters = @{
            Paging        = $NextLink
            RenderOptions = 2
            ViewXml       = $CAMLQuery
        }
    }

    return Invoke-PnPSPRestMethod -Url:"$QueryUrl" -Method:Post -ContentType:"application/json;odata=nometadata" -Content:$body

}