Azure Integrator V2 - Online Help
Azure Integrator V2
Questions / Feedback?

Table Component

Properties   Methods   Events   Configuration Settings   Errors  

The Table Component provides an easy interface to Microsoft's Windows Azure Table Service.

Syntax

nsoftware.InAzure.Table

Remarks

The table component allows you to easily access the Azure Table Service. You can use the component to create, modify, and delete tables, entities, and entity properties. A brief description follows, but please refer to Microsoft Azure Table Service Concepts for additional details on Azure Tables.

Before using the Table component you will first need to create an Azure Storage Account to obtain the AccessKey and Account

To begin you may add tables using the CreateTable method. Entities may be created using InsertEntity method. Entities are identified within a table by the PartitionKey and RowKey. Methods relating to entities will take partitionKey and rowKey as parameters. For instance to update an entity:

table.Reset();
table.TableName = "YourTableName";
table.AccessKey = "YourAccessKey";
table.Account = "YourAccount";

//Get the existing properties of an entity in a table
table.GetEntity("MyPartionKey","MyRowKey");

//Output the value of the 1st entity
Console.WriteLine(table.EntityProperties[0].Value);

//Change the Entity value
table.EntityProperties[0].Value = "NewValue";

//Add a new Entity property
table.AddEntityProperty("testString", 7, "My New String");
      
//Update the entity
table.UpdateEntity();

Additional methods and properties can be used for further operations on tables, such as DeleteTable DeleteEntity InsertEntity MergeEntity etc.

Property List


The following is the full list of the properties of the component with short descriptions. Click on the links for further details.

AccessKeyThe Windows Azure access key.
AccountThe Windows Azure storage account name.
ConnectedShows whether the component is connected.
EntityCountReturns the number of entities in the response from the server.
EntityETagGets the etag of the current entity.
EntityIndexIndicates the index of the current entity.
EntityLastModifiedGets the last modification date of the current entity.
EntityPartitionKeyGets the partition key of the current entity.
EntityPropertiesThe list of entity properties of current entity.
EntityRowKeyGets the row key of the current entity.
EntityURLGets the URL of the current entity.
FirewallA set of properties related to firewall access.
FollowRedirectsDetermines what happens when the server issues a redirect.
IdleThe current status of the component.
IfMatchSpecifies the condition for which the update/merge/delete should be performed.
LocalHostThe name of the local host or user-assigned IP interface through which connections are initiated or accepted.
NextPartitionKeyIndicates the next partition key to be returned in a subsequent query against the table.
NextRowKeyIndicates the next row key to be returned in a subsequent query against the table.
NextTableNameIndicates the name of the next table in the list, if the list of tables returned is not complete.
OtherHeadersOther headers as determined by the user (optional).
ParsedHeadersCollection of headers returned from the last request.
ProxyA set of properties related to proxy access.
SSLAcceptServerCertInstructs the component to unconditionally accept the server certificate that matches the supplied certificate.
SSLCertThe certificate to be used during SSL negotiation.
SSLServerCertThe server certificate for the last established connection.
StatusLineThe first line of the last server response.
TableNameThe name of current table.
TablesThe list of tables returned by a call to ListTables .
TimeoutA timeout for the component.
UseSSLUse SSL to access Azure Blob.

Method List


The following is the full list of the methods of the component with short descriptions. Click on the links for further details.

AddEntityPropertyAdds an entity property that will be used for inserting, updating or merging an entity.
ConfigSets or retrieves a configuration setting .
CreateTableCreates a new table within a storage account.
DeleteEntityDeletes an entity within a table.
DeleteTableDeletes a table from a storage account.
DoEventsProcesses events from the internal message queue.
GetEntityGets the entity specified by PartitionKey and RowKey.
InsertEntityInserts a new entity into a table.
InterruptInterrupt the current method.
ListEntitiesLists the entities in a table.
ListTablesLists the tables in a storage account.
MergeEntityUpdates an existing entity within a table by merging new property values into the entity.
ResetResets request-related properties.
ResetHeadersResets all HTTP headers, cookies, and localfile.
UpdateEntityUpdates an existing entity within a table by replacing it.

Event List


The following is the full list of the events fired by the component with short descriptions. Click on the links for further details.

ConnectedFired immediately after a connection completes (or fails).
DisconnectedFired when a connection is closed.
EndTransferFired when a document finishes transferring.
EntityListFired for every entity when ListEntities is called.
ErrorInformation about errors during data delivery.
HeaderFired every time a header line comes in.
SSLServerAuthenticationFired after the server presents its certificate to the client.
SSLStatusShows the progress of the secure connection.
StartTransferFired when a document starts transferring (after the headers).
StatusFired when the HTTP status line is received from the server.
TableListFired for every table when ListTables is called.
TransferFired while a document transfers (delivers document).

