You need to sign in to do that
Don't have an account?
pcroadkill
upsert call creating duplicate accounts
I have a java program that gets data from or BI system and then either merges the data with an existing salesforce account record or creates a new one. When I submit the upsert call using the Id as the key, my expectation was that the records that contain an Id will be updated and the ones that don't, will be created. It seems that it always creates new records therefore creating duplicates.
I have read that the upsert api doc and refers to an externalId, but I have not found anything that states how to use the actual Object id as the key. In the REST api doc and DML guides say to leave the key blank and it will use the object id, but in the SOAP API I don't seem to be able to do that.
Any help will bre greatly appreciated.
I have read that the upsert api doc and refers to an externalId, but I have not found anything that states how to use the actual Object id as the key. In the REST api doc and DML guides say to leave the key blank and it will use the object id, but in the SOAP API I don't seem to be able to do that.
Any help will bre greatly appreciated.
connection.upsert( "Id", sobject);
or
connection.upsert( "<18digitid>", sobject);