Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Salesforce/SOQL: How to retrieve all column names from Account?

I am trying to retrieve all the column names from Salesforce by SOQL Query that I get via Pentaho as well with the following code

select QualifiedApiName
from FieldDefinition 
where EntityDefinition.DeveloperName='Account'

Pentaho lists 65 fields, the query only 50. The following fields are missing (list contains 16 instead of 15 fields for some reason)

BillingStreet
BillingCity
BillingState
BillingPostalCode
BillingCountry
BillingLatitude
BillingLongitude
BillingGeocodeAccuracy
ShippingStreet
ShippingCity
ShippingState
ShippingPostalCode
ShippingCountry
ShippingLatitude
ShippingLongitude
ShippingGeocodeAccuracy

Would you mind telling me the SOQL code I need in order the get all the 65 fields? Would appreciate that!

like image 990
notAnExpert Avatar asked Nov 01 '25 18:11

notAnExpert


1 Answers

Go to Developer Console,
Open Account Object

enter image description here

New window will open, select all the fields(Ctrl A or drag)
and click on Query
Below window will have all the fields queried

enter image description here

like image 132
Ali Azam Avatar answered Nov 04 '25 01:11

Ali Azam