Export or import NetSuite multiple select fields

NetSuite multiple select field types allow you to include multiple values in a single field. The image below shows a multiple select custom field (Copy Employees) that pulls from the employee records list.

You can select multiple items to include in the custom field. Two employees are selected in the following screen:

The field includes all selected items after you save your selection.

Export a multiple select field from a scheduled flow

In a scheduled flow that uses a saved search, integrator.io exports the multiple select field as a string with each value separated by a comma.

Export a multiple select field from a real-time flow

In a real-time flow (one initiated by a webhook listener), integrator.io exports a multiple select field as an array of objects, and each object contains a selection from the list on the export record. If the field contains a list of records, then each object has an internal ID property and a name property. Continuing from the previous example, the Copy Employee field’s internal ID is custbody17, so it exports as property custbody17 with an array of objects as the value type, for example:

...
    "custbody15": "Wally Morton",
    "custbody17": [
      {
        "internalid": "1524",
        "name": "Aiden Somerhalder"
      },
      {
        "internalid": "25",
        "name": "Amy Nguyen"
      }
    ],
    "custbody16": "(800) 555-0609",
...

Import mapping for multiple select fields

To map multiple values to a multiple select field, use either an array of the values (name or internal ID) or a string of comma-separated values without spaces. The following example shows a hard-coded string of name values separated by commas without spaces mapped to the Copy Employees field.

The following example demonstrates a string of internal ID values for employee records mapped to the Copy Employee field. The internal IDs are separated by commas without spaces. The NetSuite field is Copy Employees (InternalId), instead of Copy Employees (Name), as shown above.

The following array of values is then mapped to the Copy Employees multiple select field in this example. The Copy Employees (Name) property is mapped to the multiple select field:

{
  "id": "341",
  "recordType": "salesorder",
  "Copy Employees": ["Brandy Dickens", "Aiden Somerhalder", "Jill Muscat"],
  "Internal ID": "341"
}

You can use the same strategy with internal IDs. In the example below, the Copy Employees property is an array of internal ID numbers. The property is mapped to the Copy Employees (InternalId) field.

{
  "id": "341",
  "recordType": "salesorder",
  "Copy Employees": [
    1524,
    912
  ],
  "Internal ID": "341"
}