I created Static report by using Report Designer.
We use PDI transformation file to retrieve JSON through the Rest Client.
This is how it should work:
You open the report on Pentaho Server
You enter the year as a parameter
Year parameter will be used in Rest Point URL.
You will receive results in JSON format for the required year through the Rest Point
Pentaho report will display results
PDI transformation file for Rest Service connection
The challenge here is:
HOW to pass Year parameter from PRPT report to Transformation, to be able to get correct results for required Year.
Maybe the question here is also:
Is this correct approach how to deal with Pentaho Report and Rest Service?
Can it be done this way? Passing parameter from Pentaho Report to Kettle transformation?
Or it should be done differently?
What is the best practice here?
Thank you and kind regards,