topic Re: How to create simple table chart using Rest API in Qlik Sense? in App Development

How to create simple table chart using Rest API in Qlik Sense?

Gnaneshwari_Venkatesan — Thu, 09 Jun 2022 07:36:14 GMT

Hi Everyone,

I want to create a simple table with one measure and one dimension using Rest API. I have already created an app using the URL https://your-tenant.us.qlikcloud.com/api/v1/apps. Created a connection with MYSQL Database also using Rest API.

Now please anyone tell me how to create visualizations using the data in Qlik sense Rest API.

Thank You,

Gnaneshwari V

Re: How to create simple table chart using Rest API in Qlik Sense?

Sweta_Sharma — Sun, 12 Jun 2022 08:17:58 GMT

Hi @Gnaneshwari_Venkatesan ,
Please refer below related links-
https://www.youtube.com/watch?v=bYxpRJ5lkKY
https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/VisualizationAPI/VisualizationAPI.htm
Cheers!

Re: How to create simple table chart using Rest API in Qlik Sense?

stevedark — Sun, 12 Jun 2022 08:52:07 GMT

Hi @Gnaneshwari_Venkatesan

For some hints on loading data from APIs please see my response on this thread:
https://community.qlik.com/t5/App-Development/Is-it-possible-to-create-table-with-one-dimension-and-one/td-p/1941757

If you have already loaded data from the API and wish to create a table chart simply go to Analyse, put the sheet into Edit mode and then find Table under the Charts menu. Double click this and there will be buttons prompting for Dimension and Measure. Click the DImension button and select the field that you want to define what is on each row - this should appear. Then go to Properties on the right hand side and open up the Data and Measures options and click Add. Here select the field you want to use in your expression and then chose how you want to aggregate over that field (most likely Sum). This will then create a table with two columns for you, one with a field value from the source table and the other with the aggregation of a value.

Hope that helps.

Steve

Re: How to create simple table chart using Rest API in Qlik Sense?

Gnaneshwari_Venkatesan — Mon, 13 Jun 2022 07:33:49 GMT

Hi @Sweta_Sharma ,

The link you have mentioned is for Visualization API (JavaScript) but I want to create a visualization through Rest API (https://qlik.dev/apis/#rest).

Through Postman, I am connecting with Qlik sense using API Key (https://qlik.dev/apis/rest/apps). After creating the app using Rest API, I want load the data into the app(I have created a MYSQL connection from Postman using Rest API and I want to connect that MySQL connection to the app) and using the data I want to create a simple table in the app using same Rest API from Postman.

Thank you,

Gnaneshwari V