JDBC Driver for Azure Table Storage

Build 22.0.8462

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. These input parameters are denoted with a '#' character at the end of their names.

Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.

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

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

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462