Lookups¶
BigCommerce can be queried from within any transform via the CustomLookup function. This useful to translate/lookups values in BigCommerce for use in any integration such as record Ids.
The CustomLookup function is very similar to the native Lookup function in IMan.
Syntax¶
Arguments¶
systemid¶
The system id value of the Shopify system connector to be used for the lookup.
select¶
The JPATH of the field to be returned.
from¶
This is the BigCommerce resource to be queried e.g. products, variants, customers.
where¶
The query string to pass to BigCommerce.
emptystring¶
This parameter is not used, just pass an empty string.
mustreturnvalue¶
True or False to specify the Lookup query should return one record.
Example¶
To return the id of a product querying by sku.