jsreport forum

Nazmus-Sadat

Hi guys!
I am trying to send the generated report as an email attachment. However, in the email, the attached excel cannot be opened as it is corrupted/invalid format. I think, it is an file format/data encoding issue because file retrieved from reportResponse['headers']['permanent-link'] works fine.
Here is the code to send email attachment:

   function(reportError, reportResponse, reportBody){
    attachments: [{
    content: Buffer.from(reportResponse.body).toString('base64'),
    type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
    filename: "report.xlsx",
    disposition: "attachment"}], }

Also, when I write the content to disk, I face the same issue:
require('fs').writeFileSync("D:\report.xlsx", reportResponse.body);

Any idea?
In which format Jsreport stores the report content in reportResponse? binary?

Thanks.

Nazmus

Nazmus-Sadat

Thank you! I will get back to you with my findings.

Nazmus-Sadat

So, I am trying another approach. Using the reports {save : true} option, I am saving the report to our server, and sending the following link to the client (from reportResponse['headers']['permanent-link'];):
http://localhost/reports/some-id/content

But this link requires the client to log into our jsreport server. is there any way so that the client can access this file link without login/authentication?

Nazmus-Sadat

Thanks for your response.
Basically, what I am looking for is to send a link of generated report to client. If I use that access token based link, the report is generated from the sample data stored in our jsreport server. It does not use the data sent in the request.

Nazmus-Sadat

Hi guys!
In Jsreport, there is an option for sharing templates, which allows users to download excel/pdf without authentication. Can we get that share link using API? If so, how to do that?

Thanks in advance.

Nazmus

Nazmus-Sadat

Yes. That's good enough.
Thanks.

Nazmus-Sadat

Great! Thank you.
Could you please let us know the updated max request size?

Nazmus-Sadat

The preview also worked for me except for one template. We could fix the issue.
The issue was with the size of json data we were using. Apparently, it was larger than the size supported by Jsreport. We reduced the size of the data and it worked.
This is the response we got:
https://view.officeapps.live.com/op/view.aspx?src=
http://jsreport.net/temp/
<html>
<head><title>413 Request Entity Too Large</title></head>
<body bgcolor="white">
<center><h1>413 Request Entity Too Large</h1></center>
<hr><center>nginx/1.13.12</center>
</body>
</html>

Many thanks.
Nazmus

Nazmus-Sadat

Hi.
Thanks for your response.
Version is 2.1.1

Nazmus-Sadat

Hello guys,
Suddenly, my jsreport preview (excel) in the right pane stopped working. I am receiving this error,
"File not found
The URL of the original file is not valid or the document is not publicly accessible.
Verify the URL is correct, then contact the document owner."

Any idea?

Thanks in advance.

Nazmus

Posts made by Nazmus-Sadat