How To Pass a Parameter to a SQL Lookup map function?

Document created by anton_serbanescu Employee on May 21, 2014
Version 1Show Document
  • View in full screen mode
How To Pass a Parameter to a SQL Lookup map function?

I have the following SQL statement:

select salesforceid from MarketingContactXref where EmailAddress = input

and input is one of the parameters, but is not used .

What needs to be done?
Change the SQL :

select salesforceid from MarketingContactXref where EmailAddress = input

to

select salesforceid from MarketingContactXref where EmailAddress = ?

Then the input or any elements on the inbound will be treated as parameters.
3 people found this helpful

Attachments

    Outcomes