The GetLeadSourceID function is used to look up and return the Saleslogix LeadSourceID for a specified connection based on either the Lead Source Description ( “D” ) or the Lead Source Abbreviation (“A”).
Note: Returns null if no lead source is found.
GetLeadSourceID (
For example:
GetLeadSourceID ("MyTarget", "Web Inquiry", "D" )
GetLeadSourceID ( "MyTarget","WEB", "A" )
From the specified connection, runs one of the following SQL statements:
‘select leadsourceid from leadsource where description = “lead value”’
(option D)
‘select leadsourceid from leadsource where abbrevdesc = “lead value” ‘
(option A)
See also