How should i create csv file with saved search results

create A csv file

Rookie Asked on December 19, 2023 in SuiteScript.
Add Comment
2 Answer(s)

Reformat your search results as an array of JSON then use papaparse library to “unparse” that to CSV.

Beginner Answered on December 19, 2023.
Add Comment

You can use the N/Task module, which has an API (searchTask?) that lets you specify a Saved Search and a file cabinet location. It will run the search and save the results as a CSV.

You can call it from a Scheduled script, for instance.

Rookie Answered on December 22, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor