...
| Table of Contents |
|---|
...
Inside QlikView or Qlik Sense you can use the the Qlik Rest connector to query the WIP data model and make quite all reporting you can imagine
All tasks you can do using the WIP Web Interface you can do it using the API
As such an integration can be quite technical, you can ask us for a professional consulting offer to help you implement your project.
...
| Code Block |
|---|
http:// <WIPSERVER>:59272/wip/#!/home/actors |
Click on GetAllActors should display
...
Copy the Authorization “Bearer XXXX” then you can paste it in Qlik Sense Requests like below
...
After we can use these 2 connections for all requests.
Authentication
| Anchor | ||||
|---|---|---|---|---|
|
Create a POST Rest Connection
...
Get a token from the point Authentication
Add the token
The token should look like:
Bearer
| Code Block |
|---|
eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyb2xlIjoiMiIsInVuaXF1ZV9uYW1lIjoiRUJJV0lOMjAxNlxcZWJpZGV2IiwiYWN0b3JJZCI6IjE5NyIsImVudmlyb25tZW50SWQiOiIyMDYiLCJsb2dpbk1ldGhvZCI6IjAiLCJlbnZpcm9ubWVudFJlcG9zVHlwZSI6InFzIiwiZW52aXJvbm1lbnROYW1lIjoiMDAgUVNFTlNFLURFViIsImF2YXRhclVybCI6Imh0dHA6Ly81NC4zNi4xNDcuMjIwOjU5MjcyL2Rvd25sb2FkL2RlZmF1bHRBdmF0YXJzL2RlZmF1bHQucG5nIiwidXNlck5leHRQYWdlIjoiMCIsImlzTGljZW5zZVZhbGlkIjoiVHJ1ZSIsImlzcyI6Imh0dHA6Ly81NC4zNi4xNDcuMjIwOjU5MjcyLyIsImF1ZCI6ImFsbCIsImV4cCI6MTUxMjc3MjMxMSwibmJmIjoxNTEyNzI5MTExfQ.EpVOdd2Z63oB1uhdhu33P5h8d_1KT3ZH-MaUdmFi_e8 |
Create a Header name “Authorization” and paste the token in Value like below. Then test connection
...
Sample POST Query Get Users
| Code Block |
|---|
//----------------------------------------------------- |
...
// Get Actors |
...
//----------------------------------------------------- |
...
LIB CONNECT TO 'WIPApiPost'; |
...
RestConnectorMasterTable: |
...
SQL SELECT |
...
"id", |
...
"name", |
...
"avatarUrl", |
...
"perVmQs", |
...
"perVmFile", |
...
"perVmEnvProps", |
...
"perVmTip", |
...
"perVmQv", |
...
"perWipUp" |
...
FROM JSON (wrap off) "data" |
...
WITH CONNECTION (
...
WITH CONNECTION ( URL "http://localhost:59272/api/Actors/GetAllActors", |
...
HTTPHEADER "Authorization" "bearer $(vWIP_token)", |
...
HTTPHEADER "Content-Type" "application/json; charset=utf-8", |
...
BODY "{active: true,toValidate: false}" |
...
); |
...
[WIPActors]: |
...
LOAD |
...
[id] AS [actorId], |
...
[name] AS [name], |
...
[avatarUrl] AS [avatarUrl], |
...
[perVmQs] AS [perVmQs], |
...
[perVmFile] AS [perVmFile], |
...
[perVmEnvProps] AS [perVmEnvProps], |
...
[perVmTip] AS [perVmTip], |
...
[perVmQv] AS [perVmQv], |
...
[perWipUp] AS [perWipUp] |
...
RESIDENT RestConnectorMasterTable; |
...
DROP TABLE RestConnectorMasterTable; |
Sample GET Query
You can use the Get Query we created before as we will override URL
There are 2 important things in the query:
| Code Block |
|---|
URL : "http://localhost:59272/api/businessUnit/GetAllBusinessUnits" |
...
HTTPHEADER : "Authorization" "bearer $(vWIP_token)" |
Sample code : get the WIP Business Units:
| Code Block |
|---|
//----------------------------------------------------- |
...
// Get Business Units |
...
//----------------------------------------------------- |
...
LIB CONNECT TO 'WIPApiGet'; |
...
RestConnectorMasterTable: |
...
SQL |
...
SELECT "id", |
...
"name" |
...
FROM JSON (wrap off) "data" |
...
WITH CONNECTION |
...
( URL "http://localhost:59272/api/businessUnit/GetAllBusinessUnits", |
...
HTTPHEADER "Authorization" "bearer $(vWIP_token)" |
...
); |
...
[WIPBusinessUnits]: |
...
LOAD |
...
[id] AS [businessUnitId], |
...
[name] AS [businessUnitName] |
...
RESIDENT RestConnectorMasterTable; |
...
DROP TABLE RestConnectorMasterTable; |
How to get WIP Rest API urls (endpoints)
Using the Google Chrome Developer tools
Open chrome on WIP
Press Ctrl-Shift-I
Using WIP Rest API Dictionary
...