-
1. Re: Pentaho Spoon and REST Client
Mohammad RehmanAug 18, 2017 1:15 PM (in response to ryan nicosia)
I don't know about REST Client, I just came across Pentaho Spoon Rest Client video on you tube, also not sure whether it will be helpful or not.
How to use json input and the rest client in Pentaho 6.1 - Video #1 - YouTube
-
2. Re: Pentaho Spoon and REST Client
LJ LongWingAug 18, 2017 1:27 PM (in response to ryan nicosia)
Ryan,
1000 different ways to skin a cat....I don't know how to use spoon to connect to Remedy, but if the intent is to take Remedy data and push it out to another system via Rest, you may want to look at this plugin (Restful API Plugin – A Programming Legacy )
Depending on where the 'trigger' is...if the trigger is you want Remedy to push the information out and the external system supports Rest...this plugin should work well for you.
If however the external system is the trigger, and they just want to reach in to get the information...I'm not sure Spoon is the proper demonstration tool...something more like Postman, or any number of other free Rest Clients out there may be more appropriated.
-
3. Re: Pentaho Spoon and REST Client
ryan nicosia Aug 18, 2017 1:55 PM (in response to LJ LongWing)LJ,
Actual end state is to connect to NetMRI which is an Infoblox tool and pull in data. In preparation for that I'm just trying to get Spoon to connect to AR system with the REST Client step.
-
4. Re: Pentaho Spoon and REST Client
LJ LongWingAug 18, 2017 2:27 PM (in response to ryan nicosia)
Ok, I would suggest an actual Rest Client that's not inside spoon...not because it can't do the work (I'm sure it can), but it's a bit more obscure and not as simple to control parameters as something like Postman is.
-
5. Re: Pentaho Spoon and REST Client
Jamsheer KK Aug 20, 2017 9:25 AM (in response to ryan nicosia)5 of 5 people found this helpfulThe HTTP method is POST and you have to use "FORM URLENCODED" as Application, include Header as "application/x-www-form-urlencoded" and Body you need to pass the username and pssword in the REST Client. Here is an attempt to consume Remedy REST API using Spoon RESTClient step. In example we've used Two Rest Client Steps. First one for setting the token (POST) and second one is for my actual GET operation.
Note: There could be a better optimised way of doing this. This is a simple apporach
1. Set the default values
2. REST Client - POST method and output is stored in token
3. To get the Authorization value Concatenate the AR-JWT + Token , you can use steps like Concatenate or Modified Java Script etc.
4. GET Operation to retrieve the User list, Application Type Must be JSON and must pass the Authorization as header and output will be in result field.
5. Use JSON input step and retrieve the values as required. JSON path selection and evaluation you may can use http://jsonpath.com/
6. Use Select value step to select the values that needed.
Here is the output preview
regards,
Jamsheer
-
6. Re: Pentaho Spoon and REST Client
ryan nicosia Aug 21, 2017 6:31 AM (in response to Jamsheer KK)Jamsheer,
This is exactly what I needed!! Thanks for the assist
-
7. Re: Pentaho Spoon and REST Client
Levi Lippincott Mar 16, 2018 2:05 PM (in response to Jamsheer KK)Is there a way to expand the Output fields for the REST Client step? Right now it only lets you pass out the Result field name, HTTP status code, and the Response time. I would like to grab other pieces of the return header, like Location. I haven't been able to figure that out.