Skip to main content
Skip table of contents

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

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

Arguments

The SI.QUERYLOOKUP function uses the following arguments:

Argument

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 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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.