Passing special characters as parameter to Powershell script function

Question

I just created a method in powershell script as -

function Add-Entity() {
    [CmdletBinding()]
    param(
       $TableName,
       $PartitionKey,
       $RowKey,
       [String]$JsonString
    )


  $entity = New-Object -TypeName Microsoft.WindowsAzure.Storage.Table.DynamicTableEntity -ArgumentList $PartitionKey, $RowKey
  $entity.Properties.Add("JsonStringProperty", $JsonString)
  $result = $table.CloudTable.Execute([Microsoft.WindowsAzure.Storage.Table.TableOperation]::Insert($entity))
}

and I want to pass this complete jSon string as a parameter -

Add-Entity -TableName $myTableName -PartitionKey "ABC" -RowKey "XYZ" -JsonString {"TO":["[email protected]","[email protected]"],"CC":["[email protected]"],"BCC":[]}

Every time I try to compile, It gives me an error -

Unexpected token ':["abc@xyz".com"' in expression or statement

Eduard Uta · Accepted Answer · 2015-10-15 07:05:24Z

1

The issue is that the JSON uses double quotation marks to delimiter key and values and the same character (double quotation marks) is also used by Powershell for strings "wrapping".

You can use single quotation marks to wrap your hardcoded input json like so:

'{"TO":["[email protected]","[email protected]"],"CC":["[email protected]"],"BCC":[]}'

So the statement would be:

Add-Entity -TableName $myTableName -PartitionKey "ABC" -RowKey "XYZ" -JsonString '{"TO":["[email protected]","[email protected]"],"CC":["[email protected]"],"BCC":[]}'

answered Oct 15, 2015 at 7:05

Eduard Uta

2,6165 gold badges30 silver badges39 bronze badges

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

1 Comment

Mayur Dhingra Over a year ago

Worked like a charm. Thanks!

Collectives™ on Stack Overflow

Passing special characters as parameter to Powershell script function

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related