SI.XQUERYLOOKUP

Created by Velixo Team, Modified on Fri, 1 Aug at 7:35 AM by Velixo Team

Applies to:

  • Velixo NX

  • Sage Intacct



Introduction


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

Syntax

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

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 REST API object name.

QueryFilter

Optional

An optional filter to be used internally for SI.XQUERY.

Compatible with values returned by SI.XQUERYFILTER.

FieldToReturn

Required

The name of the field to be retrieved from Sage Intacct.

KeyFields

Required

A comma-separated list of Sage Intacct REST API 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 filter).

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 to the next field (if any) specified in the KeyFields parameter.

...

OtherKeyValueN

The value corresponding to the last field (if any) specified in the KeyFields parameter.



Example

=SI.XQUERYLOOKUP("Sage","construction-forecasting/wip-project",,"estimatedCostAtCompletion","id","24")

Description:

Queries the Sage Intacct REST API construction-forecasting/wip-project object to retrieve its estimated cost at completion for the project with ID 24

 

Result:

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article