Hello, I am trying to get the value of the file.internal id in a search. what am I doing wrong?

I am assuming mySearchResult is your search object. If the below doesn't work please share the above code as well.

mySearchResults.run().each(function(result) {
    var fileid = result.getValue({
        name: 'internalid'
    });
    log.debug("fileid", fileid);
    return true;
});

its still not working. I have it json format:

working with netsuite objects and logs relies on knowing that the log lies about the object

got it. so how can I get the value of file.internalid?

first off you need to learn how to work with arrays

message has been deleted

after you learn how to get to the individual elements of the array. you need to learn how to properly use the parameters to getValue

ok

again , you havent shared enough code, but my guess is that your file variable is the N/file module, and that module has no property named internalid

if you can share the code from line 159 till 178, it will become easier to provide you the solution. Instead of a pic

var fileName = 'vendorlistfortr.csv' var mySearchResults = search.create({ type: 'folder', filters: [ ['internalid','is', 307416], 'AND', ['file.name','is', fileName] ], columns: [ search.createColumn({ name: 'internalid', join: 'file' }) ] }).run().getRange({ start: 0, end: 1 }); log.debug('mySearchResults',mySearchResults);

use this

var folderSearchObj = search.create({
    type: "folder",
    filters:[
       ["internalid","anyof","307416"], 
       "AND", 
       ["file.name","is", fileName]
    ],
    columns:[
       search.createColumn({name: "internalid",join: "file",label: "Internal ID"}),
    ]
});
var searchResultCount = folderSearchObj.runPaged().count;
log.debug("folderSearchObj result count",searchResultCount);

var result = folderSearchObj.run().getRange({
    start: 0,
    end: 1
});

for (var index = 0; result.length - 1 >= index; index++) {
    var fileid = result[index].getValue({name: 'internalid'});
    log.debug("fileid", fileid);
}

its not returning a value for fileid

I had one typo in the code, you can use now

it worked

Do log the output from search.create() And search.run().getRange(). And go to helpcenter as well and search for the same. Will help you understand a bit better.

yes. thank you!