Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Airbus
Contributor III
Contributor III

Get endpoint details with QEM API

Hi Team,

We are trying to create a script that can return the connection information to a DB (host, database name...) just with the name of the task that has an endpoint connected to this DB.

Do you know if there is a function in the QEM API that could return the details of the information of an endpoint?

If not, the only thing I can think of is exporting the json file and reading the "databases" block. 

 

Thank you in advance for the help,

Best regards,

Labels (2)
1 Solution

Accepted Solutions
Heinvandenheuvel
Specialist II
Specialist II

GetEndpointList does not provide enough detail to satisfy the described request.

Just like 'GetTaskList' has a companion 'GetTaskDetails' it would be nice if there was a  GetEndpointDetails but unfortunately there is currently no exposed API for the latter. Feature request?

REPCTL does not provide it either. I think the only useful place an endpoint name can be used is repctl getprovidersyntax.

Personally I have always used a task or full export json to list out endpoint characteristics and usages.

I have attached a Perl and a PowerShell script example on how to do this. Oops, I now see that the Powershell version does not list the servername. Oh well, left as an exercise for the reader. From your  description I suspect you already are well aware of how to parse for the databases section anyway.

Hein.

Sample from my sandbox :

Heinvandenheuvel_0-1694485699743.png

 

 

View solution in original post

3 Replies
sureshkumar
Support
Support

Hello @Airbus 

Kindly check if this API meet your requirements

GetEndpointList

GetEndpointList | Qlik Enterprise Manager Help

 

Regards,
Suresh

Heinvandenheuvel
Specialist II
Specialist II

GetEndpointList does not provide enough detail to satisfy the described request.

Just like 'GetTaskList' has a companion 'GetTaskDetails' it would be nice if there was a  GetEndpointDetails but unfortunately there is currently no exposed API for the latter. Feature request?

REPCTL does not provide it either. I think the only useful place an endpoint name can be used is repctl getprovidersyntax.

Personally I have always used a task or full export json to list out endpoint characteristics and usages.

I have attached a Perl and a PowerShell script example on how to do this. Oops, I now see that the Powershell version does not list the servername. Oh well, left as an exercise for the reader. From your  description I suspect you already are well aware of how to parse for the databases section anyway.

Hein.

Sample from my sandbox :

Heinvandenheuvel_0-1694485699743.png

 

 

firth61
Contributor
Contributor

Silly question maybe, but is this a mysterious json file someone's giving to you, or are you getting the JSON back from a site? If so the network tab in your dev tools console is what you need. Otherwise that's a little tougher if you have nothing to go off.