[SalesForce] How to retrieve compound fields like address using Bulk API

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

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?

Best Answer

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

Related Solutions

[SalesForce] Bulk API Query – Splitting large query into batches

Hi Tom for your question we need to divide this requirement into two parts:-

1) Retrieving the data from BulkApi queries, I hope no problem for you in that.

The data will get recieved in the form of files with the max. size per file is 1GB.

So as soon as u will get a CSV file out there the second task is to parse this first CSV file(considerring 2-3 more files are in quue) into the salesforce in batches.

So your second requirement will get fulfilled with the help of the function available here:- http://boards.developerforce.com/t5/Apex-Code-Development/Batch-Insert-of-Records-in-CSV-file/td-p/131413

This function will parallely start your procedure. and combination of two fulfill your task completly

[SalesForce] Confused about the API options to

to set the sessionId header you want

req.setHeader("X-SFDC-Session", result.sessionId);

see the docs for an example request. (the Bulk API uses something different than the regular REST API).

Also, look a the response body you get from your request, it'll have more info on why its wrong, e.g. when i make a request with the same path you have, i get

> GET /services/async/u/10.0/job/123/batch/123 HTTP/1.1
> User-Agent: curl/7.21.4 (universal-apple-darwin11.0) libcurl/7.21.4 OpenSSL/0.9.8x zlib/1.2.5
> Host: na1.salesforce.com
> Accept: */*
> X-SFDC-Session: [SomeSessionId]
>
< HTTP/1.1 400 Bad Request
< Date: Wed, 21 Aug 2013 17:16:07 GMT
< Content-Type: application/xml
< Transfer-Encoding: chunked
<
<?xml version="1.0" encoding="UTF-8"?><error
   xmlns="http://www.force.com/2009/06/asyncapi/dataload">
 <exceptionCode>InvalidUrl</exceptionCode>
 <exceptionMessage>unknown version: u</exceptionMessage>

The docs also have details on the correct URI patterns to use.

Best Answer

Related Solutions

[SalesForce] Bulk API Query – Splitting large query into batches

[SalesForce] Confused about the API options to

Related Topic