Pass null values to NetSuite custom fields
Introduction
A limitation of the NetSuite API is that you cannot pass NULL or blank (empty string) values to custom fields in NetSuite.
Pass null values using Integration Studio
According to NetSuite's documentation on CustomFieldList, custom fields can be set to NULL by submitting the field in NetSuite's nullFieldList
.
In Integration Studio, you will not see nullFieldList
as a field or option.
Instead, you can pass NULL or blank (empty string) values to custom fields by mapping the source field to both the externalId
and name
fields of a target field.