AnsweredAssumed Answered

pentaho REST call <jobScheduleRequest> parameter type

Question asked by Nicole Erbe on Jul 27, 2018

I am using pentaho PDI 7.1.0.0-12. The task is to schedule several
pentaho reports with different parameters and move the result to a
certain file resource. I have started with a simple two steps
transformation: "GenerateRows" and "RestClientScheduleJobRequest". The
first passes XML to the second step to call the URL of a pentaho report
and schedule the execution. Here's the XML:

<jobScheduleRequest> 
<jobName>JobName</jobName>
<simpleJobTrigger>
<uiPassParam>MINUTES</uiPassParam>
<repeatInterval>1800</repeatInterval>
<repeatCount>-1</repeatCount>
<startTime>2018-07-27T12:10:00.000+02:00</startTime>
<endTime/>
</simpleJobTrigger>
<inputFile>/folder/do_something.prpt</inputFile>
<outputFile>/public/output</outputFile>
<jobParameters> <name>Param_von_Datum</name>
<type>date</type>
<stringValue>false</stringValue>
</jobParameters>
</jobScheduleRequest>

I have several questions how to build the XML appropriately, mainly
this is because I did not find further details in the documentations:

  1. What values can "uiPassParameter" have?
  2. What values does the "repeatCount" value need to have or can have? Here it is set to -1: What does it mean?
  3. Which options do I have for the job type? E.g. here it's a "simpleJobTrigger" and in another example I found "".
  4. Which values might the jobParameters have? I assume here I can pass
    parameters for the reports execution? For example in case the report has
    two date fields "from" and "to". How do I have to specify them?

Is there a resource where to find at least the specifications for the fields? What I found so far:
https://help.pentaho.com/Documentation/8.0/Developer_Center/REST_API/Schedules/0H0#path__scheduler_job.html

https://help.pentaho.com/Documentation/8.0/Developer_Center/REST_API/Schedules/0H0/030#jobScheduleRequest_element

Any help is appreciated!!
Many thanks
N.

   
       

 

           

Outcomes