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.
Syntax
=SI.QUERYLOOKUP(ConnectionName,Object,QueryFilter,FieldToReturn,KeyFields,KeyValue1, KeyValue2,...KeyValueN)
Arguments
The SI.QUERYLOOKUP function uses the following arguments:
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Required | A case-insensitive Sage Intacct object name. |
| Optional | An optional filter to be used internally for SI.QUERY. Compatible with values returned by SI.QUERYFILTER. |
| Required | The name of the field to be retrieved from Sage Intacct. |
| 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). |
| The value corresponding to the first field specified in the | |
| The value corresponding the next field (if any) specified in the | |
... | ||
| The value corresponding the last field (if any) specified in the |
Example
=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
