+ Start a Discussion

Excel Connector Sfemail/soql_table function

Hi there,

not sure if this is the right group but wonder if there is a way from the excel connector using the "Sfemail" or the "soql_table" function , to retrieve the contact ID but only contacts that are part of Accounts with a certain field Value.

In other words, I wanted to get contacts that are ONLY part of Accounts with the "Status = Active" . I was tryong something like this but no success so far:

soql_table("Contact","Email = B1 and AccountID in soql_table("Account","Status = 'ACTIVE' ")  ")

Can we do a Soql within a Soql ?

Thanks for the help!!