Add values to an array and send it as json payload - Powershell Azure

Question

I am using powershell (specifically Azure CLI) to get data from a service, add a value to a list and send a patch/post to an URL.

This is the URL to get the list of data:

$uriList = az rest --method get --uri "https://graph.microsoft.com/beta/applications/$objectId" --header "$header" --query spa.redirectUris | ConvertFrom-Json

This returns an array of strings.

['a', 'b', 'c', 'd', 'e']

if ($uriList -notcontains "f") {
    $uriList  += "f"
}

$uriListJSON = $uriList | ConvertTo-Json

Above, I have added "f" to the array and I want to send it to the url as follows:

$body = "{spa:{redirectUris: $uriListJSON}}"

az rest --method patch --uri "https://graph.microsoft.com/beta/applications/$objectId" --headers "$header" --body "$body"

I get an error:

Unable to read JSON request payload. Please ensure Content-Type header is set and payload is of valid JSON format."

Please advice on what I am doing wrong. I outputted uriListJSON to a file and ran it against a json validator and it passed.

When I hardcode everything to a url like

az rest --method patch --uri "https://graph.microsoft.com/beta/applications/$objectId" --headers $header --body "{spa: {redirectUris: ['a', 'b', 'c', 'd', 'e', 'f']}}"

it works like a charm.

mklement0 · Accepted Answer · 2021-12-05 04:31:42Z

2

Your from-and-to JSON conversion results in a string with - standards-compliant - embedded double-quoting ("):

PS> ("['a', 'b', 'c', 'd', 'e']" | ConvertFrom-Json) + 'f' | ConvertTo-Json -Compress

["a","b","c","d","e","f"]

Since you're passing the resulting string to an external program - az - the sad reality as of PowerShell 7.2 is that an extra, manual layer of \-escaping of embedded " characters is required in arguments.
This may get fixed in a future version, which may require opt-in. See this answer for details.

Therefore:

$uriListJSON = ("['a', 'b', 'c', 'd', 'e']" | ConvertFrom-Json) + 'f' | ConvertTo-Json -Compress

$body = "{ \`"spa\`": { \`"redirectUris\`": $($uriListJSON -replace '"', '\"') } }"

Note that while it may not be necessary for az, the above uses a strictly standards-compliant JSON string in which the property names of the verbatim part of your JSON string too are "..."-quoted, which requires both escaping for PowerShell (`") and manual \-escaping for the external program; in combination: \`"

edited Dec 5, 2021 at 4:31

answered Dec 4, 2021 at 20:46

mklement0

452k68 gold badges727 silver badges986 bronze badges

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

8 Comments

arunmmanoharan Over a year ago

Thanks for your advice. I tried it. Its not working. This is a screenshot of what I have done so far. imgur.com/a/WeTZCQP

mklement0 Over a year ago

@a2441918, please see my update - I hadn't noticed that the verbatim part of your JSON needs"..." quoting and therefore \ -escaping too.

arunmmanoharan Over a year ago

Tried that. Running into a string issue. imgur.com/a/qWiJUVc

mklement0 Over a year ago

@a2441918: Oops! My bad: forgot to escape the embedded " for PowerShell as well - please see my update.

arunmmanoharan Over a year ago

Sorry. Still the issue. imgur.com/a/UHqgzJq Do you want me to run any additonal commands to see if the data is in the correct format?

|

Collectives™ on Stack Overflow

Add values to an array and send it as json payload - Powershell Azure

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related