All Collections
Excel For NetSuite Applications
CloudExtend Excel Data Management for NetSuite
Tips and Tricks
Tips & Tricks: Can I create and update records using External ID in CloudExtend Excel Data Management for NetSuite?
Tips & Tricks: Can I create and update records using External ID in CloudExtend Excel Data Management for NetSuite?

XLNS | Using the External ID in CloudExtend Excel Data Management for NetSuite

Updated over a week ago


CloudExtend now supports Creating/Updating of records using External Id.  Simply add the field External ID to your CloudExtend 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

CloudExtend Behavior for Upsert Operation

Yes

Yes

Updates based on InternalID. If ExternalID given in sheet is not same as the externalID in NetSuite. SmartClient will update the ExternalId in the existing record.

Yes

No

Updates based on InternalID

No

Yes

Updates based on ExternalID.Iif externalID given in sheet is not present in NetSuite, SmartClient 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 CloudExtend template.

Did this answer your question?