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. |
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
Feedback sent
We appreciate your effort and will try to fix the article