How to export GQI results to an external system?

Solved764 viewsAPI call GQI
1
0 Comments

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.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 8th August 2023

2 Answers

1
1.17K 0 Comments

Hi Edson,

There are a few ways you could go about this.

  1. Execute the query in a dashboard table component and manually export to a CSV file.
  2. 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
  3. 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.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 8th August 2023
You are viewing 1 out of 2 answers, click here to view all answers.