Saved Search to CSV via Netsuite Suitescript

[@akshatjain7188]

I want to get the Saved Search Data to the external application like AWS/Azure/postman using RESTlet API. How can I do that?

[@shobipersonal]

Well, there are two possible approaches : If you want to pull the data from nertsuite then you can use Rest Api , you can get the step by step detail from chat GPT or any publicly available AI tool , other options is to push the data from Netsuite to AWS/Azure then you can setup a mapreduce or scheduled script to call the AWS API or custom lambda function to push the data. Let me know if you need further assistance.

[@monikaphalle9174]

Why mainline true in saved search? And how we can read data in that excel file using Suitscript?

[@daviddjkedbek-ultra]

is there a way to keep refreshing the data within the same file using the same script?

[@shobipersonal]

Keeping the same file name at same path will overwrite the data.

[@daviddjkedbek-ultra]

Thanks for the quick turnaround @@shobipersonal it worked as mentioned only having an error when running the scheduled version (ReferenceError: "require" is not defined) have you encountered this? is there a quick way to update the .js to correct this

[@shobipersonal]

@@daviddjkedbek-ultra need to check your code, how are you loading the libraries ? In script it should be define instead of require.

[@oscarsagales5157]

Good Video!
You can edit savedSearch filters with this method:
const indexOfSearch = search.filters.findIndex(object => {
return object.name === 'internalid';
});

if(indexOfSearch >= 0) search.filters.splice(indexOfSearch, 1);

search.filters.push(n_search.createFilter({
name: 'internalid',
join: 'invoice',
operator: 'anyof',
values: record.id
}));
search.save();

[@obamania2009]

how come you didn't include the code?

[@shobipersonal]

Sorry, didn't get you

[@pranjalikhadse326]

when I try the exact code it gives me error SSS_MISSING_REQD_ARGUMENT. Do you know how to resolve it

[@shobipersonal]

Share your code

[@its_me_N_I_H_A_L]

if my result is more than a million rows then is that work?

[@shobipersonal]

Haven't tested, but it has file size limit as per file cabinet.