Maximum number of seconds to wait for data source to transmit its data

Numeric (0 = infinite wait)

Default: 90

If true, data from requests are kept in memory to satisfy potentially the same request if it occurs within a set timeframe, aiding performance at the cost of currency of data. By default 50 pages are kept for a maximum of 10 minutes (per page).

Values: True or False

Default: True

Controls the error handling behavior of the function call.

Exception - an exception / hard error is generated.

ReturnValue - error details are returned as a string

NoData - an error is treated as "no data"

ExceptionRelaxed - a hard error is generated except for what could be considered potentially transient problems

Default Excel: ReturnValue (WebGetDynamicTable), Exception (others)

Default SQL: ExceptionRelaxed (WebGetTable, WebGetTableMetadata), ReturnValue (others)

When False, HTML table footers are ignored during parsing. Footers may not be compatible with a regular table structure, making False the default.

Values: True or False

Default: False

A maximum request count that is enforced over a time range that's defined by the MaxRequestIntervalSizeSeconds setting. The default is 15,000 requests per hour (per site) after which the MaxRequestFailAction setting determines whether the next request will return an error or wait.

Numeric (0 = unlimited)

Default: 15000

Defines the "last x seconds" during which no more than MaxRequestCount requests may be issued before the action defined by MaxRequestFailAction is applied.

Numeric (0 = unlimited)

Default: 3600

If the MaxRequestFailAction setting supports waiting for enough time to allow the MaxRequestCount & MaxRequestIntervalSizeSeconds settings to "age out" a prior request, then this setting specifies the maximum amount of time that a request will be left to wait. A large value for this setting implies request threads could be blocked for what seems like an indefinite period.

Numeric (0 = no waiting)

Default: 90

The minimum number of milliseconds between request starts (by site).

Numeric (0 = no delay)

Default: 25

Controls the action to take when the MaxRequestCount / MaxRequestIntervalSizeSeconds settings are exceeded.

WaitToMaxWithQuickFail - if a new request could be issued within MaxRequestWaitSeconds, the thread will wait; otherwise, the request returns an error

WaitToMax - always wait MaxRequestWaitSeconds

ReturnError - an error is always returned

Default: WaitToMaxWithQuickFail

If False, most values retrieved from data sources are treated as strings only. When True, some types of parsing allow recognition of certain data types.

Values: True or False

Default: True

Specifies the number of cells down from the cell containing the function where tabular data will be placed when using WebGetDynamicTable.

Numeric

Default: 1

Specifies the number of cells to the right from the cell containing the function where tabular data will be placed when using WebGetDynamicTable.

Numeric

Default: 0

Specifies the maximum number of rows of source data that can be copied into the worksheet when using WebGetDynamicTable.

Numeric (0 = unlimited)

Default: 0

Specifies the maximum number of columns of source data that can be copied into the worksheet when using WebGetDynamicTable.

Numeric (0 = unlimited)

Default: 0

Specifies a number of blank rows that will be included following the imported source data when using WebGetDynamicTable. This supports "clearing" of data when the number of source data rows decreases.

Numeric

Default: 200

Specifies the maximum number of data rows imported from the source data (i.e. truncates the source data) when using WebGetDynamicTable.

Numeric (0 = unlimited)

Default: 0

Specifies the maximum number of data columns imported from the source data (i.e. truncates the source data) when using WebGetDynamicTable.

Numeric (0 = unlimited)

Default: 0

When True, "missing" source data will not overwrite cells in the worksheet when using WebGetDynamicTable.

Values: True or False

Default: False