ExtendInsights now supports Creating/Updating of records using External Id. Simply add the field External ID to your ExtendInsights template. In a template when both Internal Id and External Id are present, InternalId always gets the preference. Following is the Update/Insert behavior based on the availability of Internal Id/External Id in the template.
Internal ID | External ID | ExtendInsights Behavior for Upload Operation |
Yes | Yes | Updates based on InternalID. If ExternalID given in sheet is not same as the externalID in NetSuite. ExtendInsights will update the ExternalId in the existing record. |
Yes | No | Updates based on InternalID |
No | Yes | Updates based on ExternalID.If externalID given in the sheet is not present in NetSuite, ExtendInsights will create a new internalID and map the ExternalId to this new record |
No | No | Create a new record with new InternalID |
Add the field External ID to your ExtendInsights template.