Entity Deduplication Tasks in NetSui...

The Entity Deduplication Task feature in NetSuite allows you to merge duplicate records, enhancing data integrity and reducing redundancy across your system. This feature utilizes the N/task module, which facilitates various asynchronous tasks within NetSuite, including merging duplicate records.

What is the EntityDeduplicationTask?

The EntityDeduplicationTask is a specific task type designed to handle the merging of duplicate records in your NetSuite account. It is accessible through SuiteScript and plays a crucial role in maintaining a clean and organized database.

Key Methods and Properties

The EntityDeduplicationTask provides a set of methods and properties that you can leverage:

Member Type	Name	Return Type / Value Type	Supported Script Types	Description
Method	EntityDeduplicationTask.submit()	string	Server scripts	Directs NetSuite to place the merge duplicate records task into the task queue and returns a unique ID for the task.
Property	EntityDeduplicationTask.dedupeMode	string	Server scripts	The mode in which to merge or delete duplicate records. Use values from the `task.DedupeMode` enum.
Property	EntityDeduplicationTask.entityType	string	Server scripts	The type of entity on which to merge duplicate records, using a `task.DedupeEntityType` enum.
Property	EntityDeduplicationTask.id	string	Server scripts	The ID of the task.
Property	EntityDeduplicationTask.masterRecordId	number	Server scripts	Master record ID to retain information from duplicate records while merging.
Property	EntityDeduplicationTask.masterSelectionMode	string	Server scripts	Master selection mode using values from the `task.MasterSelectionMode` enum.
Property	EntityDeduplicationTask.recordIds	number[]	Server scripts	Array of internal IDs for records targeted for merging or deletion.

How to Use the EntityDeduplicationTask

Create the Task: Utilize the EntityDeduplicationTask.create(options) method to create a new deduplication task.
Define Parameters: Set parameters such as dedupeMode, entityType, and recordIds to specify the merging process.
Submit the Task: Call the submit() method to enqueue the deduplication task within NetSuite's task management system.
Monitor Progress: Use the EntityDeduplicationTaskStatus object to check the status and verify the success of the merging operation.

Who This Affects

Administrators: Manage data integrity by utilizing deduplication tasks.
Developers: Implement and customize deduplication processes within SuiteScript implementations.
Data Managers: Oversight of data cleanliness and redundancy management.

Key Takeaways

The EntityDeduplicationTask helps maintain data integrity by merging duplicate records in NetSuite.
Asynchronous task management lets you handle multiple tasks simultaneously, optimizing performance.
Utilize the provided methods and properties to effectively create and manage deduplication tasks within your scripts.

Source: This article is based on Oracle's official NetSuite documentation.

Frequently Asked Questions (4)

Which script types are supported for using the EntityDeduplicationTask methods?

The EntityDeduplicationTask methods are supported in server scripts within NetSuite.

What must be specified when creating an EntityDeduplicationTask?

When creating an EntityDeduplicationTask, you must specify parameters such as dedupeMode, entityType, and recordIds to define the merging process.

How can I monitor the progress of a deduplication task after submitting it?

You can monitor the progress of a deduplication task by using the EntityDeduplicationTaskStatus object to check the status and verify the success of the merging operation.

What is the purpose of the masterRecordId property in EntityDeduplicationTask?

The masterRecordId property is used to specify the master record ID that retains information from duplicate records during the merging process.

Entity Deduplication Tasks in NetSuite SuiteScript