Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
JosephBunda
Contributor
Contributor

Talend - Salesforce Connector and "In" query

I'm attempting to retrieve records from Salesforce with an "in" query, like so:

"Select Id, Name From Account Where Id in ("+ context.ListOfIDs +")"

But I get a malformed query when I attempt this format. The input to the context variable is like so:

'0015C00000v1CahQAE','0015C00000w7W1uQAE'

It claims I'm missing the right parenthesis. I can confirm that this is how the query is normally formed in Salesforce, so does anyone know why Talend can't seem to interpret it correctly?

Labels (1)
1 Reply
JosephBunda
Contributor
Contributor
Author

Am I going to have to make a custom Salesforce connector to do this?