ACU.EXPANDOBJECTRANGE function

Created by Velixo Team, Modified on Wed, 13 Aug at 7:37 AM by Velixo Team

Applies to:

Velixo NX 2025.7 or higher
Acumatica, MYOB Acumatica, Cegid XRP Flex, Haufe X360, Jamis Prime

Introduction

When using the ACU.QUERY function, you can use ACU.EXPANDOBJECTRANGE to retrieve the list of objects you can query. The list can be filtered by object name. Filtering by namespace is not supported yet.

Syntax

=ACU.EXPANDOBJECTRANGE(ConnectionName, Object)

Parameters

Parameter	Required/Optional	Description
ConnectionName	Required	The name of the connection, as specified in the Connection Manager
Object	Optional	Filter based on Acumatica Data Access Class (DAC) names. For instance, GL? or Acc:Azz. The Object string supports Velixo filtering techniques. The parameter is case-insensitive.

Output

The function returns a spill range of Acumatica object names and their namespaces, sorted alphabetically by their ID, ready to be used with ACU.QUERY and ACU.OBJECTDEFINITION functions.