Shopify Lookups

The Shopify connector also allows you to lookup values from your organisation. The CustomLookup function is very similar to the native Lookup function in IMan.

Syntax

CustomLookup(systemid, select, from, where, "", mustreturnvalue)

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 Shopify URL of the resource to be queried. Note this is just the path, it does not include the server part of the url as this comes from the System Connector setup.
• emptystring
  • This parameter is not used, just pass an empty string.
• emptystring
  • This parameter is not used, just pass an empty string.
• mustreturnvalue
  • True or False to specify the Lookup query should return one record.
  • True
    • An error will be raised if the lookup fails to return a record.
  • False
    • The function will return an empty string if the lookup fails to return a record.

Example

To return the id of the first location the Location resource.

CustomLookup("SHOPREAL", "/locations/id", "/admin/locations.json", "", "", False)

To obtain a specific location the above lookup can be modified via a property query.

CustomLookup("SHOPREAL", "/locations[name='New York']/id", "/admin/locations.json", "", "", False)