Script web link CSV value to an item?

Setup, Configuration and Use Scripts & Rules
1

I have a La Crosse Gateway GW1000u - it auto uploads temp data to a web portal - where I can access the CSV file. ( http://lacrossealertsmobile.com) hopefully anyone searching for the same might find this page in the future

All I want is the current “Probe Temp ©” out of the CSV. Line 1 is headers, line 2 is latest data, cell 3.

I’ve read that many sites and pages and guides, and have no idea what any of it means.

API link to my CSV http://decent-destiny-704.appspot.com/laxservices/user-api.php?pkey=Dyd7kC4wxLDFz0rQ6W5T28DPgrM6SOBe&ref=85893ktjk6s&sensor=0001762D82800A88&action=usercsv

Can someone please help, or show me an example I can learn from ?
I just want to be able to able to see the Pool temp in my Basic UI :cold_sweat:
I’m running a Qnap 559ii Pro with OH2.4 app package installed, so my options to use python are limited, as the QNAP is locked down, and its old so I can use docker. Happily entertain and read anything anyone send though!!

Thanks to anyone who can help me.
Johnny

2

Have you tried node-red
I got your latest data with a simple flow:

image
image792×72 5.21 KB 

[{"id":"4ecb0b70.e290a4","type":"inject","z":"6250dce3.505294","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":460,"wires":[["ffc8196.c81af68"]]},{"id":"ffc8196.c81af68","type":"http request","z":"6250dce3.505294","name":"","method":"GET","ret":"txt","paytoqs":false,"url":"http://decent-destiny-704.appspot.com/laxservices/user-api.php?pkey=Dyd7kC4wxLDFz0rQ6W5T28DPgrM6SOBe&ref=85893ktjk6s&sensor=0001762D82800A88&action=usercsv","tls":"","persist":false,"proxy":"","authType":"","x":320,"y":460,"wires":[["f5d047a3.71e1e8"]]},{"id":"f5d047a3.71e1e8","type":"csv","z":"6250dce3.505294","name":"","sep":",","hdrin":true,"hdrout":"","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"x":520,"y":460,"wires":[["fc18f5e0.ee35a"]]},{"id":"fc18f5e0.ee35a","type":"function","z":"6250dce3.505294","name":"","func":"msg.payload = msg.payload[0];\nreturn msg;","outputs":1,"noerr":0,"x":680,"y":460,"wires":[["223134b9.01aafc"]]},{"id":"223134b9.01aafc","type":"debug","z":"6250dce3.505294","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":880,"y":460,"wires":[]}]
3

Hi,
Look at this, it can give you a hint:

If it does not work, I think you should rely on external script (bash,python,php…whatever suits you).