Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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 (1)
1 Reply
JosephBunda
Contributor II
Contributor II
Author

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