Is there a way to query the database directly?

[AntoninHL]

Hi all,

Since the API is quite limited, I wanted to be able to set up a few specific queries to retrieve data on a centralized dashboard.
Is it possible to query the database directly?
The application is absolutely fantastic! I love working with it.
Congratulations and thank you for all your hard work.

[jokob-sk]

Hi, what exactly are you after?
There is a custom API endpoint you can write as an SQL query (API_CUSTOM_SQL)

I would rather extend the API that have users directly access the DB.

[AntoninHL]

Hi

thanks for your answer and for all the work you did and do.
And you're absolutely right: it's better if everything is done through the API.

WIth custom API endpoint, I can only create 1 specific SQL query?

[jokob-sk]

Hi, this should be doable with a GraphQL query. You can ask Chatgpt for an example based on these docs:

https://jokob-sk.github.io/NetAlertX/API/?h=graphq

You would probably use the search properly of the GraphQL request.

Alternatively I can add a filter for a field value combination, but the above might be sufficient for your use case.