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
Posted by at
Labels: , ,

5 comments:

  1. KatieSeptember 27, 2016 at 7:06 AM

    Thanks for the info, fixed my export. Cheers!

    ReplyDelete
  2. AnonymousJanuary 3, 2017 at 3:42 PM

    Nice. Helpful.

    ReplyDelete
  3. AnonymousFebruary 4, 2017 at 10:49 AM

    One gets the same error from Data Loader as well! Thanks for the explanation!

    ReplyDelete
  4. Rajendra ShettyFebruary 6, 2017 at 10:28 PM

    Any field in salesforce which is a formula field such as Name = First Name + Last Name, cant be imported using Bulk API. These are automatically populated by salesforce. NOTE: This also includes custom fields where you populate a custom field using formulas.

    Solution: Just don't include the compound field as part of your import mapping / field list

    ReplyDelete
  5. UnknownOctober 23, 2017 at 8:23 AM

    Thanks for the info!

    ReplyDelete

Subscribe to: Post Comments (Atom)