SI.QUERYLOOKUP

Overview

The SI.QUERYLOOKUP function returns a field from the specified Sage Intacct object, using key fields/values and an optional filter expression.

While SI.QUERYLOOKUP is more efficient for retrieving values from individual fields, we recommend using SI.QUERY for returning multiple fields from a single object.

Syntax

CODE

=SI.QUERYLOOKUP(
    ConnectionName,
    Object,
    Filter,
    FieldToReturn,
    KeyFields,
    KeyValue, 
    OtherKeyValue1, 
    OtherKeyValue2,
    OtherKeyValue3,
    OtherKeyValue4,
    ... 
)

Arguments

The SI.QUERYLOOKUP function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`Object`	Required	A case-insensitive Sage Intacct object name.
`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`. Joins are not supported. You can use the SI.QUERYFILTER function to generate filters ready to use in this argument.
`FieldToReturn`	Required	The name of the field to be retrieved from Sage Intacct.
`KeyFields`	Required	A comma-separated list of Sage Intacct object field names ("key1,key2,key3") whose combination is guaranteed to uniquely identify every record in the object's dataset (at least in the subset filtered using the specified QueryFilter). or An Excel range reference. The elements of the Excel range are enumerated left-to-right, top-to-bottom (empty or whitespace cells are ignored).
`KeyValue`		The value corresponding to the first field specified in the `KeyFields` argument.
`OtherKeyValue1`		The value corresponding the next field (if any) specified in the `KeyFields` argument.
...
`OtherKeyValueN`		The value corresponding the last field (if any) specified in the `KeyFields` argument.

Example

CODE

=SI.QUERYLOOKUP(
    "Sage",
    "Project",
    ,
    "Managercontactname",
    "ProjectID",
    "10041"
)

Description

Queries the Sage Intacct Project object to retrieve the project manager contact name for project with ID 10041

Result