SI.QUERYLOOKUP

Created by Pavel Kabir, Modified on Fri, 5 Jul at 7:46 PM by Harry Lewis

Applies to:

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

TABLE OF CONTENTS

Syntax

SI.QUERYLOOKUP 
(ConnectionName
Object,
QueryFilter,
FieldToReturn
KeyFields
KeyValue1,
KeyValue2,
...
KeyValueN)

The SI.QUERYLOOKUP function uses the following parameters:

Parameter	Required/Optional	Description
Connection	Required	The name of the connection as configured in the Connection Manager
Object	Required	A case-insensitive Sage Intacct object name.
QueryFilter	Optional	An optional filter to be used internally for SI.QUERY. Compatible with values returned by SI.QUERYFILTER.
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 parameter.
OtherKeyValue1		The value corresponding the next field (if any) specified in the KeyFields parameter.
...
OtherKeyValueN		The value corresponding the last field (if any) specified in the KeyFields parameter.

=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