Home SALESFORCEAPEX How to get the Salesforce Account Object Address details using SOQL?

How to get the Salesforce Account Object Address details using SOQL?

Salesforce Account Objects Contains Two Address fields and Account and geolocation its seems like a compound fields.
1) Billing Address
2) Shipping Address

Billing Address Fields:-
BillingStreet
BillingCity
BillingCountry
BillingState
BillingPostalCode
BillingLatitude
BillingLongitude

Billing Address Field SOQL Query:

SELECT Id, Name, Email, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, BillingLatitude, BillingLongitude FROM Account

Shipping Address Fields:-
ShippingStreet
ShippingCity
ShippingCountry
ShippingState
ShippingPostalCode
ShippingLatitude
ShippingLongitude

Shipping Address Field SOQL Query:

SELECT Id, Name, Email, ShippingStreet, ShippingCity, ShippingState, ShippingPostalCode, ShippingCountry, ShippingLatitude, ShippingLongitude FROM Account

Address Compound Fields

Compound Field Considerations and Limitations

You may also like

Leave a Comment