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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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?