Looking for values by using a web service

Web services are interfaces that are accessed through HTTP and executed on a remote hosting system. They use XML messages that follow the Simple Object Access Protocol (SOAP) standard. Some examples of web services that use SOAP are Salesforce, Amazon Web Services, and eBay. With Kettle, you can look for values in available web services by using the Web service lookup step. In this recipe, you will see an example that shows the use of this step.

Suppose that you have a dataset of museums and you want to know about their opening and closing hours. That information is available as an external web service. The web service has a web method named GetMuseumHour that receives the id_museum as a parameter, and ...

Get Pentaho Data Integration Cookbook Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.