Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
JosephBunda
Contributor II
Contributor II

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 (2)
1 Reply
JosephBunda
Contributor II
Contributor II
Author

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