Grafana and Thingspeak API

82 views (last 30 days)
Hi all
I am trying to use Grafana dashboard to show my Thingspeak data which is generated by a Microbit IoT device. The data logs perfectly to the thingspeak website, and the GET command works fine as I copied and pasted into a new browser and i got json data (channel is public).
However, when I try connect my grafana dashboard and add the JSON channel feed (through simple JSON a plugin), I get a error in Grafana (although it says connection established). The error is:
<!DOCTYPE html> <html> <head> <title>We're sorry, but something went wrong (404)</title> <style type="text/css"> body { background-color: #fff; color: #666; text-align: center; font-family: arial, sans-serif; } div.dialog { margin: 3em auto 0 auto; } h1 { font-size: 100%; color: #f00; line-height: 1.5em; } </style> </head> <body> <!-- This file lives in public/404.html --> <div style="padding-top: 50px"> <img src='/thingspeak_logo_white.png' width='200' height='35' style='background-color: #2f7eb2; padding: 10px;' /></div> <div class="dialog"> <h1>The page you were looking for doesn't exist.</h1> <p>You may have mistyped the address or the page may have moved.</p> </div> </body> </html>
I am using a windows machine.
Regards

Accepted Answer

Vinod
Vinod on 1 Feb 2021
I have this set up like this and it works:
1) Set up the datasource. In my case, I set up a new JSON API with this URL: https://api.thingspeak.com/channels/12397/fields/1.json
2) Next I created a new dashboard with the above datasource, the "Query string" set to "results=8000" and 2 queries
a) $.feeds[*].created_at
b) $.feeds[*].field1
Now I select a graph visualization and get this dashboard:
This is no different than the chart here:
So, can you provide more context on your use case for Grafana instead of the built in charts?
  3 Comments
pravin vaz
pravin vaz on 2 Feb 2021
Thanks mate. That worked like a charm.

Sign in to comment.

More Answers (1)

Sriramajeyam Sugumaran
Sriramajeyam Sugumaran on 18 Feb 2021
You can use Grafana Infinity Datasource for this purpose. Below screenshot is an example from https://thingspeak.com/channels/1103934/ and how to use it. This plugin also allows you to other formats like csv/json.
PS: I am the author of the grafana infinity datasource plugin

Communities

More Answers in the  ThingSpeak Community

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!