EXPANDCONNECTIONRANGE

Overview

The EXPANDCONNECTIONRANGE function lets you retrieve a list of all Velixo connections within the workbook.

CODE

=EXPANDCONNECTIONRANGE(
    ConnectionName, 
    ErpType,
    IncludeType
)

Argument	Required/Optional	Description
`ConnectionName`	Optional	Search expression for filtering connection names, supports Velixo filtering techniques.
`ErpType`	Optional	Limits results to the provided ERP types. Accepts the following values: `acumatica` - Acumatica, MYOB Acumatica, Cegid XRP Flex, Haufe X360, Hotel Investor Apps, Jamis Prime `intacct` - Sage Intacct `bc` - Microsoft Dynamics 365 Business Central `stack` - STACK
`IncludeType`	Optional	Include connection types in the results – `TRUE` or `FALSE`. Default value: `FALSE`

CODE

=EXPANDCONNECTIONRANGE(
    ,
    ,
    "TRUE"
)

Description:

Returns all connection names for the workbook along with their ERP types.