Thanks, the query is against Contact structure. This works with a fixed ContactId. My need is to query some contacts coming from a external source, and decide whether to make an update on SFDC.

Anzar.

Dear All,

I need to set a where clause with a dynamic variable in query condition of a tSalesforceInput component.

I got a "MalformedQueryFault" error when i execute my job.

The query condition is the following:

"select Id,OwnerId,Email,Salutation,MailingPostalCode,Birthdate
,MailingState,Description,HasOptedOutOfEmail,DoNotCall
,LastName,MailingCountry
,FirstName,MailingStreet,Fax,Phone,MobilePhone,Title, MailingCity from Contact
where Id= '" +(String)globalMap.get("ContactId")+ "' "

I have set the following globalmap to store the ContactIds in a tJavaRow, i don't know if this is possible:

globalMap.put("ContactId", input_row.ContactId);    (input_row.ContactId is a result of tMap branch which mapping data coming from a csv file)

All the best,

Anzar