CODEWITHSUNDEEP
powershellssisexecuteprocesstask
ITHelpGuy
ITHelpGuy

Reputation: 1037

Limitations with REST API calls using Powershell

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

Upvotes: 2

Views: 346

Answers (0)

Related Questions