[Reference feedback]: Insert Table Entity as Entity - Set Column Type

[shanerowley-ds]

Type of issue

Other (describe below)

Reference command name

So this works

$entity = @()
$entity += "PartitionKey=$partitionKey"
$entity += "RowKey=$rowKey"
$entity += "Content=$content"
az storage entity insert -t $tableName --account-name $storageAccount --auth-mode login -e @entity

Feedback

But how do I include the odata.type per column in the entity? e.g. "Content=$content Content@odata.type@odata.type=Edm.Int32"? I've tried a few different things but nothing seems to work.

Page URL

No response

Content source URL

#23932

Author

No response

Document Id

No response

[yonzhan]

Thank you for opening this issue, we will look into it.

[calvinhzy]

Hi @shanerowley-ds , I have added instruction here https://github.com/Azure/azure-cli/pull/30534/files
Can you try this az storage entity insert --connection-string $connectionString --entity PartitionKey=AAA RowKey=BBB Content=0152 Content@odata.type=Edm.String --if-exists merge --table-name MyTable

[shanerowley-ds]

How do I insert a column that is type "odata.type=Edm.Int32" but who's value is null?

For context, my script inserts entities from a CSV that was exported manually from a template table. But the 'Int32' columns for some rows have a null or empty string values in the CSV.

I need something that works along the lines of

$output = az storage entity insert `
    --connection-string $connectionString  `
    --table-name $tableName `
    --entity `
        PartitionKey=$apiConfig `
        RowKey=$apiConfigId `
        Content01=$Content01 Content01@odata.type=Edm.String `
        Content02=$Content02 Content02@odata.type=Edm.String `
        Content03=$Content03 Content03@odata.type=Edm.String `
        Content05=$Content05 Content05@odata.type=Edm.String `
        Content06=$Content06 Content06@odata.type=Edm.String `
        Content07=$Content07 Content07@odata.type=Edm.String `
        Content08=$Content08 Content08@odata.type=Edm.String `
        Content09=$Content09 Content09@odata.type=Edm.String `
        Content10=$Content10 Content10@odata.type=Edm.String `
        Content11=$Content11 Content11@odata.type=Edm.String `
        Content12=$Content12 Content12@odata.type=Edm.String `
        Content13=$Content13 Content13@odata.type=Edm.String `
        Content15=$Content15 Content15@odata.type=Edm.String `
        Content16=$Content16 Content16@odata.type=Edm.String `
        If (-not [string]::IsNullOrEmpty($Content20)) { `
            Content17=$Content17 Content20@odata.type=Edm.In32 `
        } `
        If (-not [string]::IsNullOrEmpty($Content20)) { `
            Content18=$Content18 Content20@odata.type=Edm.In32 `
        } `
        If (-not [string]::IsNullOrEmpty($Content20)) { `
            Content19=$Content19 Content20@odata.type=Edm.In32 `
        } `
        If (-not [string]::IsNullOrEmpty($Content20)) { `
            Content20=$Content20 Content20@odata.type=Edm.In32 `
        } `
    --if-exists replace

I did create a solution by using a Dynamic Script in PowerShell: Invoke-Expression $cmd

It works, but my script is pretty complicated in comparison.

[calvinhzy]

Is there an issue with a mix match of multiple types? I think if an empty value is needed, you can use string as well.