Showing posts with label bulk query. Show all posts
Showing posts with label bulk query. Show all posts

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