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.
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.
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.
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.
9 of 9 people found this helpful
The 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
This is exactly what I needed!! Thanks for the assist
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.
i have a similar situation as well... the only difference is that i am looking for a POST method in the second REST Client step. is that feasible?
Sorry for the delayed response.
In the above example first REST Client step getting the authentication token and Second REST Client Step is performing the GET. In similar way you should be able to POST as well. Make sure that you have all necessary header and parameter mapping as described below,
I have an issue with API paging, how could I load data with undefined page numbers, example www.api.com/list?page=1, ..... please advice
Could you please elaborate more on your requirement?
Do you have any sample to use put operation?
Thank you very much for an elaborate answer. However if the 3rd party REST API is hosted over a secure connection. Do we have any documentation / steps for importing SSL certificates into "REST client" step?
The SSL certificates would be imported into the java keystore on the server you are running the job from. You then configure your REST API step to consume the javakeystore.
1. Download the SSL certs for the target that you are trying to connect to via REST
2. Save the cert(s) on the server you are going to run your job from
3. Use keytool -keystore command to import the certs to the java keystore
4. Configure REST API connection to use the java keystore for SSL connection