BC.EXPANDOBJECTRANGE

Overview

The BC.EXPANDOBJECTRANGE function returns the sorted names of objects matching the search criterion, defined within Business Central. Additionally, returns information about object insertability, updatability, and deletability via the SI.WRITEBACK function.

Syntax

=BC.EXPANDOBJECTRANGE(
    ConnectionName, 
    Object,
    Api
)

Arguments

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`Object`	Optional	A search expression for filtering objects, uses Velixo filtering techniques. If not specified, returns all objects.
`Api`	Optional	API to be referenced for Object names. The accepted predefined values are: `common` - Common API v2 (default) `web-service` - OData endpoints exposed per tenant `Velixo` - endpoints exposed via the Velixo AL extension Use the following syntax to use a published AL Extension: {publisher}/{group}/{version} - a fragment of the extension's URL `Velixo` is an alias for the most recent version of the Velixo AL extension

Examples

Return all objects

=BC.EXPANDOBJECTRANGE()

Description: Returns a list of objects available for all connections along with information about their modifiability.

Result:

Return objects containing a string

=BC.EXPANDOBJECTRANGE(
    "BC",
    "vendor?"
)

Description: Returns a list of objects available for the “BC” connection, beginning with the string vendor.

Result: