We're trying to set up a bulk API connection between a BI data warehouse and our Salesforce instance. This works like a charm with all objects except the standard Account object. We're working in a Person Account environment, but want to fetch both Business Accounts and Person Account.

We're running the following command:

"C:\DW\Salesforce\cURL\curl.exe" -H "X-SFDC-Session: XXX" -H "Content-Type: application/xml; charset=UTF-8" -d @"C:\DW\Salesforce\Input\CreateJob_Account_input.xml" -k -o "C:\DW\Salesforce\Output\CreateJob_Account_output.xml" https://eu1-api.salesforce.com/services/async/25.0/job

With Input:

query Account Parallel CSV

This returns the following output stating that 'Account' is not supported by Bulk API.

<?xml version="1.0" encoding="UTF-8"?>
<error xmlns="http://www.force.com/2009/06/asyncapi/dataload"> 
<exceptionCode>InvalidEntity</exceptionCode>
<exceptionMessage>Entity 'Account' is not supported by the Bulk API.</exceptionMessage>
</error>

Any sugestions on how to fix would be greatly appreciated :-)

Attribution to: Christopher Eikanger Andersen

Possible Suggestion/Solution #1

That's weird. Are you inserting only supported fields when inserting a person account? Certain fields in accounts are not available for person accounts. Also, are you setting the correct record type for each type of account?

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_account.htm

Attribution to: PepeFloyd

Possible Suggestion/Solution #2

I think your issue may be that you're trying to get both types of Account in one step — you should split the operation into business accounts (i.e. where IsPersonAccount = false) and person accounts (where it's true), being sure to only have the relevant fields in each of the queries.

Looking through the Bulk API documentation there's nothing to suggest that the Account object is treated any differently to other objects, and it does mention using accounts in various places:

Use the code sample in this section to create a test client application that inserts a number of account records using the REST-based Bulk API.

J Job, Bulk API A job in the Bulk API specifies which object is being processed (for example, Account, Opportunity)

Attribution to: Matt Lacey
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/3462