-
Notifications
You must be signed in to change notification settings - Fork 197
User: Query parameters for File open
Starting from version 0.6.1.5, webSpoon takes query parameters to open a Kettle file. More specifically, when a browser accesses the endpoint with query parameters, it will launch webSpoon with the specified Kettle file opened. This feature enables webSpoon to be embedded in other web-based GUIs. For example, editting Kettle queries in CDE and Kettle endpoints in App Builder would become possible.
The following options and syntax is basically the same as written in Pan Options and Syntax and Kitchen Options and Syntax.
| Parameter | Description |
|---|---|
rep |
Enterprise or database repository name, if you are using one |
user |
Repository username |
pass |
Repository password |
trans |
The name of the transformation (as it appears in the repository) to launch |
job |
The name of the job (as it appears in the repository) to launch |
dir |
The repository directory that contains the job, including the leading slash |
file |
If you are calling a local KJB file, this is the filename, including the path if it is not in the local directory |
- The order of parameters is not important, but all the params should be present.
- Remember to URL encode strings.
-
transandjobare exclusive. Only one of them can be used at a time. -
userandpassare not mandatory on 6.1 (mandatory on 7.0). When query params do not include them, a dialog pops up and allows a user to type username and password.
http://localhost:8080/spoon/
http://localhost:8080/spoon/?trans=Transformation%201&dir=%2Fhome%2Fadmin&rep=pentaho-ee&user=admin&pass=password
This opens a transformation file Transformation<space>1 under a directory /home/admin in a repository pentaho-ee.
http://localhost:8080/spoon/?file=/home/user/Job%202.kjb
This opens a local job file /home/user/Job<space>2.kjb.
http://localhost:8080/spoon/?file=http://www.example.com/trans.ktr
This downloads a transformation file from http://www.example.com/trans.ktr and opens it.