Get the URL of Files attached to an Entity record via SuiteScript

To get the URL of files attached to an entity which can be found in the Entity record > Communications > Files subtab, we can use a search and get the column joined to a file object for the URL

Note: We can use the nlapiLoadFile but it would only work for files that are less than 5 mb.

Below is a sample code to retrieve the url of files attached to a vendor record.

// Load a saved searchvar Search = nlapiLoadSearch('vendor', 'customsearch744');// customsearch744 is a Vendor Search with "internalid" as filter and "File: Name", "File: Internal ID" and "File: URL" as columns in the results// Overwrite filter of the saved search to search for a specific Vendor with internal ID of '33'var filters = new Array();filters[0] = new nlobjSearchFilter( 'internalId', null, 'anyof', '33' );// Set the filtersSearch.setFilters(filters);// Run the saved searchvar SearchResultSet = Search.runSearch();// Get the resultsvar results = SearchResultSet.getResults(0, 1000);var number_of_results = results.length;var columns = new Array();columns = results[0].getAllColumns();nlapiLogExecution('DEBUG','Name', results[0].getValue(columns[0]));nlapiLogExecution('DEBUG','Internal ID', results[0].getValue(columns[1]));nlapiLogExecution('DEBUG','URL', results[0].getValue(columns[2]));