Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Employee
Employee

QlikView Expressor RESTful API Extension

Starting with version 3.9.1 of QlikView Expressor we released a new capability that allowed developers to extend, share and package custom functionality using the QlikView Expressor Extensions SDK. The Extensions SDK is a facility that creates new QlikView Expressor artifacts such as operators, connections, schemas and more. Extensions can range from connectivity and transformation to Dataflow coordination and orchestration. Under the covers, the appropriate and desired operations would need to be coded using QlikView Expressor Datascript, but as you can see from some of the samples these can vary in degrees of complexity.

Prior to the release of the Extensions SDK - extending QlikView Expressor required Datascript within Expression Rules, Custom Read /  Write Operators as well as reusable QlikView Expressor Datascript modules. This continues to work well, but is not as structured or portable. With the Extensions SDK, extensions can be packaged and shipped to other environments to be installed with the QlikView Expressor Extensions Manager; allowing easily installation and sharing of the new custom functionality without having to maintain or use any Datascript.

Attached to this post I am providing a packaged developmental extension (RESTfulJSON.eex) that currently supports a RESTful API response in the form of JSON. The extension could be enhanced to to support other result formats such as CSV and XML.

Watch this companion video to learn how to use it and see it in action.

Note in order to use this, you should be familiar with RESTful APIs and there methods of querying and retrieving the results response/

An introduction to the QlikView Expressor Extensions SDK along with detailed information, tutorials and samples are available at the references listed below:

Michael Tarallo

Senior Product Marketing Manager

QlikView and QlikView Expressor

Follow me - @mtarallo