Excel Add-In for Azure Table Storage

Build 24.0.9060

CreateEntityWithTypes

Creates a new record with the given data types. If a column is not found on an existing entity, you will need to use this procedure to set the type of the property to something other than string.

Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.

Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

In the table below, indexed parameters are denoted with a '#' character at the end of their names.

Input

Name Type Required Description
TableName String True The name of the table.
PartitionKey String False The partition key for the new entity.
RowKey String False The row key for the new entity.
PropertyName# String False The name for the property.
PropertyType# String False The data type for the property.

The allowed values are string, integer, datetime, boolean, double, long, binary.

PropertyValue# String False The value for the property.

Result Set Columns

Name Type Description
Success String Returns true if the entity was created and False otherwise

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060