Open topic with navigation

GetContactID

This function is used to look up and return the Saleslogix ContactID for a specified connection based on the contact first name, last name and account name. All three arguments must be provided.

Note: Returns null if no contact is found.

GetContactID (  "connection", "first name", "last name", "account name" )

For example:

GetContactID ("MyTarget","Heinz", "Muller", "HillTop Corp" )

Runs the SQL statement on the specified connection:

“select contactid from contact where firstname = “first name” and lastname = “last name” and account = “account name”.

See also

Custom functions

TIBCO Scribe® Insight Help Library