Votes:
How exactly do I extract values from an XML node using the HTTP XML/REST Value sensor of PRTG?
Created on Nov 5, 2012 4:01:34 PM by
Last change on Dec 10, 2020 10:10:45 AM by
15 Replies
Votes:
This article applies as of PRTG 22
The HTTP XML/REST Value sensor can parse different XML outputs. The notation is XPath compatible. See a typical simple XML example below:
<data>
<section1>
<name>int. Temperature</name>
<value_float>36.31</value_float>
<value_int>3631</value_int>
<value_string>thirty-six</value_string>
<minimum>36.25</minimum>
<maximum>46.87</maximum>
<limit_low>10.00</limit_low>
<limit_high>50.00</limit_high>
<function>l</function>
<alarm1>0</alarm1>
</section1>
</data>
To obtain values from nested XML tags, use tag names separated by a slash. For example, to obtain the float value 36.31 from the XML above, you would use the following value in the sensor's XML Node field:
section1/value_float
Created on Nov 5, 2012 4:17:27 PM by
Last change on Jan 3, 2023 8:07:54 AM by
Votes:
When there are multiple nodes within a XML result, you can reference it's occurrence using a number between Brackets.
The following PRTG API Call For example:
/api/table.xml?content=sensors&output=xml&columns=name,uptime&id=DEVICEID
Produces the following output:
<?xml version="1.0" encoding="UTF-8"?>
<sensors totalcount="2" listend="1">
<prtg-version>15.2.18.2816</prtg-version>
<item>
<name>Ping</name>
<uptime>95,3760%</uptime>
<uptime_raw>000000000953760</uptime_raw>
</item>
<item>
<name>Traceroute Hop Count</name>
<uptime>95,4608%</uptime>
<uptime_raw>000000000954608</uptime_raw>
</item>
</sensors>
If we want to read the uptime for the Traceroute Hop Count in the XML result, we use the following syntax within the XML Node (and optional property) inside PRTG:
item[2]/uptime
That will result in the folowing output within the HTTP XML/REST Value Sensor in PRTG
Created on Jun 26, 2015 11:43:28 AM by
Last change on Jun 26, 2015 12:02:22 PM by
Votes:
Hi there,
It's not possible to get the value of <sensors totalcount="353" listend="1"> because it is not a value of a node. You could however count the number of <item> occurrences.
Best Regards,
Luciano Lingnau [Paessler Support]
Created on Nov 15, 2016 2:39:52 PM by
Votes:
Hi there,
It's not possible to get the value of <sensors totalcount="353" listend="1"> because it is not a value of a node. You could however count the number of <item> occurrences.
Best Regards,
Luciano Lingnau [Paessler Support]
Created on Nov 15, 2016 2:39:52 PM by
Votes:
Could you post the entire JSON? The following should work:
//headroom[0]
Created on Mar 20, 2017 6:13:27 AM by
Last change on Mar 20, 2017 6:13:56 AM by
Votes:
Thanks Stephan nut unfourtunately doesn't work attached the error, the JSON , and the configuration of the sensor.
{
"cdn.headroom" : 29,
"cdn.machines" : [
{
"headroom" : 29,
"hostname" : "ia1.tp2sfe1d1.cdn",
"ips" : [ "10.187.9.20" ],
"max-headroom" : 100,
"rack" : "r.mx.sfe.tp2sfe1c1"
}
],
"cdn.max-headroom" : 100,
"external.headroom" : 2029,
"external.machines" : [
{
"headroom" : 91,
"hostname" : “hostname1”,
"max-headroom" : 100,
},
{
"headroom" : 89,
"hostname" : "hostname2”,
"max-headroom" : 100,
},
{
"headroom" : 92,
"hostname" : "hostname3”,
"max-headroom" : 100,
},
{
"headroom" : 79,
"hostname" : "hostname4”,
"max-headroom" : 100,
},
{
"headroom" : 80,
"hostname" : "hostname5”,
"max-headroom" : 100,
},
{
"headroom" : 96,
"hostname" : "hostname6”,
"max-headroom" : 100,
}
],
"external.max-headroom" : 2600
}
Regards !
Last change on Mar 22, 2017 6:46:57 AM by
Votes:
The JSON is slightly invalid. Here's the corrected version:
{
"cdn.headroom": 29,
"cdn.machines": [{
"headroom": 29,
"hostname": "ia1.tp2sfe1d1.cdn",
"ips": ["10.187.9.20"],
"max-headroom": 100,
"rack": "r.mx.sfe.tp2sfe1c1"
}],
"cdn.max-headroom": 100,
"external.headroom": 2029,
"external.machines": [{
"headroom": 91,
"hostname": "hostname1",
"max-headroom": 100
}, {
"headroom": 89,
"hostname": "hostname2",
"max-headroom": 100
}, {
"headroom": 92,
"hostname": "hostname3",
"max-headroom": 100
}, {
"headroom": 79,
"hostname": "hostname4",
"max-headroom": 100
}, {
"headroom": 80,
"hostname": "hostname5",
"max-headroom": 100
}, {
"headroom": 96,
"hostname": "hostname6",
"max-headroom": 100
}],
"external.max-headroom": 2600
}
What exact value are you trying to extract?
Created on Mar 22, 2017 6:50:30 AM by
Votes:
//external.machines[1]/headroom
...but only one value per sensor. That's a bit of work I'm afraid.
Created on Mar 23, 2017 8:03:41 AM by
Votes:
One sensor per node, yep. Sorry, the sensor doesn't support converting multiple nodes into channels :(
Created on Mar 24, 2017 5:40:17 AM by
Votes:
Negative values should work, just tested it. Can you provide me with a sample XML? I won't publish it.
We're currently working on a reimplementation of this sensor that will have quite a bit more features.
Stay tuned ;)
Created on Jul 24, 2017 5:04:06 AM by
Last change on Jul 24, 2017 6:19:42 AM by
Add comment