16 May 2024 08:21 PM - last edited on 07 Jun 2024 11:49 AM by Michal_Gebacki
Hello. I want to see database queries via api but i dont know how to achieve it or if its possible. Anyone has an idea?
Solved! Go to Solution.
17 May 2024 05:29 PM - edited 17 May 2024 05:29 PM
Hi,
I think that is not possible.
Best regards
19 May 2024 04:04 PM
Hi @kasdev
To see the DB statements you need to utilize entities rest api few times,
First with service method group
For example we can filter the database service to show statements under SQL Queries or Procedures
Then we can pull the service method group from the URL
and use it as the entity ID for entities rest api
The DB statements are under isServiceMethodOf
the id's are again the ID's for entities rest api
Under detected name you will find the DB statement as shown in the UI
HTH
Yos