Parsing json with Powershell in cURL

Question

Hi I am trying to execute below ways to run the POST call in power shell

option 1:

$Body="{ \`"cartItem\`" : {\`"sku\`" : \`"RG1219013\`", \`"qty\`" : \`"1\`",  \`"quoteId\`" : \`"QRAeZdoFbieEWHjrRs5X0G1tHRE4el30\`"  }}"

option 2:

$Body=@"
{ \"cartItem\" : {\"sku\" : \"RG1219013\", \"qty\" : \"1\",  \"quoteId\" : \"QRAeZdoFbieEWHjrRs5X0G1tHRE4el30\"  }}
"@

option3 :

$Body = @{
    cartItem =
    {
        sku = 'RG1219013'
        qty = '1'
        quoteId = 'QRAeZdoFbieEWHjrRs5X0G1tHRE4el30'
    }
} 

$Json = (ConvertTo-Json $Body)

Execute:

$Header = @{ "Content-Type" = "application/json" }
Invoke-RestMethod -Method Post -Body $Body -Uri $UriAddtoCart -Header $Header

In option 1 and option 2 I am getting Bad request (400) and option 3 it's internal error (500)

Below jason respond successfully through postman

{
    "cartItem" :
    {
        "sku" : "RG1219013",
        "qty" : "1",
        "quoteId" : "QRAeZdoFbieEWHjrRs5X0G1tHRE4el30"
    }
}

Is there anything missing here?

option 3 looks fine, option 1 and 2 are tricky to escape correctly so i'd prefer option3 other theese. error 500 means something on the server-side is going wrong and does not neccesairily mean your request or json is bad. do you get any error message from that webservice ? are you missing something in the header ? — D.J.
– D.J., Commented Jul 6, 2019 at 11:28
@D.J.Yes I get the response when I tried same thing with Postman. Only that Content-Type header is there — Shabar
– Shabar, Commented Jul 6, 2019 at 11:39
You missing a @ sign after cartItem = in option 3 (this way you assign it a function), Thus: cartItem = {... should be: cartItem = @{... (check the actual content of the $Json file) — iRon
– iRon, Commented Jul 6, 2019 at 11:48

iRon · Accepted Answer · 2019-07-06 13:36:29Z

1

The Json file is missing a @ sign after cartItem = in option 3 (this way a function is assigned to the cartItem property rather than a HashTable)
This will get clear if you output the $Json file (e.g. Write-Host $Json).

Thus:

$Body = @{
    cartItem =
    {
        sku = 'RG1219013'
        ...

Should be:

$Body = @{
    cartItem =
    @{
        sku = 'RG1219013'
        ...

answered Jul 6, 2019 at 13:36

iRon

24.4k10 gold badges60 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing json with Powershell in cURL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related