[SOLVED] UNABLE_TO_DETERMINE_RECORD_TYPE_FOR_SAVED_SEARCH_ID

UNABLE_TO_DETERMINE_RECORD_TYPE_FOR_SAVED_SEARCH_ID_1 error

There is a Nestuite saved search on access tokens. When I run the search in suitelet script, I am getting error as 'UNABLE_TO_DETERMINE_RECORD_TYPE_FOR_SAVED_SEARCH_ID_1'

Also when I try to export saved search from UI with export as script chrome extension, I am getting error as, This search type is not supported by suitescript error.

Is there any way to extract results from this kind of search? please advice Thank You!

This is saved search function: function generateSearchResultsTable() { let savedSearch = search.load({ id: 'savedsearchid' }); let searchResultIterator = savedSearch.run(); let results = []; let start = 0; let end = 1000; let resultSet = searchResultIterator.getRange({ start: start, end: end }); }

Solution

Tokens are not searchable with N/search but they are searchable with N/query. For example:

const sqlStr = `SELECT
    BUILTIN.DF(OAuthToken.tba_app_name),
    OAuthToken.dCreated,
    OAuthToken.createdBy,
    OAuthToken.bInactive,
    OAuthToken.id,
    OAuthToken.dRevoked,
    OAuthToken.bRevoked,
    BUILTIN.DF(OAuthToken.role_name),
    OAuthToken.tba_token_name,
    BUILTIN.DF(OAuthToken.entity_name)
FROM
    OAuthToken`

const tokens = query.runSuiteQL({
    query: sqlStr
}).asMappedResults();