9

Attempting to retrieve address fields (such as BillingAddress on Account) via Bulk API gives an error:

Failed to process query: FUNCTIONALITY_NOT_ENABLED: Selecting compound data not supported in Bulk Query

Sure enough, the Bulk API docs say:

Bulk API can’t access or query compound address or compound geolocation fields.

Is there really no way to access address and geolocation data via the Bulk API?

2 Answers 2

7

There is a clue in this help page on compound fields:

Compound fields can't be included in Bulk queries. Use the individual field components to access or update field values.

It turns out that you can use the component fields like so:

SELECT BillingStreet, BillingCity, 
       BillingState, BillingCountry, BillingPostalCode, 
       BillingLatitude, BillingLongitude
FROM Account
1

In fact, you can safely remove compound fields from your export as they're read only and updatable only by its component fields. Look for "Address" or "Geolocation" type fields, remove them from your select/query and voila.

For Account, in my case I removed ShippingAddress, BillingAddress and a custom geolocation field.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.