My company is loading 3rd-party data into SalesForce using the BulkAPI (Python). This data is loaded into 3 SalesForce objects: Account, Contact, and Opportunity using 'upsert' method with Account External ID based on incoming data.
The problem comes with associating Contact and Opportunity object to Account object. The API call returns an ID similar to
0016A00000ACjUv (AccountId), which presumably I should use as unique identifier for Contact and Opportunity (using field name ID). However, this returns error:
0016A00000ACjUv' is not a valid Salesforce ID for the type Contact"
I've tried number of variations and all of them have fail.
job = bulk.create_upsert_job('Contact', 'Id', contentType='CSV', concurrency='Parallel')
job = bulk.create_upsert_job('Contact', 'AccountId', contentType='CSV', concurrency='Parallel')
Has anyone experienced this and what solution would you recommend?