- What Grafana version and what operating system are you using?
Windows 11, Grafana Docker Container with the latest version, Infinity Datasource Plugin
- What are you trying to achieve?
Connecting my JSON-Datasource to grafana and make it work so that I can build dashboards out of it
- How are you trying to achieve it?
My system has a REST-API that I am using. With the URL I request data with a query, no authentification atm. So I copied the URL into the Infinity Datasource for the query, set up everything but it does not work
- What happened?
When I try to run the query, it shows an error
- What did you expect to happen?
My Data should have been shown in a table
- Can you copy/paste the configuration(s) that you are having problems with?
JSON data that my URL delivers:
[
{
“gi_re_mehrwertsteuerbetrag”: 661.2,
“gi_re_bruttobetrag_1”: 4141.2,
“gi_re_nettobetrag_1”: 3480,
“gi_re_skonto_in_prozent”: 2,
“gi_re_lieferscheinnummer”: “100010”,
“ag_metadata_collection”: “Eingangsrechnung”,
“gi_re_rechnungsnummer”: “top secret”,
“gi_re_skontierter_betrag”: 4058.38,
“gi_re_mandant”: “top secret”,
“gi_re_zahlungsziel_in_tagen”: 10,
“gi_re_leistungsdatum”: “2023-10-08T10:00:00.000Z”,
“gi_re_rechnungsdatum”: “2023-10-10T10:00:00.000Z”,
“gi_re_rechnungspositionen”: [
{
“nettobetrag”: 2000,
“einzelpreis_netto”: 2000,
“artikelnummer_des_lieferanten”: “300007”,
“artikelbezeichnung”: “Fernseher 80 Zoll”,
“menge”: 1,
“artikelnummer”: “300007”,
“lieferscheinnummer”: “100010”,
“bestellnummer”: “654325”
}
],
“gi_re_mehrwertsteuerbetrag_1”: 661.2,
“gi_re_bruttobetrag”: 4141.2,
“gi_re_skonto_absolut”: 82.82,
“ma_belegbezeichnung”: “Rechnung”,
“gi_re_nettobetrag”: 3480,
“gi_re_rechnungseingangsdatum”: “2024-02-27T12:42:44.358Z”,
“DocFormType”: “Eingangsrechnung”,
“name”: “top_secret.pdf”,
“gi_re_mehrwertsteuersatz”: 19,
“gi_re_faelligkeitsdatum”: “2023-10-08T10:00:00.000Z”,
“gi_re_bestellnummer”: “654325”
}
]
And now the error that is shown:
error getting data frame. error getting response from url https://top-secret/api/rest/custom/topsecret.dashboards.service.exportDashboardData.noauth?query=inpath:9999%20area:(“DMS-Intern”%20"Rechnungseingang")%20ma_belegbezeichnung:Rechnung. no response received. Error: Get “https://top-secret/api/rest/custom/topsecret.dashboards.service.exportDashboardData.noauth?query=inpath%3A9999+area%3A(“DMS-Intern”+“Rechnungseingang”)+ma_belegbezeichnung%3ARechnung”: dial tcp 127.0.0.1:443: connect: connection refused
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
as shown above. I only use the UI, no commands.
- Did you follow any online instructions? If so, what is the URL?
The instructions of the Infinity Datasource Plugin itself that is implemented
I have to say that I am pretty new in this tech-world so I literally have no plan how to fix it.