Azure Storage - Update entity
Declaration
<AMAZURESTORAGE ACTIVITY="update_entity" SESSION="text" ACCOUNTNAME="text" ACCESSKEY="text (encrypted)" PROTOCOL="text (options)" TIMEOUT="number" BLOBENDPOINT="text" QUEUEENDPOINT="text" TABLEENDPOINT="text" PROXYTYPE="text (options)" PROXYSERVER="text" PROXYPORT="number" PROXYUSERNAME="text" PROXYPASSWORD="text (encrypted)" TABLE="text" PARTITIONKEY="text" ROWKEY="text" NEWPARTITIONKEY="text" NEWROWKEY="text"><PROPERTY NAME="text" TYPE="text (options)" VALUE="text" /></AMAZURESTORAGE>
Description
Updates an existing entity in a table. This activity replaces the entire entity and can be used to remove properties.
Practical usage
Useful for updating information or synchronizing data.
Parameters
Connection
Property | Type | Required | Default | Markup | Description |
---|---|---|---|---|---|
Connection | --- | --- | --- | --- | Indicates where user
credentials and preferences should originate from. The available options are:
NOTE: This parameter does not contain markup and is only displayed in visual mode for task construction and configuration purposes. |
Connection - Session
Property | Type | Required | Default | Markup | Description |
---|---|---|---|---|---|
Session | Text | Yes, if Connection is set to Session | AzureStorageSession1 | SESSION="MyAzureSession" | The
name of the Azure Storage session to create. The default value
is AzureStorageSession1. NOTE: Use the Azure Storage - End session
activity to end an active Azure Storage session. |
Connection - Host > Credentials
Property | Type | Required | Default | Markup | Description |
---|---|---|---|---|---|
Account name | Text | Yes, if Connection is set to Host | (Empty) | ACCOUNTNAME="myaccount" | The globally unique name of the Windows Azure storage account. |
Access key | Text | Yes, if Connection is set to Host | (Empty) | ACCESSKEY="[AccessKey]" | The primary or secondary access key (each composed of 88 ASCII characters) used to authorize access to Azure Storage. |
Connection - Host > Advanced
Property | Type | Required | Default | Markup | Description |
---|---|---|---|---|---|
Protocol | Text (options) | No | HTTPS |
|
The
type of protocol used to access Azure Storage. The available options
are:
|
Timeout (seconds) | Number | No | 90 | TIMEOUT="180" | The timeout interval (in seconds) for requests made to the storage service. If the timeout elapses before a server response is returned, the operation times out and the service returns an error. The default timeout value is 90 seconds. |
Blob endpoint URI | Text | No | (Empty) | BLOBENDPOINT="http://accnt.blob.core.windows.net" | The endpoint for the Blob service, as configured for the Azure Storage account. The default Blob service endpoint is [http/https]://accountname.blob.core.windows.net, where accountname is the name of the Azure Storage account. |
Queue endpoint URI | Text | No | (Empty) | QUEUEENDPOINT="http://accnt.queue.core.windows.net" | The endpoint for the Queue service, as configured for the Azure storage account. The default Queue service endpoint is [http/https]://accountname.queue.core.windows.net, where accountname is the name of the Azure Storage account. |
Table endpoint URI | Text | No | (Empty) | TABLEENDPOINT="http://accnt.table.core.windows.net" | The endpoint for the Table service, as configured for the Azure storage account. The default Table service endpoint is [http|https]://accountname.table.core.windows.net, where accountname is the name of the Azure Storage account. |
Proxy type | Text (options) | Yes | System default |
|
The
type of proxy required for SharePoint connections passing through
a proxy server. The available options are:
|
Use authentication | --- | No | --- | --- | If
enabled, specifies proxy authentication is required,
enabling authentication-based parameters (disabled by default).
It is active only if the Proxy
type parameter is set to HTTP. NOTE: This parameter does not contain markup and is only displayed in visual mode for task construction and configuration purposes. |
Proxy server | Text | Yes, if Proxy type is set to HTTP | (Empty) | PROXYSERVER="proxy.host.com" | The hostname (server.domain.com) or IP address (xxx.xxx.xxx.xxx) of the proxy server. This parameter is available only if the Proxy type parameter is set to HTTP. |
Proxy username | Text | No | (Empty) | PROXYUSERNAME="username" | The proxy username to authenticate with. This parameter is available only if Use authentication is enabled. |
Proxy port | Number | No | 808 | PROXYPORT="8080" | The port number to use to connect to the proxy server. This parameter is available only if the Proxy type parameter is set to HTTP. The default value is 808. |
Proxy password | Text | No | (Empty) | PROXYPASSWORD="encrypted" | The proxy password to authenticate with. This parameter is available only if Use authentication is enabled. |
Entity
Property | Type | Required | Default | Markup | Description |
---|---|---|---|---|---|
Table name | Text | Yes | (Empty) | TABLE="mytable" | The unique name of the table that contains the entity to update. |
Partition key | Text | Yes | (Empty) | PARTITIONKEY="[system.string]" | The partition key of the entity to update. A partition is a successive range of entities that have the same partition key value. The partition key is a unique identifier for a partition within a given table. |
Row key | Text | Yes | (Empty) | ROWKEY="[system.string]" | The row key of the entity to update. The row key is a unique identifier for an entity within a given partition. |
New partition key (optional) | Text | No | (Empty) | NEWPARTITIONKEY="[system.string]" | The new partition key that should be assigned to the newly updated entity. |
New row key (optional) | Text | No | (Empty) | NEWROWKEY="[system.string]" | The new row key that should be assigned to the newly updated entity. |
Name | Text | Yes | (Empty) | NAME="Last Name" | The name of the entity to update. Select Click here to add new row to add a new row of data to specify the entity name, content type and value. Multiple rows can be added. To delete a row, click the red 'X'. |
Type | Text (options) | Yes | (Empty) | TYPE="string" | The entity type to update. Select Click here to add new row to add a new row of data to specify the entity name, content type and value. Multiple rows can be added. To delete a row, click the red 'X'. |
Value | Text | Yes | (Empty) | VALUE="Smith" | The entity value to update. Select Click here to add new row... to add a new row of data to specify the entity name, content type and value. Multiple rows can be added. To delete a row, click the red 'X'. |
Examples
NOTE:
- Copy and paste the sample AML code below directly into the Task Builder Steps Panel.
- To successfully run the sample code, update parameters containing user credentials, files, file paths, or other information specific to the task to match your environment.
Description
Update entity with PartitionKey=2 and RowKey=2 from table "customer". Azure account name is "netauto".
Copy
<AMAZURESTORAGE ACTIVITY="update_entity" ACCOUNTNAME="netauto" ACCESSKEY="AM561EWWBPmshm6Jwvi5lMskwIM/5RCfM3DseBgLjVLbVo=aME" PROXYTYPE="none" TABLE="Customer" PARTITIONKEY="2" ROWKEY="2"><PROPERTY NAME="Country" TYPE="string" VALUE="India" /><PROPERTY NAME="Email" TYPE="string" VALUE="a1@b.com" /></AMAZURESTORAGE>