Hi,

I've upserted a list of companies to Account with their original id placed into an external id field called "Account_ExtID".

I've got a second list of Child Accounts that I want to upsert. The mapping is the same for the most part, but now I'm also filling in the Parent ID which is the default Lookup field for account.

This is what I could find in the documentation of Pervasive for the Salesforce API connector

"(entityname:externalIdname:externalIdvalue)"

MAPPING: Parent ID = "(Account:Account_ExtID:"&Fields("Company_ID")&")"

ERROR: Upsert: error sf:INVALID_FIELD (INVALID_FIELD: No such column 'Account' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.)

Then I thought I shouldn't specify the entityname because he was checking for a column on the entityname location.

MAPPING: Parent ID = "(Account_ExtID:"&Fields("Company_ID")&")"

ERROR: Upsert error code MALFORMED_ID: Parent Account ID: id value of incorrect type: (Account_ExtID__c:300078)

I've done upserts with external id's several times already with Pervasive succesfully, but never on Account and never with both parent and child being the same object type.

What is the correct way to do this in this situation ?

Thanks in advance,

Joris