ANS-1605 · WEB SERVICES & INTEGRATIONS
How to Clear or Blank Field Values in NetSuite Web Services Integrations
This article explains how to effectively clear field values, including text and dropdowns, using NetSuite's Web Services API for robust data management.
Short answer
To blank a field in NetSuite Web Services, utilize the nullFieldList for dropdowns and other field types. For text fields, sending an empty string value is typically sufficient. These methods ensure accurate data manipulation when integrating with NetSuite via its API.
Scenario
Users often need to clear or blank out existing field values in NetSuite records when integrating via Web Services. This requirement arises when an external system needs to remove data from a NetSuite field, rather than just updating it with a new value. Understanding the correct API methods is crucial for successful data synchronization.
Solution
To clear or blank field values in NetSuite via Web Services, the following methods should be employed:
For most field types, including Select (Dropdown) fields: The nullFieldList in the Web Services API should be used. By including the internal ID of the target field within the nullFieldList of your API request, NetSuite will explicitly set that field's value to null. This is the only reliable method for clearing Select (Dropdown) fields.
For Text fields: It is generally sufficient to send an empty string value for the specific text field within your Web Services request. This action will clear the existing text content of the field.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support