Functions

LOOKUPB

Lookup a value from Data Source B. This is functionally equivalent to LOOKUPA except that it uses Data Source B (Target) as the connection.

Syntax

object LOOKUPB(string column, FROM(from), keyValue)
object LOOKUPB(string columnName, LFROM from, params KVAL[] keyValues)

Example

Lookup via Data Source (B) the accountid from account where name equals the Name column.

LOOKUPB("accountid", "account", WHEN("name", Name))

You can lookup the Distinguished Name of a Manager to be returned from AD for a user within the same OU.

LOOKUPB("Distinguished Name", "", WHEN("EmployeeID", ReportsTo))

To do the same as above but to lookup the manager in a different OU to the one you are currently connected to, you can add the LDAP path to the second parameter. This would look something like:

LOOKUPB("Distinguished Name", "LDAP://OU=Managers,DC=demo,DC=simego,DC=com", WHEN("Display Name", Manager)

The quoted "Distinguished Name" is the column we are looking to return from Active Directory. We then specify the LDAP Path to the OU we want to look for the record in Then we specify a WHEN clause to define what the parameters are that need to be matched. This is the link between the source and the target. In this example is it the Display Name of the Manager in Active Directory to the Manager Field in the source columns.