Invoke-RestMethod with JSON body

Question

I'm trying to write a powershell script (powershell 6 and 7) to make REST call API from a text file with JSON body. Here's my code:

$uri = 'URI'
$json = Get-Content 'TXT_FILE_WITH_JSON_BODY' | Out-String | ConvertFrom-Json | ConvertTo-Json | %{[regex]::Unescape($_)}
$username = 'USER'
$password = 'PASSWORD'
$base64AuthInfo = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(("{0}:{1}" -f $username,$password)))
Invoke-RestMethod -Method POST -SkipCertificateCheck -Headers @{Authorization=("Basic {0}" -f $base64AuthInfo)} $uri -body $json -ContentType "application/json"

My txt file:

'{
  "apiversion": "3.0",
  "process": {
    "profileId": "ID",
    "jobType": "TYPE",
    "origin": "ORIGIN",
    "processWhileGrowing": true
  },
  "jobSource": {
    "sources": [
      {
        "uri": "\\\\\\\\10.22.6.250\\\\share\\\\test\\\\TEST01.mov"
      }
    ],
    "metadata": [
      {
        "name": "Description",
        "value": "Bla bla bla"
      },
      {
        "name": "title",
        "value": "Title"
      },
      {
        "name": "channel",
        "value": "SRV1"
      },
      ,
      {
        "name": "type",
        "value": "TYPE01"
      },
      {
        "name": "source",
        "value": "SOURCE01"
      }
    ]
    }
  }
  '

Then when I execute my script, I get this:

PS F:\Desktop> .\test01.ps1
Invoke-RestMethod: F:\Desktop\test01.ps1:6
Line |
   6 |  Invoke-RestMethod -Method POST -SkipCertificateCheck -Headers @{Autho …
     |  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | {
  "status": "HTTP_ERROR",
  "message": "SERVER_ERROR",
  "message_detail": null
}

My first idea is that my REST API does not respond well to the quotation at the start and end of my txt file (json body). However, if I remove the quotes from my txt file, Powershell say the following:

PS C:\Users\Brice> F:\Desktop\jsonconvert.ps1
ConvertFrom-Json : Invalid JSON primitive: .
At F:\Desktop\jsonconvert.ps1:1 char:63
+ ... nt 'F:\Desktop\1.txt' | Out-String | ConvertFrom-Json | Conve ...
+                                                  ~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [ConvertFrom-Json], ArgumentException
    + FullyQualifiedErrorId : System.ArgumentException,Microsoft.PowerShell.Commands.ConvertFromJsonCommand

Any idea how can I fix this ?

Answer 1

Resolve by removing simple quotes in the txt file and added the following to my code ConvertTo-Json -Depth 5