EN VI

Powershell console output to variable?

How to Powershell console output to variable

I got a powershell script for a url get query. I use the external curl.exe because Invoke-Webrequest and the .NET is not able to query with GET and with a body.

I just need the http response code.

$header = "Bearer ABCDE"
$ContentType = "application/json"
$url = "http://test/api"

$bodyJson='{""SSELECT1"": ""0"", ""SSELECT2"": ""TEST1""}'
$pattern = "(?<=HTTP/1.1 )\d+"

$output =  & "C:\curl\bin\curl.exe" -X GET -H "Authorization: $header" -H "Content-Type: $ContentType" -d $bodyJson -v $url

Write-Host "Response: " $output

$httpCode = [regex]::Match($output, $pattern).Groups[1].Value

Write-Host "HTTP CODE: " $httpCode

This is the output I need in a Variable to catch the http code, but its only shown in the powershell console. But the output variable conains just the line at the bottom "Response: XYZ", so I have just access to the curl result. Is there any way?

curl.exe :   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
    In Zeile:9 Zeichen:15
    + ... usgabe =  $(&"C:\curl\bin\curl.exe" -X GET -H "Authorization: $header ...
    +                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : NotSpecified: (  % Total    % ...  Time  Current:String) [], RemoteException
        + FullyQualifiedErrorId : NativeCommandError
     
                                     Dload  Upload   Total   Spent    Left  Speed
      0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0* Host XY was resolved.
    * IPv6: (none)
    * IPv4: 123
    *   Trying 123...
    * Connected to celle (123) port xy
    > GET test/api HTTP/1.1
    > Host: 123
    > User-Agent: curl/8.6.0
    > Accept: */*
    > Authorization: Bearer ABCDE
    > Content-Type: application/json
    > Content-Length: 57
    > 
    } [57 bytes data]
    < HTTP/1.1 200 OK
    < Connection: keep-alive
    < Content-Type: application/json
    < Content-Length: 278
    < Date: Thu, 14 Mar 2024 12:15:58 GMT
    < 
    { [278 bytes data]
    100   335  100   278  100    57   2989    613 --:--:-- --:--:-- --:--:--  3764
    * Connection #0 to host XY left intact

Output:

Response:  {"records":[{"value":{"TEST":"1","TEST2":"2"}}]}

Solution:

The general answer to your question is to append redirection 2>&1 to your curl.exe call, causing PowerShell to capture stderr output too (which is where curl.exe prints its progress and verbose information to, alongside error messages).
- If you later need to separate stdout lines from stderr lines in the combined output, use the technique shown in the bottom section of this answer.
The specific solution, for curl, given that you're interested in only the HTTP status code:

$output = 
  C:\curl\bin\curl.exe -s -w '%{http_code}' -X GET -H "Authorization: $header" -H "Content-Type: $ContentType" -d $bodyJson $url -o /dev/null

-s (--silent) silences progress and error output.
-w '%{http_code}' outputs the HTTP status code on an extra line, after the response body.
-o /dev/null discards the response body, so that in effect only the HTTP status code prints.
- Remove this argument if you want to capture the response body too.
  - You can then separate the response body from the status code as follows:
```
 $responseBody, $statusCode = 
   ($output | select -SkipLast 1), $output[-1]
```
- Note that /dev/null isn't actually the null device on Windows and is treated like a literal path that causes an error; however, this error can be ignored and effectively is ignored, due to -s; a proper, but Windows-only solution would be to target NUL (on Unix-like platforms you'd create an output file literally named NUL in the current directory).