I would like to insert a few hundred records into a custom object. The custom object has a self lookup. The custom object use is to replace a series of dependent picklists, 3 levels deep.
For example, record 1 is the parent of record 2. Record 2 is the parent of Record 3.
At present there are no records in this custom object.
I know that it is possible to use workbench to insert all records in one go. However I'm struggling to use the smart lookup function and the documentation is extremely brief.
Here is a highly reduced version of the data and mapping i'm using:
Record 1: Name = a Parant = '' External_Id__c = a
Record 2: Name = b Parant = 'a' External_Id__c = b
Record 3: Name = c Parant = 'b' External_Id__c = c
When creating the mapping in workbench, I set the parentId to the parentID field in the CSV, and then the smart Lookup value to the object.external_id__c. This returns an error saying:
Foreign Key External ID: a Not Found For Field External_Id__c In Entity customObjectName
Can anyone tell me where I'm going wrong?
Note: I'm aware this can be done in multiple passes and also Talend.