The Web Services as a Data Source example will demonstrate the use of the Web Service ("ws") Translator to call a web service that returns a JSON document. This will demonstrate how to define the model that will transform the JSON document into relational results.
dynamicvdb-webservices-to-twitter
All the code discussed in this tutorial is available in the
dynamicvdb-webservices-to-twitter
quickstart.
See the README.md for directions to run the quick start.
This example will use Twitter as the web service data source and will expose it as a view through Teiid. Take note of the VIRTUAL PROCEDURE that is used to define how to transform a JSON document to XML and then into relational results.