Hi all, Is there anyway i can export report data using Map/reduce or Scheduled Script? I don't want to use save search it's not give the the data you want in the report. Is there any way i can export the report data as csv in SuiteScript the way it's doing in the UI? I can schedule a report data send as csv in email attachment and send daily basis is there anyway i can get the attachment file and move it to the filecabinet. What I want is to export report data as csv to the filecabinet. Any response and any solution would be appreciated. Regards,

Yes, use a combination of the

N/file

and

N/email

modules in SuiteScript.

Hi @Edgar Valdes Thanks for your response, Can I pick a file from the email attachment? I checked the file cabinet, but I couldn’t find the attachment file there, nor in the user’s communication message tab. I have checked the Sent Email list there are no record there as well.

Your scenario is a little confusing to me. In what order are you doing the operation. When do you have the file, when do you send it, when do you want to grab it?

I want to export General Ledger report as csv data but has to be using a script I do not want to use the savesearch because it's not showing the correct columns and calculations. Possible Solution: -> Schedule a report as csv data, not sure how i will read email attachment.