Get endpoint details with QEM API

[Airbus]

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,

[sureshkumar]

Hello @Airbus 

Kindly check if this API meet your requirements

GetEndpointList

GetEndpointList | Qlik Enterprise Manager Help

Regards,
Suresh

[Heinvandenheuvel · Accepted solution]

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 :

[firth61]

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.