topic Dynamic query condition in tSalesForceInput in Talend Studio

Dynamic query condition in tSalesForceInput

Anonymous — Sat, 16 Nov 2024 12:16:55 GMT

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

Re: Dynamic query condition in tSalesForceInput

Anonymous — Fri, 25 May 2012 04:50:11 GMT

Hi Anzar
Try to give a fixed value of Id and test whether you still get this error.
I guess the query may be against the structure of Contact.
Regards,
Pedro

Re: Dynamic query condition in tSalesForceInput

Anonymous — Fri, 25 May 2012 07:33:26 GMT

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.