INFOR.GET.DATACONNECTIONS

This function returns requested schema properties for specified data connections.

INFOR.GET.DATACONNECTIONS supports these features:

Dynamic arrays
The retrieved values are spilled to the adjacent cells.

Syntax

The function has this syntax:

=INFOR.GET.DATACONNECTIONS({"spillByColumns", ["schema_property"], "provider"}).})

This table shows the parameters and their descriptions:


`Parameters`	Description
spillByColumns	An optional Boolean value for spill direction. Specify true to spill by columns or false to spill by rows. Default value: false.
`schema_property`	Matrix of strings or cell references that represents properties to be returned. Optional parameter with the default value: "" that returns all fields. These values can be used: caption Returns the display name of the data connection. unique_name Returns the unique name of the data connection and can be used in formulas. provider Returns the type of provider, for example, inforolap, or msas.
`provider`	Provider string or a cell reference that is used for filtering the retrieved data connections. You can use this parameter to show only data connections that represent, for example, Analysis Services. Optional parameter with the default value: "all". Other possible values are "inforolap", "msas".

Return values

This function returns string values that represent one or more schema properties for the selected data connection. The properties include caption, unique name, or provider type.