You are not logged in.
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:
,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,
Last edited by mlounas (2012-05-24 23:21:32)
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.