https://community.qlik.com/t5/Data-Movement-Streaming/Talend-Salesforce-Connector-and-quot-In-quot-query/m-p/2452840#M2295 <P>Am I going to have to make a custom Salesforce connector to do this?</P> Wed, 15 May 2024 16:24:14 GMT JosephBunda 2024-05-15T16:24:14Z https://community.qlik.com/t5/Data-Movement-Streaming/Talend-Salesforce-Connector-and-quot-In-quot-query/m-p/2452436#M2289 <P>I'm attempting to retrieve records from Salesforce with an "in" query, like so:</P> <P>"Select Id, Name From Account Where Id in ("+ context.ListOfIDs +")"</P> <P>But I get a malformed query when I attempt this format. The input to the context variable is like so:</P> <P>'0015C00000v1CahQAE','0015C00000w7W1uQAE'</P> <P>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?</P> Wed, 19 Mar 2025 21:58:43 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Talend-Salesforce-Connector-and-quot-In-quot-query/m-p/2452436#M2289 JosephBunda 2025-03-19T21:58:43Z https://community.qlik.com/t5/Data-Movement-Streaming/Talend-Salesforce-Connector-and-quot-In-quot-query/m-p/2452840#M2295 <P>Am I going to have to make a custom Salesforce connector to do this?</P> Wed, 15 May 2024 16:24:14 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Talend-Salesforce-Connector-and-quot-In-quot-query/m-p/2452840#M2295 JosephBunda 2024-05-15T16:24:14Z