In suitescript 1, get Country numeric ID from two letter country code

AI generated answer (using internal Slack threads):

In SuiteScript 1.0, there is no direct way to get the Country numeric ID from a two-letter country code. However, in SuiteScript 2.0, you can use the

N/query

module (also known as SuiteQL) to fetch this information from the country table in the NetSuite database. Here is a sample code snippet that demonstrates how to get the country ID from the country name using SuiteQL:

javascript
require(['N/query'], function(query) {
    function getCountryIdFromName(countryName) {
        const sql = `SELECT id FROM country WHERE name = ?`;
        const results = query.runSuiteQL({
            query: sql,
            params: [countryName]
        }).asMappedResults();
        return results.length ? results[0].id : null;
    }

    getCountryIdFromName('Australia');
});

In this example, the function

getCountryIdFromName

takes a country name as an argument and returns the corresponding country ID. The

query.runSuiteQL

function is used to execute the SQL query. Please note that the country table in NetSuite might not be exposed to regular saved searches, and the country IDs might not be accessible via a regular search or workflows. Therefore, using SuiteQL is the recommended approach to fetch this information. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******