Microsoft Azure Storage Table Reader Parameters

About Web Connections

Connections store authentication information.

For general information about web connections, please see Using Web Connections.

For information about managing web services (including authorization credentials such as Client Id and Client Secret), please see Managing Web Services.

Connection

From the Connection parameter in a web service format, you can do one of the following:

  • Select an existing previously defined connection. For information, see the section Reusing a Web Connection in Using Web Connections.
  • Select Add Web Connection to define a new connection. The new connection can be made visible only to the current user, or can be shared among multiple users.

Microsoft Azure Storage Connection

Select an existing Microsoft Azure Storage connection, or Add Web Connection....

Add Microsoft Azure Storage Connection

To define a new connection from the Connection parameter in a Microsoft Azure Storage Table format, see the topic Microsoft Azure Storage Table: Add Web Connection.

Constraints

Specifies the name of the table to read data from. The table name can be entered manually or chosen from a list of tables accessible by the account specified by the Storage Service Name.

Specifies the filter applied to the Azure Storage Table query. The format of the filter is the same as the $filter clause for OData.

Logical Operator

Description

Example Filter String

eq

Equal

City eq 'Redmond'
gt

Greater than

Price gt 20

ge

Greater than or equal to

Price ge 10

lt

Less than

Price lt 20

le

Less than or equal

Price le 100

ne

Not equal

City ne 'London'

and

And

Price le 200 and Price gt 3.5

or

Or

Price le 3.5 or Price gt 200

not

Not

not isAvailable

For a full filter syntax reference, please see Constructing Filter Strings for the Table Designer.

Schema Generation

This option can be set to prevent FME from unnecessarily reading all the rows from a potentially large file when determining its schema.

The default is 1.

Note  This setting only applies to the schema generation; it does not limit the number of rows read when the translation is run.

Advanced

Prior to FME 2022.0, web access through this format would automatically disable HTTPS Certificate verification when an SSL Error was received from the server. Now, this behavior must be explicitly enabled or disabled by this parameter.

The value of this parameter takes priority over the value of the Verify SSL Certificates parameter which might be defined by the Web Connection used with this format.

Schema Attributes

Additional Attributes to Expose

Use this parameter to expose Format Attributes in FME Workbench when you create a workspace:

  • In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
  • In a non-dynamic scenario, this parameter allows you to expose additional attributes on multiple feature types. Click the browse button to view the available format attributes (which are different for each format) for the reader.