topic Re: how to get the tables list from Data model viewer using Qlik sense API in Integration, Extension & APIs

how to get the tables list from Data model viewer using Qlik sense API

Manoj_Prabu — Tue, 01 Nov 2022 13:27:56 GMT

Hi Community,

I'm trying to get the tables list which was showing in the data model viewer through API. Any one have any idea how to achieve this. Please share if you do.

Thanks.

Re: how to get the tables list from Data model viewer using Qlik sense API

Francisco_Fernandez — Thu, 09 Jun 2022 14:05:29 GMT

Hello @Manoj_Prabu ,

If i'm not mistaken you can use the engine api to get that information. https://help.qlik.com/en-US/sense-developer/February2021/apis/EngineAPI/definitions-TableViewSaveInfo.html

Also I would suggest you to check this tool https://github.com/qlik-oss/catwalk

Hope this helps.

Best regards,

Francisco

Re: how to get the tables list from Data model viewer using Qlik sense API

Manoj_Prabu — Fri, 10 Jun 2022 05:27:39 GMT

Hi @Francisco_Fernandez ,

Thanks for the response. I got what I want from Engine API GetTablesAndKeys method. My requirement is, is there any way to get that result with Qlik APIs other than Engine API.

Thanks.

Re: how to get the tables list from Data model viewer using Qlik sense API

Manoj_Prabu — Fri, 10 Jun 2022 06:53:06 GMT

Hi folks,

I found the solution using the below.

var result=app.theme.app.engineApp.getTablesAndKeys(

{ qcx: 0, qcy: 0 },

0, false, false

)

console.log(result)

I'm going to mark this as a Solution.

Thanks