Hi, Is there any API in Netsuite to export data fr...
# suitescriptt
Tanu
10/01/2020, 8:07 AMHi, Is there any API in Netsuite to export data from the saved search?
t
Tyn Guardian
10/01/2020, 9:34 AMwhen you run your saved search, there is already an excel icon located at the upper left
t
Tanu
10/01/2020, 9:39 AMI am Taking about suite script code that load saved seach
p
PNJ
10/01/2020, 10:23 AMIt's trivial to extract the results of a saved search into the file cabinet using
N/taskPNJ
10/01/2020, 10:25 AMSomething like this:
var searchTask = task.create({ taskType: task.TaskType.SEARCH});searchTask.savedSearchId = 123; // CHANGE THISsearchTask.filePath = ; // set this to where you want your CSVvar result = searchTask.submit();t
Tanu
10/01/2020, 10:35 AMHi @PNJ Thanks.. Once more thing .. How can I use the additional filter in Saved SearchId defined in Searchtask.savedSearchId
b
battk
10/01/2020, 11:23 AMnot a parameter available to you
battk
10/01/2020, 11:23 AMmake a new search which has the filter you need
t
Tanu
10/01/2020, 11:43 AM@battk can I use additional filters in the existing search using suite script
b
battk
10/01/2020, 11:54 AMgo through the parameters of task.create and task.SearchTask to see your available options
battk
10/01/2020, 11:54 AMdont expect parameters that arent listed to work
a
Ava
10/01/2020, 1:39 PMI don't know if this will help you out at all but there's a great chrome extension that allows you to create a saved search and then export the code that would recreate the search in SuiteScript. I use it all the time.
https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp?hl=en-US
5 Views