Configuration Settings


The following is a list of configuration settings for the component with short descriptions. Click on the links for further details.

APIVersionThe API version specified in the request.
TransferredDataReturns the entire XML response received from Azure.
URLIf set, the default URL(http://youraccount.blob.core.windows.net/) will be overridden by this value.
AzureTimeoutGets or sets the service timeout for the request in seconds.
DateFormatThe format string to be used for formatting the DateTime values received from the server.
QueryStringFilters the returned results based on provided string properties.
XMLEscapePropertiesWhether entity property names and values are XML escaped.
AcceptEncodingUsed to tell the server which types of content encodings the client supports.
AllowHTTPCompressionThis property enables HTTP compression for receiving data.
AllowIdenticalRedirectURLAllow redirects to the same URL.
AppendWhether to append data to LocalFile.
AuthorizationThe Authorization string to be sent to the server.
BytesTransferredContains the number of bytes transferred in the response data.
EncodeURLIf set to true the URL will be encoded by the component.
FollowRedirectsDetermines what happens when the server issues a redirect.
GetOn302RedirectIf set to true the component will perform a GET on the new location.
HTTPVersionThe version of HTTP used by the component.
IfModifiedSinceA date determining the maximum age of the desired document.
KeepAliveDetermines whether the HTTP connection is closed after completion of the request.
MaxRedirectAttemptsLimits the number of redirects that are followed in a request.
OtherHeadersOther headers as determined by the user (optional).
ProxyAuthorizationThe authorization string to be sent to the proxy server.
ProxyAuthSchemeThe authorization scheme to be used for the proxy.
ProxyPasswordA password if authentication is to be used for the proxy.
ProxyPortPort for the proxy server (default 80).
ProxyServerName or IP address of a proxy server (optional).
ProxyUserA user name if authentication is to be used for the proxy.
TransferredDataLimitThe maximum number of incoming bytes to be stored by the component.
TransferredHeadersThe full set of headers as received from the server.
UseChunkedEncodingEnables or Disables HTTP chunked encoding for transfers.
ChunkSizeSpecifies the chunk size in bytes when using chunked encoding.
UserAgentInformation about the user agent (browser).
KerberosSPNThe Service Principal Name for the Kerberos Domain Controller.
ConnectionTimeoutSets a separate timeout value for establishing a connection.
FirewallAutoDetectTells the component whether or not to automatically detect and use firewall system settings, if available.
FirewallHostName or IP address of firewall (optional).
FirewallPasswordPassword to be used if authentication is to be used when connecting through the firewall.
FirewallPortThe TCP port for the FirewallHost;.
FirewallTypeDetermines the type of firewall to connect through.
FirewallUserA user name if authentication is to be used connecting through a firewall.
KeepAliveTimeThe inactivity time in milliseconds before a TCP keep-alive packet is sent.
KeepAliveIntervalThe retry interval, in milliseconds, to be used when a TCP keep-alive packet is sent and no response is received.
LingerWhen set to True, connections are terminated gracefully.
LingerTimeTime in seconds to have the connection linger.
LocalHostThe name of the local host through which connections are initiated or accepted.
LocalPortThe TCP port in the local host where the component binds.
MaxLineLengthThe maximum amount of data to accumulate when no EOL is found.
MaxTransferRateThe transfer rate limit in bytes per second.
RecordLengthThe length of received data records.
TCPKeepAliveDetermines whether or not the keep alive socket option is enabled.
UseIPv6Whether to use IPv6.
TcpNoDelayWhether or not to delay when sending packets.
ReuseSSLSessionDetermines if the SSL session is reused.
SSLCipherStrengthThe minimum cipher strength used for bulk encryption.
SSLEnabledProtocolsUsed to enable/disable the supported security protocols.
SSLProviderThe name of the security provider to use.
SSLSecurityFlagsFlags that control certificate verification.
OpenSSLCADirThe path to a directory containing CA certificates.
OpenSSLCAFileName of the file containing the list of CA's trusted by your application.
OpenSSLCipherListA string that controls the ciphers to be used by SSL.
OpenSSLPrngSeedDataThe data to seed the pseudo random number generator (PRNG).
AbsoluteTimeoutDetermines whether timeouts are inactivity timeouts or absolute timeouts.
FirewallDataUsed to send extra data to the firewall.
InBufferSizeThe size in bytes of the incoming queue of the socket.
OutBufferSizeThe size in bytes of the outgoing queue of the socket.
CodePageThe system code page used for Unicode to Multibyte translations.

 
 
Copyright (c) 2017 /n software inc. - All rights reserved.
Build 2.0.6240.0