Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Am I going to have to make a custom Salesforce connector to do this?