Help to read html code

[peyoe]

Hello friends.
I try several times to read active power from my wibeee power meter trough the web page.
I use the example on https://forum.logicmachine.net/showthread.php?tid=712 
and on https://openrb.com/read-plugwise-smile-p...-requests/

But I can not do it, I do not have any ressult.

This is the url I use: http://192.168.1.238/en/phase1.html
And this is a screen capture how html is:


Can someone help with the script?
Thanks and greetings.

PD: Sorry about my english 

[Erwin van der Zwart]

Hi,

Try this:

Code:

require('socket.http')
socket.http.TIMEOUT = 5
data = socket.http.request('http://192.168.1.238/en/phase1.html')

-- Check if response value is received
if data then
  -- Fetch values from HTTP response
  p_activa = data:match([[<td id="p_activa">(.-)</td>]])
  -- Remove units and trims leading and trailing spaces and decode to numberic
  p_activa = tonumber(string.trim(string.gsub(p_activa, "W", "", 1)))
  -- Write to KMX
  grp.write('1/1/1', p_activa)
end

BR,

Erwin

[peyoe]

Hi,

Try this:

Code:

require('socket.http')
socket.http.TIMEOUT = 5
data = socket.http.request('http://192.168.1.238/en/phase1.html')

-- Check if response value is received
if data then
  -- Fetch values from HTTP response
  p_activa = data:match([[<td id="p_activa">(.-)</td>]])
  -- Remove units and trims leading and trailing spaces and decode to numberic
  p_activa = tonumber(string.trim(string.gsub(p_activa, "W", "", 1)))
  -- Write to KMX
  grp.write('1/1/1', p_activa)
end

BR,

Erwin

Hello @Erwin van der Zwart
Thanks for the script!!
I change the script in order to put the user and password and to change the output object (virtual byte floating point) see it:

Code:

require('socket.http')
socket.http.TIMEOUT = 5
data = socket.http.request('http://user:user@192.168.1.238/en/phase1.html')
log(data)

-- Check if response value is received
if data then
  -- Fetch values from HTTP response
  p_activa = data:match([[<td id="p_activa">(.-)</td>]])
  log(p_activa)
  -- Remove units and trims leading and trailing spaces and decode to numberic
  p_activa = tonumber(string.trim(string.gsub(p_activa, "W", "", 1)))
  log(p_activa)
  -- Write to KMX
  grp.write('32/3/1', p_activa)
end

But this doesn't work, looking to the log this is the output:



And this is the searched data read from the wibeee webpage, storeged on "data"

Code:

<tr>
     <td>Active Power</td>
     <td id="p_activa"></td>
</tr>

Any idea?

Thanks again.

[admin]

Data is probably loaded via JavaScript so initial HTML fields are empty. Check network tab in browser. You might get a URL for JSON data which will make parsing easier.

[peyoe]

Data is probably loaded via JavaScript so initial HTML fields are empty. Check network tab in browser. You might get a URL for JSON data which will make parsing easier.

Hello, I completely a noob with html and java.
How can I do it?

[admin]

Open dev tools (F12) switch to Network tab and reload the page. Post a screenshot of what requests you get there.

[Erwin van der Zwart]

Hi,

What model do you use? When looking at the internet data i see it supports XML and modbus TCP, so integration by parsing XML or communicate over modbus should be easy and there is no need to fetch the data from the HTML (this is the last option i would use). I would go for Modbus TCP when available.

BR,

Erwin

[peyoe]

Hi,

What model do you use? When looking at the internet data i see it supports XML and modbus TCP, so integration by parsing XML or communicate over modbus should be easy and there is no need to fetch the data from the HTML (this is the last option i would use). I would go for Modbus TCP when available.

BR,

Erwin

I use this one:

https://wibeee.com/producto/wibeee-box-m...nformation

EDIT
Well, It seems that it does have modbus TCP communication:


Any info how catch this data?

[Daniel]

Read manuals or contact support. You need to setup modbus, probably just enable and get the registry info.

[peyoe]

Read manuals or contact support.  You need to setup modbus, probably just enable and get the registry info.

 
I'm on it

[peyoe]

I already have the information from support, how to put it in modbus TCP mode and address table:

See:


The direction I would like to read is 0x000D "Total Active Power"
Now I need how to extract this info.

Can someone help me with that?

And once again, thanks

[Daniel]

Go to modbus tab, add attached profile and then add modbus IP device.  Map object and you are done.
Profile may need adjustment.

[peyoe]

Go to modbus tab, add attached profile and then add modbus IP device.  Map object and you are done.
Profile may need adjustment.

Wow, that was fast.
Thanks a lot, later at home I try it.

[peyoe]

Finally I can do it, but not trough modbus, because when I inserted new modbus device, the software ask for the IP and one port. I don't had idea what port wibeee uses for this task.
So, searching info on the manual I founded that wibeee can answer to html request for one item.
With this info, I have used the scrip from @Erwin van der Zwart and modify to request only for the items I wanted.
This is the final script:

Code:

require('socket.http')
socket.http.TIMEOUT = 5
pact = socket.http.request('http://192.168.1.238/services/user/values.xml?var=WIBEEE.pact')
i1 = socket.http.request('http://192.168.1.238/services/user/values.xml?var=WIBEEE.irms1')
en = socket.http.request('http://192.168.1.238/services/user/values.xml?var=WIBEEE.eac1')

-- Check if response value is received
if pact then
      p_activa = pact:match([[<value>(.-)</value>]])
      p_activa = tonumber(string.trim(string.gsub(p_activa, "W", "", 1)))
      grp.write('32/3/1', p_activa)
end
 
if i1 then
    int_f1 = i1:match([[<value>(.-)</value>]])
      int_f1 = tonumber(string.trim(string.gsub(int_f1, "W", "", 1)))
    grp.write('32/3/2', int_f1)
end

if en then
  energia = en:match([[<value>(.-)</value>]])
  energia = tonumber(string.trim(string.gsub(energia, "W", "", 1)))
  grp.write('32/3/3', energia)
end

I launch it every 5 minutes, and works pretty well 

Thanks to all, for the help.

[Joep]

Finally I can do it, but not trough modbus, because when I inserted new modbus device, the software ask for the IP and one port. I don't had idea what port wibeee uses for this task...

Modbus over TCP is most likely port 502.