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 }); }

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 }); }

• search
• export
• netsuite
• suitescript
• saved-searches

Share Improve this question Follow asked Mar 20 at 12:46 Maira SMaira S 7166 bronze badges

Add a comment  | 

3 Answers 3

Sorted by: Reset to default 2

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();

Access Tokens are not a scriptable record, so you won't be able to export your results using SuiteScript. The alternative is to create a query/dataset and use that.

Finally, this query worked to get tokens created 2800 days ago:

 const sqlStr = `SELECT *
                FROM OAuthToken
                WHERE OAuthToken.bInactive = 'F'
                AND OAuthToken.dCreated < CURRENT_DATE - 2800`;
                
              const tokens = query.runSuiteQL({
                query: sqlStr,
                }).asMappedResults();