使用PowerShell使用REST API调用的限制

发布于 2025-02-10 11:39:27 字数 594 浏览 1 评论 0原文

我需要使用PowerShell通过REST API调用进行一些历史数据。我被数据量超过4 GB的终点之一所困。当我在PowerShell ISE中运行PowerShell脚本时，它可以按预期运行。但是，当我通过SQL Server Integration Services执行进程任务时，将无法下载JSON有效负载。

有更好的方法解决这个问题吗？是否应该注意任何限制？

$Header = @{
    "authorization" = "Bearer $token"
}
#make REST API call
$Parameters = @{
    Method      = "GET"
    Uri         = "https://api.mysite.com/v1/data"
    Headers     = $Header
    ContentType = "application/json"
    Body        = $BodyJson
}
Invoke-RestMethod @Parameters

错误： system.outofmemoryexception

原文

I have a need to make a few historical data pulls via REST API call using Powershell. I'm stuck with one of the endpoints where the data volume is over 4 GB. When I run the Powershell script in the Powershell ISE it works as expected. But, When I run the same via SQL Server Integration Services Execute Process Task it's not able to download the JSON payload.

Is there a better way to tackle this? Are there any limitations one should be mindful of?

$Header = @{
    "authorization" = "Bearer $token"
}
#make REST API call
$Parameters = @{
    Method      = "GET"
    Uri         = "https://api.mysite.com/v1/data"
    Headers     = $Header
    ContentType = "application/json"
    Body        = $BodyJson
}
Invoke-RestMethod @Parameters

Error: System.OutOfMemoryException

分享到QQ

分享到微博