Connecting Qlik Sense to a custom table in OnPing

Start by adding a new REST data source to your Qlik App

mceclip3.png

Use the API url for fetching a custom table with the data for that table

https://onping.plowtech.net/api/customtabledata/get
qlik-url.png

Find the custom table you want to load into Qlik and open the developer tools network tab.
Open the custom table in full screen mode.

mceclip2.png

Find the request to load the custom table data and copy the cTableId parameter

table-id.png

Paste the cTableId parameter into the query parameter value section. For the name put ‘cTableId’.

mceclip0.png

Go back to the full screen widget page with developer tools open.

If you use Firefox look for the Storage tab.
Under the Cookies section you should find an entry for ‘https://onping.plowtech.net’
Look for the value field of the “_SESSION” entry. Double click and copy the value.

mceclip1.png

If you use Chrome look for the Application tab.
Under the Cookies section you should find an entry for ‘https://onping.plowtech.net’
Look for the value field of the “_SESSION” entry. Double click and copy the value.

chrome.png

In the headers section of Qlik add ‘Cookie’ to the name field and in the value field
put ‘_SESSION=’ plus the entry copied from developer tools.

qlik-url.png

You can now click create and the data should load into Qlik. You have the option of loading the custom table, the data loaded into the custom table, or both.

Powered by BetterDocs