Upsert - what are the criteria for external ID fields?

139 views
Skip to first unread message

Laughlin Elkind

unread,
Mar 28, 2012, 3:03:45 AM3/28/12
to Workbench News & Discussion, lel...@zynga.com
Hi there,

I'm working on my own tool using the Salesforce Python Toolkit, and
part of what I'm doing involves performing upserts on a variety of
objects.

One of the awesome things about workbench (and one of the reasons why
I hardly use the SFDC data loader) is that workbench allows you to
choose fields other than Id to use as the external ID during an
upsert.

My question is: How does workbench determine which fields are valid
for use as an external ID? I thought it was only that the idLookup
flag was set to true on the field, but I've found examples where that
isn't the case.

I did try to pull apart the source to figure this bit out on my own,
but unfortunately my PHP skills are pretty nonexistant.

Thanks for any and all tips anyone can provide!

Laughlin Elkind

dsc...@gmail.com

unread,
Mar 28, 2012, 11:48:28 AM3/28/12
to forcewo...@googlegroups.com, lel...@zynga.com
Fields are set as External ID during configuration in Salesforce. Workbench looks for all fields designated that way.

Christian G. Warden

unread,
Mar 28, 2012, 10:48:25 AM3/28/12
to forcewo...@googlegroups.com, lel...@zynga.com

There's an externalId flag on fields:
http://bit.ly/HfUONf

Christian

Reply all
Reply to author
Forward
0 new messages