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 Scribe Online 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’
 

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.

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’