Error
When importing a NetSuite address with a country name or country code you may receive an error similar to this:
Error in ‘NetSuiteDestination’. Line ‘Customer Address’. Parameter ‘country’. Parameter set value event. Requested value ‘US’ was not
Reason
NetSuite’s SOAP API uses a Country Enumeration. The Country Codes or Names, such as ‘US’ or ‘United States’, do not match the enumerations used in NetSuite’s database. For detailed information, refer to the NetSuite Country Schema Enumerations documentation available on the NetSuite help site.
Resolution
To resolve this error, use the SmartConnect additional column feature, which translates the Country code to the NetSuite Country Schema enumerations.
Steps to resolve
- Create a Translation table in SmartConnect using this Excel file.
- Then, use the Translation column in your integration.
- Map the Translation Additional Column to the country field.
Conclusion
Following these steps should resolve the country parameter error for NetSuite integrations.
You can use the same process for a country name translation by updating the spreadsheet with country names instead of ISO codes.
