Can we query the Replicate system tables ?

[simonB2020]

I need to export a list of my tasks & endpoints and feed into an external dashboard.

Obviously I can manually click on 'Export to TSV' - but really hoping that there is a way to do this via automation.

Does anyone know if we can ODBC/JDBC into a repository behind the app ?

Or an API ?

Thanks for any pointers.....

[SwathiPulagam · Accepted solution]

Hi @simonB2020 ,

You can use QEM API calls to automate your use case.

Below is the  QEM development guide for your reference:

https://help.qlik.com/en-US/enterprise-manager/November2021/Content/EnterpriseManager/EnterpriseMana...

Thanks,

Swathi

[lyka · Accepted solution]

Hi Simon,

Is this for a one time use? You can export the entire repository from the Replicate Server.

repctl -d <data folder> exportreporistory

the resulting json will include all task names and endpoints

Thanks

Lyka