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.