JSON equivalent to XML for POST reportExecutions REST SERVICE?

[tonyy]

<reportExecutionRequest> <reportUnitUri>/supermart/details/CustomerDetailReport</reportUnitUri> <async>true</async>
<freshData>false</freshData> <saveDataSnapshot>false</saveDataSnapshot> <outputFormat>html</outputFormat>
<interactive>true</interactive> <ignorePagination>false</ignorePagination>
<pages>1-5</pages>
<parameters>

<reportParameter name="someParameterName"> <value>value 1</value>
<value>value 2</value>

</reportParameter>
<reportParameter name="someAnotherParameterName">

<value>another value</value> </reportParameter>

</parameters> </reportExecutionRequest> 

 

This is XML listed in documentation, what is the equivalent for this in JSON? Online converters did not help , the requests with their resulting json could not be serialized on JasperServers. Particular complaint is about parameters.

How nice to introduce XML example and omit JSON - Well Done Jasper Team! And thanks for not answering our questions you are so helpful.

 

 

[samreay]

Hi Tony,

Did you ever manage to get the JSON report execution requests working properly? I am having a very similar issue where no matter what parameters I send to the server, they never get passed to the report.

And man is it frustrating that all the jasper examples are in xml and not json. Come on.

Cheers

[rafkacz1]

Hi, I've just succesfully get JSON reportExecutionRequest structure send.

You are rigth - there are no good examples for JSON - but it is possible to decompile jar files and see class definitions used by server.... 

 

{"reportUnitUri":"/reports/fait/pracownicy","async":true,"freshData":true,"saveDataSnapshot":false,"outputFormat":"pdf","interactive":false,"ignorePagination":true,"pages":null,"parameters":{"reportParameter":[{"name":"Parameter1","value":["a"]}]}}        

 

C# wrapper class of it:

 

    public class ReportParameter

    {

        public String name { get; set; }

        public List<String> value { get; set; }

 

    }

 

    public class ReportParameters

    {

        public List<ReportParameter> reportParameter { get; set; }

    }

 

    public class reportExecutionRequest

    {

        public string reportUnitUri { get; set; }

        public bool async { get; set; }

        public bool freshData { get; set; }

        public bool saveDataSnapshot { get; set; }

        public string outputFormat { get; set; }

        public bool interactive { get; set; }

        public bool ignorePagination { get; set; }

        public string pages { get; set; } //1-5

        public ReportParameters parameters { get; set; }

    } 

 

Regards, 

Rafal

 

 

[stephane_4]

Right on man! We've been having this issue for a while with no luck until your answer. THANKS a bunch!!

[taggart]

@rafkacz1 -- thanks so much - I spent 4 hours on this today and you saved my...

[twright_1]

You ended my JSON format guessing game. Thanks!

[abkmkdgis]

You are a life saver /sites/all/libraries/ckeditor/plugins/smiley/images/thumbs_up.png