NetSuite Connector Error in Mapping ‘field country’

NetSuite Connector Error in Mapping ‘field country’

book

Article ID: KB0078242

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) NA

Description

When mapping the contact address from HubSpot to NetSuite, the map is skipping the Create block.  When run in Debug, the following error is returned:

Result.ErrorDescription:  An unexpected error occurred.
Result.ErrorDetail:  The following error has occurred in the NetSuite Connector:  The value ‘TZ’ is not valid for ‘country’
 

Issue/Introduction

Mapping the 2 character country code in the HubSpot to NetSuite contact address integration results in error: Error in mapping ‘field country’ for Operation ‘Create’

Resolution

The NetSuite Connector expects the country field to be in the format _countryName, where there is always an  underscore before the name.  For this example, mapping the value “_tanzania” successfully created the contact address in NetSuite.

Reference the NetSuite Connector Help for additional information.

In the Standard Entities section, see the information on the ContactAddress and CustomerAddress entities:
  • country — The value must be in the form _countryName (case-sensitive). For example, _unitedStates or _france. Scribe recommends using Lookup Functions when mapping this field.