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

AI generated answer (using internal Slack threads):

In SuiteScript, you can get the country numeric ID from a two-letter country code by using SuiteQL. Here is a code snippet that demonstrates how to do this:

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 country name is used as a parameter in a SuiteQL query that selects the ID from the country table where the name matches the provided country name. The results are then mapped and the first result's ID is returned. Please note that this approach requires the country name, not the two-letter country code. If you only have the two-letter country code, you would need to have a lookup table to convert the two-letter country code to the full country name before using this function. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******