Hello!!
I'm developing a flow where I want to obtain some data from a webpage (specifically daily electricity prices) and I want to introduce them in a database I have created and in the end be able to visualize them and even select the desired data to work with them. I am having some trouble with the location of the database and I don know why.
Here is my flow:
[{"id":"5efb37f.0118bc8","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"4ebb1ead.786cb","type":"http request","z":"5efb37f.0118bc8","name":"Electricity Rates Spain","method":"GET","ret":"txt","url":"http://www.tarifadeluz.com/","tls":"","x":480,"y":320,"wires":[["d440a505.f6ac08"]]},{"id":"181ee6a7.7cbea9","type":"inject","z":"5efb37f.0118bc8","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":280,"y":320,"wires":[["4ebb1ead.786cb"]]},{"id":"d440a505.f6ac08","type":"html","z":"5efb37f.0118bc8","name":"Electricity rates","property":"payload","outproperty":"payload","tag":"<table width=\"500\" border=\"2\" style=\"border-collapse: collapse\" bordercolor=\"gray\"> <tbody align=\"center\"><tr><td bgcolor=\"silver\"><font size=\"3\" color=\"black\"><b>Hora</b></font></td> \t\t<td bgcolor=\"aqua\"><font size=\"3\" color=\"black\"><b>Tarifa General</b></font></td> \t\t<td bgcolor=\"fuchsia\"><font size=\"3\" color=\"black\"><b>Tarifa Nocturna</b></font></td> \t\t<td bgcolor=\"darkorange\"><font size=\"3\" color=\"black\"><b>Vehículo Eléctrico</b></font></td></tr><tr> <td><font size=\"3\"><b> 0 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.102 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.053 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.057 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 1 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.098 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.049 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.047 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 2 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.095 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.047 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.044 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 3 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.095 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.047 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.044 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 4 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.095 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.047 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.044 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 5 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.098 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.050 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.047 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 6 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.104 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.055 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.052 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 7 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.109 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.061 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.064 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 8 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.112 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.064 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.067 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 9 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.109 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.061 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.064 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 10 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.107 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.059 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.062 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 11 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.105 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.057 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.060 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 12 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.105 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.057 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.060 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 13 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.101 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.119 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.119 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 14 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.098 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.117 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.117 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 15 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.097 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.116 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.116 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 16 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.098 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.116 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.116 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 17 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.102 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.120 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.120 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 18 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.105 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.123 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.123 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 19 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.107 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.126 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.126 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 20 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.111 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.129 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.129 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 21 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.118 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.137 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.137 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 22 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.119 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.138 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.138 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> <tr> <td><font size=\"3\"><b> 23 h </b></font></td> <td><b><font size=\"3\" color=\"black\"> 0.116 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.067 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> <td><b><font size=\"3\" color=\"black\"> 0.071 </font></b><font size=\"3\" color=\"black\"><font size=\"2\">€/kWh</font></font> </td> </tr> </tbody></table>","ret":"text","as":"multi","x":700,"y":320,"wires":[["2050c7d8.fd73f8","d5d26b6c.2ca9d8"]]},{"id":"2050c7d8.fd73f8","type":"debug","z":"5efb37f.0118bc8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":930,"y":320,"wires":[]},{"id":"4383a36f.e3f3bc","type":"inject","z":"5efb37f.0118bc8","name":"Create database table","topic":"CREATE TABLE ELECTRICITYPRICES( HOUR INT PRIMARY KEY NOT NULL, TARIFAGENERAL INT NOT NULL, TARIFANOCTURNA INT NOT NULL, VEHICULOELECTRICO INT NOT NULL)","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":440,"y":240,"wires":[["d5d26b6c.2ca9d8"]]},{"id":"d5d26b6c.2ca9d8","type":"sqlite","z":"5efb37f.0118bc8","mydb":"3943d456.ff0d9c","sqlquery":"msg.topic","sql":"","name":"ELECTRICITYRATES Database","x":990,"y":240,"wires":[["b5970c47.d787a"]]},{"id":"b5970c47.d787a","type":"debug","z":"5efb37f.0118bc8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1250,"y":240,"wires":[]},{"id":"38c8ec8.9027314","type":"inject","z":"5efb37f.0118bc8","name":"View records","topic":"SELECT TARIFAGENERAL FROM ELECTRICITYRATES ORDER BY TARIFAGENERAL DESC LIMIT 4;","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":410,"y":400,"wires":[["8658321a.819e3"]]},{"id":"63a4bdac.1b2384","type":"debug","z":"5efb37f.0118bc8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":950,"y":400,"wires":[]},{"id":"e8ff3111.c565b","type":"comment","z":"5efb37f.0118bc8","name":"Create the table ELECTRICITYPRICES","info":"","x":470,"y":180,"wires":[]},{"id":"8658321a.819e3","type":"sqlite","z":"5efb37f.0118bc8","mydb":"3943d456.ff0d9c","sqlquery":"msg.topic","sql":"","name":"ELECTRICITYRATES Database","x":670,"y":400,"wires":[["63a4bdac.1b2384"]]},{"id":"3943d456.ff0d9c","type":"sqlitedb","z":"","db":"/home/pi/Databases/ELECTRICITYRATES.db","mode":"RWC"}]
And whenever I execute it, this the error in the debug window:
"Error: SQLITE_ERROR: no such table: ELECTRICITYRATES"
Any suggestions??
Thank you in advance
