While syncing orders or customers from Shopify to NetSuite, graphQL query returns Country Code from Shopify.
This country Code can be mapped directly to NetSuite Country code.
Setup > Company > State/Province/County
addresses
{
name
address1
address2
company
city
country
provinceCode
zip
phone
countryCode
firstName
lastName
}
The Country Code can be matched with query in NetSuite:
let queryResults, sql;
sql = `SELECT id, name FROM country WHERE name = '${countryName}';`
queryResults = query.runSuiteQL({ query: sql }).asMappedResults();
if (queryResults[0].id) {
sql = `SELECT id, name FROM country WHERE name LIKE'%${countryName}%';`
queryResults = query.runSuiteQL({ query: sql }).asMappedResults();
}
let countryCode = queryResults[0].id ? queryResults[0].id : null;