Skip to main content
All CollectionsExtendInsights for Data Management NetSuiteTips & Tricks
Tips & Tricks: Can I create and update records using External ID in ExtendInsights for Data Management NetSuite?
Tips & Tricks: Can I create and update records using External ID in ExtendInsights for Data Management NetSuite?

ExtendInsights Data Management | Using the External ID in ExtendInsights for Data Management

Updated over 4 months ago

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.

Did this answer your question?