# Xml query possible?

**URL:** <https://discourse.nodered.org/t/xml-query-possible/39447>\
**Category:** General\
**Created:** [20 January 2021 15:55 UTC](https://discourse.nodered.org/t/xml-query-possible/39447 "2021-01-20T15:55:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [20 January 2021 15:55 UTC](https://discourse.nodered.org/t/xml-query-possible/39447/1 "2021-01-20T15:55:16Z")

</div>

Hi, is it easy possible to query one value of this xml:

 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/d/bde936868056740a21c329222edc5b5516e7a3a2.png)

its just from another RPi [http://ip](http://ip) from RPi:8080/semp

i need AveragePower **288** every 60s for some calculations in my exisiting flow.

greetings

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [20 January 2021 15:59 UTC](https://discourse.nodered.org/t/xml-query-possible/39447/2 "2021-01-20T15:59:27Z")

</div>

Hi @Becker

What have you tried so far? The flow will be something like an Inject node set to trigger at whatever interval you want, an HTTP Request node to get the data, an XML node to cover the XML to a JavaScript object and then a Change node to pull out the particular value you want.

If you can get as far as passing the data through an XML node, wiring in a Debug node to see the structure of the JS object you end up with. From there you'll be able to identify the proper path to the property you want using the Debug sidebar tools.

---

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [20 January 2021 18:26 UTC](https://discourse.nodered.org/t/xml-query-possible/39447/3 "2021-01-20T18:26:15Z")

</div>

thx

 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/9/d9b551eec5da995c99dc7b94237cc352c2aec246.png)

i need:

```auto
payload.Device2EM.DeviceStatus[0].PowerConsumption[0].PowerInfo[0].AveragePower[0]

```

I don´t know how to use a change node to pull out the value

---

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [20 January 2021 18:32 UTC](https://discourse.nodered.org/t/xml-query-possible/39447/4 "2021-01-20T18:32:33Z")

</div>

got it:

```auto
var semp = msg.payload.Device2EM.DeviceStatus[0].PowerConsumption[0].PowerInfo[0].AveragePower[0];
msg.payload = semp
return msg;

```

```auto
[{"id":"845e4937.cc4fc","type":"inject","z":"341cac4c.e11094","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":230,"y":160,"wires":[["3fb43d2d.fb57f2"]]},{"id":"34f4aa79.9d9b4e","type":"xml","z":"341cac4c.e11094","name":"","property":"payload","attr":"","chr":"","x":630,"y":160,"wires":[["b8b1c3fe.c2d848"]]},{"id":"3fb43d2d.fb57f2","type":"http request","z":"341cac4c.e11094","name":"Abfrage SAE","method":"GET","ret":"txt","paytoqs":"ignore","url":"http://192.168.168.5:8080/semp","tls":"","persist":false,"proxy":"","authType":"","x":450,"y":160,"wires":[["34f4aa79.9d9b4e"]]},{"id":"b8b1c3fe.c2d848","type":"function","z":"341cac4c.e11094","name":"","func":"var semp = msg.payload.Device2EM.DeviceStatus[0].PowerConsumption[0].PowerInfo[0].AveragePower[0];\nmsg.payload = semp\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":840,"y":160,"wires":[["53e9af3.63139d"]]}]

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [3 February 2021 18:32 UTC](https://discourse.nodered.org/t/xml-query-possible/39447/5 "2021-02-03T18:32:33Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.