Excel.Interfaces.LinkedDataTypeData interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

An interface describing the data returned by calling linkedDataType.toJSON().

Properties

dataProvider

The name of the data provider for the linked data type. This may change when information is retrieved from the service.
lastRefreshed

The local time-zone date and time since the workbook was opened when the linked data type was last refreshed. Returns undefined if the linked data type has not been refreshed.
name

The name of the linked data type. This may change when information is retrieved from the service.
periodicRefreshInterval

The frequency, in seconds, at which the linked data type is refreshed if refreshMode is set to "Periodic".
refreshMode

The mechanism by which the data for the linked data type is retrieved.
serviceId

The unique ID of the linked data type.
supportedRefreshModes

Returns an array with all the refresh modes supported by the linked data type. The contents of the array may change when information is retrieved from the service.

Property Details

dataProvider

Warning

This API is now deprecated.

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

The name of the data provider for the linked data type. This may change when information is retrieved from the service.

dataProvider?: string;

Property Value

string

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

lastRefreshed

Warning

This API is now deprecated.

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

The local time-zone date and time since the workbook was opened when the linked data type was last refreshed. Returns undefined if the linked data type has not been refreshed.

lastRefreshed?: Date;

Property Value

Date

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

name

Warning

This API is now deprecated.

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

The name of the linked data type. This may change when information is retrieved from the service.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

periodicRefreshInterval

Warning

This API is now deprecated.

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

The frequency, in seconds, at which the linked data type is refreshed if refreshMode is set to "Periodic".

periodicRefreshInterval?: number;

Property Value

number

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

refreshMode

Warning

This API is now deprecated.

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

The mechanism by which the data for the linked data type is retrieved.

refreshMode?: Excel.LinkedDataTypeRefreshMode | "Unknown" | "Manual" | "OnLoad" | "Periodic";

Property Value

Excel.LinkedDataTypeRefreshMode | "Unknown" | "Manual" | "OnLoad" | "Periodic"

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

serviceId

Warning

This API is now deprecated.

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

The unique ID of the linked data type.

serviceId?: number;

Property Value

number

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

supportedRefreshModes

Warning

This API is now deprecated.

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Returns an array with all the refresh modes supported by the linked data type. The contents of the array may change when information is retrieved from the service.

supportedRefreshModes?: Excel.LinkedDataTypeRefreshMode[];

Property Value

Excel.LinkedDataTypeRefreshMode[]

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]