This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone here know if there is any way to access via api a saved report?    My client has 3 'saved' reports that they email to us weekly and I want to download them via API.  app/reporting/reportrunner.nl?cr=479     Any api way to HIT ID 479 ??  Download a CSV?  Thanks in advance

You might be able to use the Excel Web Query feature for that

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_N745334.html>

I confirm, this approach works. Is not really clear how the authentication is done, I've also asked Netsuite for clarifications but I never got. It could be that is not really secure and they don't want to say it explicitly

There isn't any authentication. It's mentioned on the documentation page I linked to.

```Check that you are not breaching your organizations security policy before distributing .iqy files to other users. The files are personalized and generated for your use only. A recipient of such a file would have the capability to run the report at any time in the future and see the same live data that is available to you – even if the recipient's role would not normally give them access to such data. The only requirement to view the report is the login details (email address) used when creating the report. This address could be guessed by the recipient.```

THank you so much Michoel! But how the auth work since is using username / password as described here?