Scrape sensor improved - scraping multiple values

Share your Projects! Custom Integrations
576

Hi willembuys,

Thanks for your reply, and apologies for the late reply, very busy. I just included the multiscrape: in my configuration.yaml (had used the template before) and checked the response. (I’m running HA in a Docker on my Syno btw).

The file page_response_body.txt is there. And when I check contents it seems there is an error. It is a html file which shows:
(function(){var a=new XMLHttpRequest();a.open(“get”,“/missing”,true);a.send();a.onreadystatechange=function(){if(a.readyState==4&&(a.status==200||a.status==304)){var c=String(a.responseText);var e=document.open(“text/html”,“replace”);e.write(c);e.close()}else{var d={en:“The page you are looking for cannot be found.”, - followed by the same message in a lot of other languages.

This seems to indicate the page cannot be found. Which is weird, I just looked it up with no issue. Any pointers as to what I need to change?

577

Maybe the * in the url is a problem. Could you try a page without it or replace it by %2A?

578

I removed the .* at the end of the url, but no change in the output. Changing it to %2A also did not work. Same output in both cases as the original error.

Edit:
Intriguingly, when I input directly into FireFox ‘http://192.168.2.31/get.json?f=$.status.*’ I do get a 404 response. Which seems to tell the page cannot be found. In my python program (UMR2toMQTT/UMR2toJSON.py at 9bb3acffb76fbe929a0e9de4c04c2a0e847d32b0 · Sir-Bacon/UMR2toMQTT · GitHub) I do get a nice json response. Is that due to the requests module being used?

Edit2:
Should I just completely forget about the json approach and use html instead? The website of the UMR2 controller is tabbed. If I request http://192.168.2.138/#Status I get directly the correct tab in view. The variable status is then defined as ‘stcv’ (status CV), see also screenshot of the Inspect window below.
image

579

Could it be that you are mixing up IPs? Probably there is a good reason but just want to be sure. The IP address in your code is different from the one in the multiscrape config.

580

Dang, good catch! Yup, screwed up IP’s.

With the correct IP of the UMR I do get a good response. With the ‘.*’ included the file page_response_body.txt now only has 4 lines of contents:

{
	"type": "WTH_Regulator",
	"id": "D602020C1A1E0794"
}

This seems to be a json response, albeit with only 1 variable. Now how to get the rest of the variables?

Edit:
When I input http://192.168.2.138/get.json?f=$.status.* in ForeFox i get the complete json with all the elements I want to scrape.

Edit2:
With %2A I also get only the 4 lines json response. How do I get Multiscrape to return the complete json?

581

That’s really strange… But since it’s local to you, I’m afraid I cannot reproduce it. Maybe paste your config in the multiscrape.get_content action (service) and play around a bit more with the params (specifying them separately in the config).

action: multiscrape.get_content
data:
  name: Multiscrape Data
  resource_template: 'http://192.168.2.31/get.json'
  params:
    f: '$.status.*'
583

It works like a charm.
However, a different sensor, which I scrape every 5 minutes and which uses the same login through form-submit, throws an error every 5 minutes, but otherwise scrapes just fine.
This is the error:

Exception in form-submit feature. Will continue trying to scrape target page.

cannot unpack non-iterable NoneType object

Any suggestion as to what is causing this? Which information can I provide to help investigate?

584

OK, reply to myself, but just to document the solution. In the end Daniel assisted me and we found a solution. Using the normal HA scrape sensor, it turned out Multiscrape was not necessary. The scrape itself gets a json, from which multiple sensors can be read out. That was my misunderstanding.

Now I use the following scrape sensor, really easy:

rest:
  - resource: 'http://192.168.2.138/get.json?f=$.status.*'
    scan_interval: 10
    sensor:
      - name: Vloerverwarming Modus
        value_template: '{{ value_json.status.outputs.heater.mode }}'
      - name: Vloerverwarming Pomp
        unit_of_measurement: "%"
        value_template: '{{ value_json.status.outputs.pump.speed }}'
      - name: "Vloerverwarming Klep"
        unit_of_measurement: "%"
        value_template: '{{ value_json.status.outputs.valves.8.state }}'
      - name: "Vloerverwarming Temperatuur In"
        unit_of_measurement: "°C"
        value_template: '{{ value_json.status.inputs.max.temperature }}'
      - name: "Vloerverwarming Temperatuur Uit"
        unit_of_measurement: "°C"
        value_template: '{{ value_json.status.inputs.return.temperature }}'

Thanks again to Daniel for helping me out.

Just to be clear, something strange did happen in the reply from the UMR2 and the processing by Multiscrape. But since Daniel does not have that controller, he cannot reproduce it.

585

I fixed this in release v8.0.3!

1 Like
586

Thanks for this wonderful utility, Daniel. This comes handy where the data is dynamic and have dependencies with online websites for the information but we only want specific value.
I am trying to scrape one of the site that got daily changing data which provides information about moon phases and other astrological information. I was facing issue with one of the detail which is placed on a table but the table rows will be dynamic. The row will be added or deleted based on the specific days values, hence index based scraping was not giving the correct data. I was searching for this thread for examples to identify the row based on a specific value and come up with the below on my investigation. Sharing here for anyone having similar needs.

  resource: https://websitelinkthatyouwanttoscrape
  scan_interval: 86400 #scrape once a day
  headers:
    User-Agent: Mozilla/5.0
  sensor:
    - unique_id: sensor_id
      name: Sensor Name as per your need
      select: table:nth-child(2) > tr:nth-child(2) > td > table > tr:contains("rowheadingyouwanttosearchfor") # For my use case, YMMV
1 Like