Click here to Skip to main content
15,885,757 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to programmatically get the details of a specific execution of a transformation

What I have tried so far

I get the status of the Kettle Slave Server/Carte at

http://localhost:8282/kettle/status/


From this page, I can click on the desired transformation and I am taken to another page that shows the details and also has a link to the XML output to the current status of a specific execution of a transformation. The link is something like this:

C#
http://localhost:8282/kettle/transStatus/?name=trans_name&id=Carte_Ob_ID&xml=y


The problem

I have a transformation that has been run multiple times recently. I don't have the Carte_Obj_ID for a specific run of the transformation. So, I can't provide it in the URI. If I try the following URI instead:

C#
http://localhost:8282/kettle/transStatus/?name=trans_name&xml=y


then I get the status of a random execution. Not the latest one or any specific one.

The Goal

I am writing a .net GUI where I have this code.

C#
HttpWebRequest req = (HttpWebRequest)WebRequest.
                        Create(@"http://localhost:8282/kettle/transStatus/?
                                name=Trans_Name
                                &id=Carte_Obj_ID
                                &xml=y");
req.Method = "GET";
req.Credentials = new NetworkCredential("cluster", "cluster");                
resp = req.GetResponse();
xmlResultStream = resp.GetResponseStream();
StreamReader readStream = new StreamReader(xmlResultStream, Encoding.UTF8);
String a = readStream.ReadToEnd();


I intend to get the status XML of a specific execution of a transformation and allow a non-Pentaho admin user to run transformations at a click of a button.

Thanks for any help in advance. I have taken inspiration from this article[^].

Update:

I saw this old JIRA entry[^] where this bug is said to be fixed. I have PDI 5.0 trail version, not sure if this fix is actually there.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900