SOQL query for fetching country, city of an account

Question

I am new to SOQL. How do I fetch the country,state,city of an account?

I have tried this but have an error.

Select AccountNumber,name, BillingAddress.City from Account 

Answer 1

Here you can found a list of all SOAP API fields accepted in Account (standard fields)

Account SOAP API

If you need the Billing Address fields you can use:

SELECT Id, Name, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry FROM Account

or with ShippingAddress...

SELECT Id, Name, ShippingStreet, ShippingCity, ShippingState, ShippingPostalCode, ShippingCountry FROM Account

even you can retreive Longitude and Latitude from each one.

Good luck!

Answer 2

BillingCity
BillingCountry
BillingState 

are the correct API Names

To check the object's field correct API Name use describe call in developer console and check all fields label Name and corresponding API Name in debug log

for(Schema.SobjectField strFld: Account.SobjectType.getDescribe().fields.getMap().Values())
{
    system.debug('-----Label Name----'+strFld.getDescribe().getLabel()+'-------API Name--'+strFld.getDescribe().getName());
}

---

Select name, BillingCity, BillingCountry, BillingState from Account