function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
DanGDanG 

"IN" Join Not Working

Hi--

Can someone explain to me why, when I use the IN join, I am getting an "Unexpected Token: Id" error?

It doesn't always happen, which makes it difficult to tell why it does.  Just now, I ran a query to pull a set of Contacts with the Account ID in column E.  Next, I wanted to pull some Account information for Accounts in the previous query.  A perfect time for "IN," right? 

But when I structured the query to find "Account ID IN E:E," I get an error message that says in full:

Salesforce: Query()
invalid Range, missing data type, or other error,
type is: Account

select id from Account where ID in 'E:E'
                             ^
Error at Row:1:Column:31
Unexpected token: Id


(And to make things more confusing for me, there is nothing in Column 31.)

Help?

Thanks,
Dan
IWyattIWyatt
You've probably got your solution by now, but just in case other people might have similar problems, one type of solution that I have found for conusing problems with "IN" joining is making sure that I am logged into the 7.0 server.
 
What I mean, is when you log into the Execel Connector, the default server url is
 
You can change the "6.0" to "7.0" and it seems to function better when querying related objects. There is also a way to make the default URL "7.0" by checking under "options" within the Excel connector.
 
IW
JGohJGoh
Hi
 
I'm encountering error message when using IN Join feature.
Need some help on this... Many thanks