SI.XEXPANDOBJECTRANGE
Overview
When using the SI.XQUERY function, you may want to have the list of objects you can query on hand.
You can use the Sage Intacct documentation or use a Velixo function.
Syntax
CODE
=SI.XEXPANDOBJECTRANGE(ConnectionName, Range)Arguments
Argument | Required/Optional | Description |
|---|---|---|
| Required | The name of the connection, as specified in the Connection Manager |
| Optional | The Range string supports Velixo filtering techniques. The argument is case-insensitive. |
Output
The function returns a spill range of the Sage Intacct object names exactly as they are used in SI.XQUERY and SI.XOBJECTDEFINITION functions.