SWQL query within Custom HTML

Trying to add a interface's throughput to custom dashboard. So the query is:

SELECT Inbps/1000000 as Download, Outbps/1000000 as Upload
FROM Orion.NPM.Interfaces
WHERE InterfaceID=16938

I'd like to store the outputs of Download and Upload as variables and display as plain text under a picture in the HTML. I suspect the answer is in https://thwack.solarwinds.com/t5/SAM-Documents/Custom-Sparkline-Charts/ta-p/520283 but still trying to understand everything that is going on in there and adapt to my needs. Is there a different way I should think to approach this problem?

Find more posts tagged with

Accepted answers

majames84

I got it figured out.

Thanks to @monovex (https://thwack.solarwinds.com/t5/SAM-Documents/Custom-Sparkline-Charts/ta-p/520283)

Also thanks to @mesverrum @tszilagyi (https://thwack.solarwinds.com/t5/SAM-Discussions/Possible-to-embed-SWQL-inside-of-custom-HTML/td-p/92494)

<!DOCTYPE html>
<html>
<body>

<p id="download"></p>
<p id="upload"></p>

<script>
var swql="SELECT Inbps/1000000 as Download, Outbps/1000000 as Upload FROM Orion.NPM.Interfaces WHERE InterfaceID=16938"
var params = JSON.stringify({
query: swql,
parameters: {
}
});
(function worker_Memory()
{
//Create the AJAX POST request
$.ajax({
type: 'POST',
url: '/Orion/Services/Information.asmx/Query',
data: params,
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
//On a successfull request, parse the data.
//Uncommnet the statement below if you want to see the response
//document.write(JSON.stringify(response));
//Loading with data into the var with some rounding
var Download = Math.round((response.d.Rows[0][0])*100)/100;
var Upload = Math.round((response.d.Rows[0][1])*100)/100;
document.getElementById("download").innerHTML=Download;
document.getElementById("upload").innerHTML=Upload;