SI.QUERY

Modified on Sun, 17 Sep 2023 at 07:48 PM

Applies to:

Velixo NX
Sage Intacct

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

The SI. Query function has these Parameters:

Parameter	Required/Optional	Description
Connection	Required	The name of the connection, as specified in the Connection Manager
Object	Required	The *Query and List Legacy* entities which can be accessed are listed in API Reference \| Sage Intacct Developer
Filter	Optional This parameter is Case Sensitive and must be enclosed within quote marks	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.

Examples

Example #1

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

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

Result:

Example #2

SI.QUERY("Sage","TaxSolution", "TaxMethod='VAT or GST'", "SolutionID,TaxMethod")

Description:

Returns the SolutionID and TaxMethod fields from the TaxSolution object where the TaxMethod field is set to VAT or GST:

Result:

Example 3

=SI.QUERY("Sage","TaxDetail","DESCRIPTION LIKE('%Sales%')", "RecordNo,DetailID,Description,TaxType,Value,Include, GLAccount,TaxAuthority,Status")

Description:

Returns the specified fields (in the order specified) from the TaxDetail object where the Description field contains the case-sensitive substring Sales

Result: