Yes, that is possible.Is it possible to display the water level of the Nijmegen haven measuring point in Domoticz?
For some reason I only get an XML result when I use this URL in chrome.FireWizard wrote: ↑Sunday 31 January 2021 16:42 If you use the following URL: https://waterinfo.rws.nl/api/chart?mapT ... alues=-6,3,
you will get a JSON response with the required data for that location.
and alsoDevTools failed to load SourceMap: Could not load content for https://waterinfo.rws.nl/scripts/ol.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
I found the URL with the Inspector of Firefox. In Firefox it functions. However if I open in Firefox another tab and I copy the URL to that tab I also see XML code. No idea why.Error: Unexpected end of JSON input
It is up to you if you want this to be handled completely internal in domoticz with dzVents or if you prefer nodered.
Code: Select all
scriptvar = 'waterpeilNijmegen'
return
{
on =
{
timer =
{
'every 1 minutes' -- just an example to trigger the request
},
httpResponses =
{
scriptVar, -- must match with the callback passed to the openURL command
},
},
logging =
{
level = domoticz.LOG_DEBUG,
marker = 'waterstand',
},
execute = function(dz, item)
if item.isTimer or item.isDevice then
dz.openURL(
{
url = 'https://waterinfo.rws.nl/api/chart?mapType=waterhoogte&locationCode=Nijmegen-haven%28NIJM%29&values=-6,3',
callback = scriptVar, -- see httpResponses above.
})
elseif item.isHTTPResponse and item.ok then
dz.utils.dumpTable(item.json)
else
dz.log(item, domoticz.LOG_DEBUG)
end
end
}
Code: Select all
[{"id":"f1324d44.f6688","type":"tab","label":"Waterstanden","disabled":false,"info":""},{"id":"c0e85807.57038","type":"http request","z":"f1324d44.f6688","name":"Waterstand Nijmegen haven","method":"GET","ret":"obj","paytoqs":"ignore","url":"https://waterinfo.rws.nl/api/chart?mapType=waterhoogte&locationCode=Nijmegen-haven(NIJM)&values=-6,3","tls":"","persist":false,"proxy":"","authType":"","x":460,"y":140,"wires":[["85ee7f6b.fcb8e"]]},{"id":"bb820068.b3cc58","type":"inject","z":"f1324d44.f6688","name":"10 Minute Inject","props":[{"p":"payload"}],"repeat":"600","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":190,"y":140,"wires":[["c0e85807.57038"]]},{"id":"a54daffb.02255","type":"function","z":"f1324d44.f6688","name":"","func":"var time = msg.payload.t0;\nvar height = msg.payload.series[0].data[msg.payload.series[0].data.length - 1].value;\nmsg.payload = {\"command\":\"udevice\", \"idx\":11, \"svalue\":\"Meettijdstip: \" + time +\"\\n\" + \"Waterstand: \" + height + \" cm\"};\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":960,"y":140,"wires":[["995c142.98c27e8","90315b4d.41f05"]]},{"id":"995c142.98c27e8","type":"debug","z":"f1324d44.f6688","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1150,"y":200,"wires":[]},{"id":"85ee7f6b.fcb8e","type":"moment","z":"f1324d44.f6688","name":"","topic":"","input":"payload.t0","inputType":"msg","inTz":"ETC/UTC","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD-MM-YYYY/HH:mm:ss","locale":"nl-NL","output":"payload.t0","outputType":"msg","outTz":"Europe/Amsterdam","x":740,"y":140,"wires":[["a54daffb.02255"]]},{"id":"90315b4d.41f05","type":"mqtt out","z":"f1324d44.f6688","name":"To Domoticz","topic":"domoticz/in","qos":"","retain":"","broker":"f9f13036.e28b58","x":1150,"y":140,"wires":[]},{"id":"f9f13036.e28b58","type":"mqtt-broker","name":"localhost","broker":"127.0.0.1","port":"1883","clientid":"","usetls":false,"compatmode":true,"keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthRetain":"false","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""}]I use NodeRed and DZVents interchangeably so I don't really have a preference. My choice is determined by the available or provided examples. I can't judge which of the 2 takes the most system load. The NodeRed flow is ready and working. The content of the text sensor used meets my wishes.
the method is updateTextJan Jansen wrote: ↑Monday 01 February 2021 14:23 Hopefully you will find some time to show me how to fill the text sensor from DZVents.
Code: Select all
scriptVar = 'waterpeilNijmegen'
return
{
on =
{
timer =
{
'every 10 minutes',
},
httpResponses =
{
scriptVar,
},
},
logging =
{
level = domoticz.LOG_DEBUG,
marker = 'waterstand',
},
execute = function(dz, item)
local waterpeil = dz.devices('Waterpeil Nijmegen haven')
local function utcToLocal( tStr )
local utcDelta = os.difftime(os.time(), os.time(os.date("!*t" )) )
return (dz.time.makeTime(tStr:gsub('T',' ')).addSeconds(utcDelta)).raw
end
local function makeText(t)
for _, st in ipairs(t) do
if st.name == 'Waterhoogte Oppervlaktewater t.o.v. Normaal Amsterdams Peil in cm' then
local text = 'Meettijdstip: ' .. utcToLocal(st.data[#st.data].dateTime) .. '\n'
text = text .. 'Waterstand: ' .. dz.utils.round(st.data[#st.data].value) .. ' cm'
return text
end
end
end
if item.isTimer or item.isDevice then
dz.openURL(
{
url = 'https://waterinfo.rws.nl/api/chart?mapType=waterhoogte&locationCode=Nijmegen-haven%28NIJM%29&values=-6,3',
callback = scriptVar, -- see httpResponses above.
})
elseif item.isHTTPResponse and item.ok then
waterpeil.updateText(makeText( item.json.series ))
else
dz.log('Problem with httpResponse status: ' .. item.statusCode, domoticz.LOG_ERROR)
dz.log(item, domoticz.LOG_DEBUG)
end
end
}
Code: Select all
var label = {};
var level;
var time = msg.payload.t0;
var height = msg.payload.series[0].data[msg.payload.series[0].data.length - 1].value;
if (height > msg.payload.limits[5].from) {
level = 4;
label = msg.payload.limits[5].label
} else if (height > msg.payload.limits[4].from) {
level = 3;
label = msg.payload.limits[4].label
} else if (height > msg.payload.limits[3].from) {
level = 2;
label = msg.payload.limits[3].label
} else if (height > msg.payload.limits[1].from) {
level = 1;
label = msg.payload.limits[1].label
} else {
level = 0;
label = msg.payload.limits[0].label
}
msg.payload = {"command":"udevice", "idx":17, "nvalue":level, "svalue":"Meettijdstip: " + time + "\n" + "Waterstand: " + height + " cm" + "\n" + label};
return msg;
Maybe an idea to use a device as distance just to get the water height and have a history.My choice would be a custom sensor and use the internal domoticz notification system in the device notification tab to receive notifications at the various levels.
Code: Select all
scriptVar = 'waterpeilNijmegen'
return
{
on =
{
timer =
{
'every 10 minutes',
},
httpResponses =
{
scriptVar,
},
},
logging =
{
level = domoticz.LOG_DEBUG,
marker = 'waterstand',
},
execute = function(dz, item)
local waterpeilText = dz.devices(834) -- change to ID or 'name' of your text device
local waterpeilCustom = dz.devices(835) -- change to ID or 'name' of your custom sensor
local function utcToLocal( tStr )
local utcDelta = os.difftime(os.time(), os.time(os.date("!*t" )) )
return (dz.time.makeTime(tStr:gsub('T',' ')).addSeconds(utcDelta)).raw
end
local function makeValues(t)
for _, st in ipairs(t) do
if st.name == 'Waterhoogte verwacht Oppervlaktewater t.o.v. Normaal Amsterdams Peil in cm' then
local dateString = utcToLocal(st.data[#st.data].dateTime)
local height = dz.utils.round(st.data[#st.data].value)
local text = 'Verwacht om: ' .. dateString .. '\n' .. 'Waterstand: ' .. height .. ' cm'
-- dz.utils.dumpTable(st.data) -- When debugging
return text, height
end
end
end
if item.isTimer or item.isDevice then
dz.openURL(
{
url = 'https://waterinfo.rws.nl/api/chart?mapType=waterhoogte&locationCode=Nijmegen-haven%28NIJM%29&values=-6,3',
callback = scriptVar,
})
elseif item.isHTTPResponse and item.ok then
local text, level = makeValues( item.json.series )
waterpeilText.updateText(text)
waterpeilCustom.updateCustomSensor(level)
else
dz.log('Problem with httpResponse status: ' .. item.statusCode, dz.LOG_ERROR)
dz.log(item, dz.LOG_DEBUG)
end
end
}
Code: Select all
var label = {};
var level;
var time = msg.payload.t0;
var height = msg.payload.series[0].data[msg.payload.series[0].data.length - 1].value;
switch (true) {
case (height >= msg.payload.limits[5].from):
level = 4;
label = msg.payload.limits[5].label
break;
case (height >= msg.payload.limits[4].from):
level = 3;
label = msg.payload.limits[4].label
break;
case (height >= msg.payload.limits[3].from):
level = 2;
label = msg.payload.limits[3].label
break;
case (height >= msg.payload.limits[2].from):
level = 1;
label = msg.payload.limits[2].label
break;
case (height >= msg.payload.limits[1].from):
level = 1;
label = msg.payload.limits[1].label
break;
case (height < msg.payload.limits[0].to):
level = 0;
label = msg.payload.limits[0].label
break;
}
msg.payload = {"command":"udevice", "idx":17, "nvalue":level, "svalue":"Meettijdstip: " + time + "\n" + "Waterstand: " + height + " cm" + "\n" + label};
return msg;No functional reason. It's not distance but level.
Thx. I updated the post.B.t.w. small typo in the script. You mix "domoticz" and "dz"
Distance sensor can be changed to display the value in inches but because of a bug preventing to access the edit window you need build >= 12902 to edit the device from the GUIFireWizard wrote: ↑Tuesday 02 February 2021 15:10 3. "Distance" sensor has the advantage that you can log the historical values. The disadvantage is that you can not change the x-axis, with is always cm.
Indeed would be nice but it has to be implemented in many different places in the code. I see these quantities and units in various xml, cpp, js, html and header files.FireWizard wrote: ↑Tuesday 02 February 2021 18:03 I think for the continent more units, like mm, m, km would be nice, for the UK we can use inches, feet, yards, miles.
Your thoughts?
Code: Select all
[
{
"id": "f1324d44.f6688",
"type": "tab",
"label": "Waterstand Nijmegen haven",
"disabled": false,
"info": ""
},
{
"id": "c0e85807.57038",
"type": "http request",
"z": "f1324d44.f6688",
"name": "Waterstand Nijmegen haven",
"method": "GET",
"ret": "txt",
"paytoqs": "body",
"url": "https://waterinfo.rws.nl/api/chart/Get?mapType=waterhoogte&locationCode=Nijmegen-haven(NIJM)&values=-6,3",
"tls": "",
"persist": false,
"proxy": "",
"insecureHTTPParser": false,
"authType": "",
"senderr": false,
"headers": [],
"x": 260,
"y": 140,
"wires": [
[
"8559f35430d62e66"
]
]
},
{
"id": "bb820068.b3cc58",
"type": "inject",
"z": "f1324d44.f6688",
"name": "1 hour inject",
"props": [
{
"p": "payload"
}
],
"repeat": "3600",
"crontab": "",
"once": true,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 140,
"y": 240,
"wires": [
[
"c0e85807.57038"
]
]
},
{
"id": "90315b4d.41f05",
"type": "mqtt out",
"z": "f1324d44.f6688",
"name": "To Domoticz",
"topic": "domoticz/in",
"qos": "",
"retain": "",
"respTopic": "",
"contentType": "",
"userProps": "",
"correl": "",
"expiry": "",
"broker": "fbb02111.25ba88",
"x": 930,
"y": 140,
"wires": []
},
{
"id": "20627e81d052eb33",
"type": "debug",
"z": "f1324d44.f6688",
"name": "debug 3",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 760,
"y": 240,
"wires": []
},
{
"id": "8559f35430d62e66",
"type": "csv",
"z": "f1324d44.f6688",
"name": "",
"sep": ",",
"hdrin": "",
"hdrout": "all",
"multi": "one",
"ret": "\\n",
"temp": "",
"skip": "0",
"strings": true,
"include_empty_strings": "",
"include_null_values": "",
"x": 510,
"y": 160,
"wires": [
[
"20627e81d052eb33"
]
]
},
{
"id": "fbb02111.25ba88",
"type": "mqtt-broker",
"name": "MQTT",
"broker": "127.0.0.1",
"port": "1883",
"clientid": "",
"autoConnect": true,
"usetls": false,
"protocolVersion": 4,
"keepalive": "60",
"cleansession": true,
"birthTopic": "",
"birthQos": "0",
"birthPayload": "",
"closeTopic": "",
"closeQos": "0",
"closePayload": "",
"willTopic": "",
"willQos": "0",
"willPayload": ""
}
]