az storage entity insert forcing a string to int32

[JackBruceShell]

Describe the bug

String is being sent as a "property" to be inserted into a property, when viewing in the portal the string "0152" has been converted to type int32 and shows "052"

Related command

    az storage entity insert --if-exists merge --entity PartitionKey=$partitionKey RowKey=$rowKey $property --table-name $tableName --account-name $storageAccountName --auth-mode login

Errors

No errors, just incorrect behaviour

Issue script & Debug output

Script:

az account set --subscription XXX
$path="./testFile.json"
$object = Get-Content $path | ConvertFrom-Json
$storageAccountName = "XXX"
$tableName = "XXX"
for ($i = 0; $i -lt $object.Count; $i++) {
$obj = $object[$i]
$partitionKey = $obj.PartitionKey
$rowKey = $obj.RowKey
$obj.PSObject.Properties.Remove('PartitionKey')
$obj.PSObject.Properties.Remove('RowKey')
Write-Host "PartitionKey: $partitionKey"
Write-Host "RowKey: $rowKey"
Write-Host "Modified Object:"
$obj | ConvertTo-Json -Depth 5
$ht2 = @{}
$obj.psobject.properties | Foreach { $ht2[$.Name] = $.Value }
Write-Host "ht2: $ht2"
Write-Host "Object: $obj"

foreach ($entry in $ht2.GetEnumerator()) {
    $key = $entry.Key
    $value = $entry.Value
    $valueType = $value.GetType()
    ## Check value of the property
    Write-Host "Value type: $value"
    Write-Host $value.GetType()

    $property = $entry.Key + "=" + $entry.Value
    Write-Host "Property: $property"
    # Write-Host $property
    az storage entity insert --if-exists merge --entity PartitionKey=$partitionKey RowKey=$rowKey $property --table-name $tableName --account-name $storageAccountName --auth-mode login
}

}

Output:
PartitionKey: C2S_CROSS_GSAP_OU_MAP
RowKey: DEC-0154
Modified Object:
{
"CROSS_OUCode": "DEC",
"CROSS_TPPCode": "0154",
"CROSS_SSN": "",
"GSAP_OUCode": "DE01"
}
ht2: System.Collections.Hashtable
Object: @{CROSS_OUCode=DEC; CROSS_TPPCode=0154; CROSS_SSN=; GSAP_OUCode=DE01}
Value type: 0154
System.String
Property: CROSS_TPPCode=0154
{
"date": "2024-11-18T16:20:12+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A12.3183423Z'"",
"version": "2019-02-02"
}
Value type: DEC
System.String
Property: CROSS_OUCode=DEC
{
"date": "2024-11-18T16:20:13+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A13.7894865Z'"",
"version": "2019-02-02"
}
Value type:
System.String
Property: CROSS_SSN=
{
"date": "2024-11-18T16:20:14+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A15.148696Z'"",
"version": "2019-02-02"
}
Value type: DE01
System.String
Property: GSAP_OUCode=DE01
{
"date": "2024-11-18T16:20:16+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A17.0475922Z'"",
"version": "2019-02-02"
}
PartitionKey: C2S_CROSS_GSAP_OU_MAP
RowKey: DEF-0154
Modified Object:
{
"CROSS_OUCode": "DEF",
"CROSS_TPPCode": "0154",
"CROSS_SSN": "",
"GSAP_OUCode": "DE01"
}
ht2: System.Collections.Hashtable
Object: @{CROSS_OUCode=DEF; CROSS_TPPCode=0154; CROSS_SSN=; GSAP_OUCode=DE01}
Value type: 0154
System.String
Property: CROSS_TPPCode=0154
{
"date": "2024-11-18T16:20:18+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A18.8605368Z'"",
"version": "2019-02-02"
}
Value type: DEF
System.String
Property: CROSS_OUCode=DEF
{
"date": "2024-11-18T16:20:19+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A20.0078691Z'"",
"version": "2019-02-02"
}
Value type:
System.String
Property: CROSS_SSN=
{
"date": "2024-11-18T16:20:20+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A21.5189903Z'"",
"version": "2019-02-02"
}
Value type: DE01
System.String
Property: GSAP_OUCode=DE01
{
"date": "2024-11-18T16:20:22+00:00",
"etag": "W/"datetime'2024-11-18T16%3A20%3A22.9781421Z'"",
"version": "2019-02-02"
}

File input:
[
{
"PartitionKey": "C2S_CROSS_GSAP_OU_MAP",
"RowKey": "DEC-0154",
"CROSS_OUCode": "DEC",
"CROSS_TPPCode": "0154",
"CROSS_SSN": "",
"GSAP_OUCode": "DE01"
},
{
"PartitionKey": "C2S_CROSS_GSAP_OU_MAP",
"RowKey": "DEF-0154",
"CROSS_OUCode": "DEF",
"CROSS_TPPCode": "0154",
"CROSS_SSN": "",
"GSAP_OUCode": "DE01"
}
]

The field in question that is failing is "CROSS_TPPCode".

Expected behavior

String is entered as property, not int32

Environment Summary

azure-cli 2.63.0 *

core 2.63.0 *
telemetry 1.1.0

Dependencies:
msal 1.30.0
azure-mgmt-resource 23.1.1

Additional context

No response

[azure-client-tools-bot-prd]

Hi @JackBruceShell,

2.63.0 is not the latest Azure CLI(2.66.0).

If you haven't already attempted to do so, please upgrade to the latest Azure CLI version by following https://learn.microsoft.com/en-us/cli/azure/update-azure-cli.

[yonzhan]

storage

[calvinhzy]

Hi @JackBruceShell Seems like it is auto resolving the value type, can you try adding quotes around this string?

[vishalholla27]

Adding quotes would store data with quotes '0123', Cant we just store 0123

[calvinhzy]

Hi @JackBruceShell @vishalholla27, you can add CROSS_TPPCode@odata.type=Edm.String as part of the insert command like this
az storage entity insert --if-exists merge --entity PartitionKey=$partitionKey RowKey=$rowKey CROSS_TPPCode=0152 CROSS_TPPCode@odata.type=Edm.String --table-name $tableName --account-name $storageAccountName --auth-mode login