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 Input 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 | Column names for the table, separated by commas (e.g., StringCol, IntegerCol). |
| PropertyType | String | False | Column data types, separated by commas (e.g., String, Integer). |
| PropertyValue | String | False | Comma-separated column values (e.g., valueInserted, 1). Values containing special characters must be enclosed in quotes. |
Result Set Columns
| Name | Type | Description |
| Success | String | Returns true if the entity was created and False otherwise |