topic Jasperserver : get pdf output from reportExecutions in Talend Studio

Jasperserver : get pdf output from reportExecutions

abo — Fri, 15 Nov 2024 21:58:30 GMT

Hi everyone, i hope you're doing great. Couple years ago i didn't know how to use Talend, Jaspersoft. I have learned a lot by reading topics here. Thank you all =).

I am struggling with my JasperServer to export pdf.

I have a pdf output when i use Postman :

1 )i'm doing a post on my server :

http://jaspersoft.local/jasperserver/rest_v2/reportExecutions.

I get the result with requestId and exportId.

2) then i m doing a get to fetch the document :

http://jaspersoft.local/jasperserver/rest_v2/reportExecutions/

/exports/

/outputResource

=> attachment 1

Now i would like to do it with Talend.

I retrieve a string like this :

�# ��sDR�U=�9zĪ�7G�h��p��\�=fWm�X��]��z�# C��8��N,�# ��֑�q4DGf�a �9�k��X�# ߹&p=��f��,��\�]�m��z=��l�&�\K��Km�XZG��\K�f��s�9k��kv�f�j��z$X��5;��Q�PܦSu�m �

��Q�;u��># ��tT�8XG&�# �j� ��o=p��JOm��!�>/V�m�E:7D��`M`�=��=W��ݾ_��oH벧�n �F��> =M�Mj�C��z�f&�k

I don't know how to convert this into a readable pdf and of course how to output it.

I beg for your help =).

Kind regards.

Re: Jasperserver : get pdf output from reportExecutions

Anonymous — Thu, 23 Mar 2023 00:01:05 GMT

Can you show the response headers in postman?

Regards

Shong

Re: Jasperserver : get pdf output from reportExecutions

abo — Fri, 31 Mar 2023 06:59:24 GMT

Hi Shong, here the response.

Thanks.

Re: Jasperserver : get pdf output from reportExecutions

Anonymous — Mon, 03 Apr 2023 08:59:20 GMT

I'm not sure whether the returned string is a Base64 string? Have a try to convert the base64 string to a PDF file on tJavaRow using these Java code.

Re: Jasperserver : get pdf output from reportExecutions

abo — Mon, 03 Apr 2023 10:33:34 GMT

Hi Shong, thank you for the reply, to be honest i am not used to work with java code. Should i create a routines from your code ? Can you explain me how plez ?

kind regards.

Re: Jasperserver : get pdf output from reportExecutions

Anonymous — Mon, 03 Apr 2023 11:44:56 GMT

I tested the example provided in the page and it works, the pdf file is open and the content displays normally. see

code on tJavaRow:

File file = new File("d:/files/test.pdf");

try ( FileOutputStream fos = new FileOutputStream(file); ) {

// To be short I use a corrupted PDF string, so make sure to use a valid one if you want to preview the PDF file

String b64 =input_row.line;

byte[] decoder = Base64.getDecoder().decode(b64);

fos.write(decoder);

System.out.println("PDF File Saved");

} catch (Exception e) {

e.printStackTrace();

}

in the advanced settings panel of tJavaRow, the import sections:

//import java.util.List;

import java.io.*;

import java.util.Base64;

In your case, the job looks like...

...tRestClient--main--tJavaRow

on tJavaRow, change this line

String b64 =input_row.line;

String b64 =input_row.string;

//string the column name on tRestClient, it stores the base64 string value.

Please try and let me know if you have any questions.

Re: Jasperserver : get pdf output from reportExecutions

abo — Mon, 03 Apr 2023 12:26:05 GMT

Thank you for the tip, i tried and here the return :

[statistics] connecting to socket on port 3621

[statistics] connected

java.lang.IllegalArgumentException: Illegal base64 character 25

at java.util.Base64$Decoder.decode0(Unknown Source)

at java.util.Base64$Decoder.decode(Unknown Source)

at exploitation.copy_of_roadmap_post_report_0_1.Copy_of_roadmap_post_report.tWriteJSONField_1_InProcess(Copy_of_roadmap_post_report.java:3899)

at exploitation.copy_of_roadmap_post_report_0_1.Copy_of_roadmap_post_report$1ThreadXMLField_tWriteJSONField_1_Out.run(Copy_of_roadmap_post_report.java:723)

[statistics] disconnected

I created a dummy report, juste with one fiead "nb = 1". I extract the report output to give you the result ( it doesn't look like you base64 ).

You can find it here : https://uploadnow.io/f/lmXfG4h

kind regards

Re: Jasperserver : get pdf output from reportExecutions

abo — Tue, 04 Apr 2023 13:18:52 GMT

Hi Shong, i am gonna close this topic. I found a way by using the tFileFetch component and it's working just fine =).

Thank you again for your time.

Kind regards

Re: Jasperserver : get pdf output from reportExecutions

Anonymous — Thu, 06 Apr 2023 00:38:05 GMT

Glad to hear that, thanks for your feedback!