Description

The Velixo NX SI.QUERY function returns the contents of the specified Sage object.

The available objects are listed in the Sage API Reference: API Reference | Sage Intacct Developer

Syntax

This is the syntax for this function:

=SI.QUERY(
ConnectionName
Object,
Filter,
Select,
IncludeHeader,
Top)

Parameters

This function has these Parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Object

Required

The entities which can be accessed are listed in API Reference | Sage Intacct Developer

Filter

Optional

SQL-like query based on fields on the object. The following operators are supported: <, >, >=, <=, =, like, not like, in, not in, IS NOT NULL, IS NULL, AND, OR. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes ('Jane\'s Deli'). Joins are not supported.

Select

Optional

Comma-separated list of columns to be included in the resulting dataset. If this parameter is empty, all the columns from the object will be returned.

IncludeHeader

Optional

TRUE or FALSE, indicating if should column headers be included in the dataset.

Top

Optional

Returns the number of records specified. If a value is specified, the results are sorted by Record Number (RECORDNO). Otherwise, they are not sorted.

Example

SI.QUERY("Sage","GLBatch",,,,10)

Description: Returns the top 10 records returned by the GLBatch object.

Result:

Applies to

  • ⚠️ Velixo NX only

  • ERP: Sage Intacct

Did this answer your question?