Hi there,
I'm trying to return just the live Accounts through SOQL but when I attach status to the where clause it errors, is the Status column in the accounts table or do i need to join to another table? Whats the best way to find the whole schema?

Thank you

Dave.
 

Think my Google skills have failed today!

I'm trying to write a C# app to access the Rest API and I have the following SOQL, It gives me all accounts as expected.
 

SELECT id FROM Account

Now I want only live accounts, however, the following isn't working, am I missing something?
 

SELECT id FROM Account WHERE Status = 'Live'

Cheers for any assistance!

 

Hi there,
I'm trying to return just the live Accounts through SOQL but when I attach status to the where clause it errors, is the Status column in the accounts table or do i need to join to another table? Whats the best way to find the whole schema?

Thank you

Dave.