Hi all,
Is it possible to export que query results to an external system?
I know we have use cases for Grafana and Power-BI, but they use specific connectors.
In this one, the end user is looking for some API call or any other way where they can get the results from a DataMiner query into their in-house system, either automatically or per on-demand request.
Thanks.
Hi Edson,
There are a few ways you could go about this.
- Execute the query in a dashboard table component and manually export to a CSV file.
- Using the Data Aggregator DxM you can run queries manually or schedule them to run periodically and save them to a CSV file or handle results via a WebSocket connection.
See: Data Aggregator documentation - Write an automation script to execute a query using the raw SLNet messages.
Warning: Only use this approach as a last resort if you know what you’re doing. It requires knowledge of an API that is not publicly documented and is intended for internal use.
Hi Edson,
Another possible option (similar to the one described by Ronald) could be using the DataAggregator and User Definable API.
The DataAggregator will export the query result to a CSV file. Then, you could use User Definable API to parse the result of the CSV file and expose it to the external system. The only problem I see here is how to trigger the DataAggregator on demand. The DataAggregator exposes a small API to trigger manually a job but I didn’t test it so far.
Hope it helps.