BC.EXPANDOBJECTRANGE

Overview

The BC.EXPANDOBJECTRANGE function returns the sorted names of objects matching the search criterion, defined within Business Central.

CODE

=BC.EXPANDOBJECTRANGE(
    ConnectionName, 
    Object
)

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`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

CODE

=BC.EXPANDOBJECTRANGE(
    "BC"
)

Description: Returns a list of objects available for the “BC” connection.

Result:

CODE

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

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

Result: