The topic of this blog is Remedyforce integration with external application using REST API (Pentaho client). The REST Client transformation step in Pentaho enables you to consume RESTfull services. The logic can be applied if there is anyone out there doing ETL work against CouchDB or other big data solutions.

The REST Client Step is fairly simple. Initiate it with a generate rows step and set your method in the HTTP Method drop down. My difficulty came in understanding how to define the path in the JSON input. Once I figured out the path, everything was much simpler.

You can create this as job and create a batch file to call kettle spoon batch file.

Even though the REST Client step has a URL field, it doesn't seem to work and you will need the 'Generate Rows' to pass in the URL. As you can see here I’ve defined the URL, X-Authentication these are the values required for RESTClient.Depends on the REST web service the fields you might need to define.

REST Client Step (REST Query)

Accept URL from the field is defined in the previous step ‘URL’, defineyour web service operation method. Define Application type accordingly. Output of your query will ‘result’ field. Also defined the headers since its required for my web service.

Note: If you are using self-signed certificate then you might need to import the cert to java key store.

Json Input Step (JSON Input)

Choose source is defined in field option check box and get source from field as ‘results’ field.We need to define the JSON path expressions. Refer below links for more details,

If you want to perform certain operations such as define default value or concatenate or such operations you can define in this step. I’m defining the required success and failure file names here in this step. This will be used in the future steps for error / success logging.

In this step we can remove the fields that are no longer required further (eg: results, URL etc.).

Sort rows step (Sort rows)

Sort your data stream based on the unique key.

Salesforce Input Step (Salesforce Input [CMDB_Class])

Define the salesforce web service URL, using SOQL query getting the Computer system Class ID where we are going to insert the records. The fields will be record id and class name. Ensure that your login id has required permission.

Keep up with us

Random Blogpost

Let’s first take a look at the definitions in ITIL:

Call (Service Operation): A telephone call to the Service Desk from a User. A Call could result in an Incident or a Service Request being logged.

Incident (Service Operation): An unplanned interruption to an IT Service or a reduction in the Quality of an IT Service. Failure of a Configuration Item that has not yet impacted Service is also an Incident. For example Failure of one disk from a mirror set.