How to Find the Internal ID of a Custom Record by a Specific Field Value

To retrieve the internal ID of a custom record based on a specific field's value, implement a SuiteScript 2.x search. This involves creating a search filter for the target custom field and its value, then executing the search and extracting the internal ID from any matching results.The following SuiteScript 2.x example demonstrates how to perform this operation:

javascript/** * @NApiVersion 2.1 * @NModuleScope SameAccount */define(['N/search'], function(search) {    function getCustomRecordInternalId(customRecordTypeId, customFieldId, fieldValue) {        var internalId = null;        var filters = [];        filters.push(search.createFilter({            name: customFieldId,            operator: search.Operator.IS,            values: fieldValue        }));        var customRecordSearch = search.create({            type: customRecordTypeId, // e.g., 'customrecord_xxx'            filters: filters,            columns: ['internalid']        });        customRecordSearch.run().each(function(result) {            internalId = result.id; // Access the internal ID directly            return false; // Stop after the first match        });        return internalId;    }    // Example usage:    // var recordId = getCustomRecordInternalId('customrecord_mycustomrecord', 'custrecord_soid', 'XXX');    // log.debug('Found Internal ID', recordId);    return {        getCustomRecordInternalId: getCustomRecordInternalId    };});

In this script, customRecordTypeId should be replaced with the script ID of your custom record (e.g., customrecord_xxx), customFieldId with the script ID of the relevant custom field (e.g., custrecord_soid), and fieldValue with the specific data you are searching for (e.g., XXX). The result.id property is used to directly access the internal ID of the found custom record within SuiteScript 2.x search results.