AnsweredAssumed Answered

Nested query in salesforce connector. Is it possible?

Question asked by george.drosoulakis on Nov 8, 2016
Latest reply on Nov 10, 2016 by Adam Arrowsmith

Trying to run a soql query with a subquery nested in the where clause. How is it possible to achieve it?


I tried using the filter option in the salesforce operation using an "IN" operator but it didn't work. Also for some reason I tried using just a list of values with the IN operator but it didn't work as well.


Keep getting the following error:

MALFORMED_QUERY: UserOrGroupId FROM AccountShare WHERE ( ) LIMIT 20 ^ ERROR at Row:1:Column:58 unexpected token: ')';

Seems like the filter is not being sent and the where clause is just empty.



Any ideas?


Thank you