How to insert String Values with empty space in PartitionKey column of Azure Table

Question

I am trying to insert values into Azure Table PartitionKey Column. These values is of type String and have spaces between them. Example

$p = "VMWARE-42 3B"
        $r = "VMWARE"
        $entity = @{
            "[email protected]" = "Edm.String";
           "PartitionKey"         = $p;
            "[email protected]" = "Edm.String";
            "RowKey"                = $r;           
 }
        Set-TableEntity -TableName $tableName -StorageAccountName $storageAccountName -StorageAccessKey $storageAccessKey -Entity $entity  -Verbose

I am getting the below error:

Set-TableEntity - Attempt #0 VERBOSE: PUT https://table_url/tableName(PartitionKey='VMWARE-42 3B',RowKey='VMWARE') with -1-byte payload Error: Failed to update device entry Exception occurred: System.Net.WebException: The remote server returned an error: (403) Forbidden. at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()

Please any idea on how to solve this? Please note that when the values are inputed manually, there is no error. Does Azure Table accept spaces in String values? Please Note also that: without the space in the string value everything works as expected. the required table is updated.

You don't show us how you do the actual call... Because of the spaces, do you quote those string values? — Theo
– Theo, Commented Mar 18, 2022 at 11:24
Then please show us the code you use to insert those values. Not in a comment, but as formatted text in your question. Just click the edit link underneath. Since the server returns Forbidden, are you using the correct credentials to that call? — Theo
– Theo, Commented Mar 18, 2022 at 11:32
yes, I am using the right credential. Without the space in the string value everything works fine. @Theo, I have updated my question. Thank you. — EstherIs
– EstherIs, Commented Mar 18, 2022 at 11:58
Can you 'escape' the space character? for example, replace all spaces with %20 or x0020 using p = p.replace(/ /g, 'x0020'). — Donald Koscheka
– Donald Koscheka, Commented Apr 15, 2022 at 14:29

Alimur Razi Rana · Accepted Answer · 2022-11-18 05:36:36Z

0

You need to convert your partitionKey and rowKey part in the URL to escaped representation.

$Resource = "$TableName(ParitionKey='$PartitionKey',RowKey='$RowKey')"
$Resource = [URI]::EscapeUriString($Resource)
$TableUrl = "https://tableUrl/$($Resource)

You must use the same $Resource variable in making a hash signature.

answered Nov 18, 2022 at 5:36

Alimur Razi Rana

4801 gold badge5 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How to insert String Values with empty space in PartitionKey column of Azure Table

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