Thursday, January 28, 2016

Selecting compound data not supported in Bulk Query

There isn't much out there on this error.  Before doing any data update, I like to export the target object's full data set as a precaution.  My tool of choice is workbench but sometimes it can be a little baby and complain like "Selecting compound data not supported in Bulk Query". 

Turns out that the following fields are going to make your bulk api export fail:


  • Address fields like:
    • Billing Address
    • Shipping Address
  • Latitude and Longitude fields like:
    • BillingLatitude
    • BillingLongitude


These are your most common "compound" fields.  Once you remove these fields from your export, you should be ok.

Source: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/compound_fields.htm