How to name an array

Olivia · 22 February 2022 14:08

Hello everyone,

I would like to name my arrays inside of the main array. Does anyone know how i can do that ?

Thanks in advance !

Steve-Mcl · 22 February 2022 14:13

Hi Olivia...

You need an object with properties, or, an array of objects. (you cannot name arrays, arrays are zero based number indexed)

Object with properties

{
  "fred": 45,
  "wilma": 39
}

Array of objects...

[
  {name:"fred", age: 45},
  {name:"wilma", age: 39}
]

PS: If you want additional help, you will need to explain exactly what you need AND post code (not screenshots of code) (since we cannot modify a screenshots code to send you a working example)

Ta

Olivia · 22 February 2022 14:24

This is the script i'm using

[{"id":"5bb6b3d6273a88af","type":"ui_date_picker","z":"e9cc758ca9c0e264","name":"","label":"Begin datum","group":"b784de15b0f65054","order":1,"width":3,"height":2,"passthru":true,"topic":"begin","topicType":"str","className":"","x":370,"y":100,"wires":[["22eb8d76cd60d294"]]},{"id":"a0679230c692dc09","type":"ui_date_picker","z":"e9cc758ca9c0e264","name":"","label":"Eind datum","group":"b784de15b0f65054","order":2,"width":3,"height":2,"passthru":true,"topic":"eind","topicType":"str","className":"","x":370,"y":140,"wires":[["22eb8d76cd60d294"]]},{"id":"22eb8d76cd60d294","type":"join","z":"e9cc758ca9c0e264","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"3","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":650,"y":100,"wires":[["d533dc1ee9ba7109","69771664520bea3e"]]},{"id":"d533dc1ee9ba7109","type":"debug","z":"e9cc758ca9c0e264","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1230,"y":100,"wires":[]},{"id":"69771664520bea3e","type":"template","z":"e9cc758ca9c0e264","name":"","field":"url","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"https://app1pub.smappee.net/dev/v3/servicelocation/59792/consumption?aggregation={{payload.aggregation}}&from={{payload.begin}}&to={{payload.eind}}","output":"str","x":780,"y":140,"wires":[["bb2bcc41990cbfe9","316fe09d2c0c2e23"]]},{"id":"bb2bcc41990cbfe9","type":"debug","z":"e9cc758ca9c0e264","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"url","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":240,"wires":[]},{"id":"2b78b70d3d9ba1f1","type":"ui_dropdown","z":"e9cc758ca9c0e264","name":"","label":"Selecteer het gewenste interval","tooltip":"","place":"Selecteer het gewenste interval","group":"b784de15b0f65054","order":4,"width":0,"height":0,"passthru":true,"multiple":false,"options":[{"label":"5 min.","value":1,"type":"num"},{"label":"10 min.","value":6,"type":"num"},{"label":"15 min.","value":7,"type":"num"},{"label":"20 min.","value":8,"type":"num"},{"label":"30 min.","value":9,"type":"num"},{"label":"1 uur","value":2,"type":"num"},{"label":"1 dag","value":3,"type":"num"},{"label":"1 maand","value":4,"type":"num"},{"label":"1 kwartaal","value":5,"type":"num"}],"payload":"","topic":"aggregation","topicType":"str","className":"","x":430,"y":180,"wires":[["22eb8d76cd60d294"]]},{"id":"316fe09d2c0c2e23","type":"http request","z":"e9cc758ca9c0e264","name":"Elektriciteitsverbruik","method":"GET","ret":"obj","paytoqs":"ignore","url":"","tls":"","persist":false,"proxy":"","authType":"bearer","senderr":false,"credentials":{"password":""},"x":1020,"y":320,"wires":[["76d232fe41bdc056","aba6057474d50d98","888ba66c125f0021","2b0a0146c2578bee","9bd5f6ada8b15526","ec3190db27566a03","04154ffd1c6a7852","27f25f8a873e7605","2ada35437fef6bf9","de99f35833361ef8","1a8ad8791ef61f84"]]},{"id":"fefbc8f857531323","type":"debug","z":"e9cc758ca9c0e264","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1630,"y":320,"wires":[]},{"id":"2df1f39c23ce8698","type":"comment","z":"e9cc758ca9c0e264","name":"Info elektriciteitsverbruik","info":"Elektriciteitsverbruik, hieruit kan je volgende \nzaken gaan halen:\n - tijdstip \n - consumptie \n - zonne-energie\n - sluimerverbruik\n - grid import\n - grid export\n - zelfconsumptie \n - zelfvoorziening \n - actief vermogen\n - reactief vermogen\n - fasespanningen\n\nDe tijdstippen kunnen afhankelijk van de \naggregation ingesteld worden, daarnaast moeten \ner ook 2 tijdstippen gegeven worden","x":1020,"y":280,"wires":[]},{"id":"27f25f8a873e7605","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"Tijd elektriciteitsverbruik","func":"\nvar ELEK_TIJD = global.get('elek_tijd') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_TIJD[i]= msg.payload.consumptions[i].timestamp\n}\n\nmsg.payload= ELEK_TIJD;\nglobal.set('elek_tijd',ELEK_TIJD);\n\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1330,"y":200,"wires":[["fefbc8f857531323"]]},{"id":"04154ffd1c6a7852","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"Verbruik elektriciteitsverbruik","func":"var ELEK_VERBRUIK = global.get('elek_verbruik') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_VERBRUIK[i]= msg.payload.consumptions[i].consumption\n}\n\nmsg.payload= ELEK_VERBRUIK;\nglobal.set('elek_verbruik',ELEK_VERBRUIK);\n\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1340,"y":240,"wires":[["fefbc8f857531323"]]},{"id":"ec3190db27566a03","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"Zonne-energie elektricitetisverbruik","func":"var ELEK_SOLAR = global.get('elek_solar') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_SOLAR[i]= msg.payload.consumptions[i].solar\n}\n\nmsg.payload= ELEK_SOLAR;\nglobal.set('elek_solar',ELEK_SOLAR);\n\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1360,"y":280,"wires":[["fefbc8f857531323"]]},{"id":"9bd5f6ada8b15526","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"Sluimerverbruik elektriciteitsverbruik","func":"var ELEK_SLUIMER = global.get('elek_sluimer') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_SLUIMER[i]= msg.payload.consumptions[i].alwaysOn\n}\n\nmsg.payload= ELEK_SLUIMER;\nglobal.set('elek_sluimer',ELEK_SLUIMER);\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1370,"y":320,"wires":[["fefbc8f857531323"]]},{"id":"2b0a0146c2578bee","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"gridImport elektriciteitsverbruik","func":"var ELEK_GRIDIMPORT = global.get('elek_gridimport') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_GRIDIMPORT[i]= msg.payload.consumptions[i].gridImport\n}\n\nmsg.payload= ELEK_GRIDIMPORT;\nglobal.set('elek_gridimport',ELEK_GRIDIMPORT);\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1350,"y":360,"wires":[["fefbc8f857531323"]]},{"id":"888ba66c125f0021","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"gridExport elektriciteitsverbruik","func":"var ELEK_GRIDEXPORT = global.get('elek_gridexport') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_GRIDEXPORT[i]= msg.payload.consumptions[i].gridExport\n}\n\nmsg.payload= ELEK_GRIDEXPORT;\nglobal.set('elek_gridexport',ELEK_GRIDEXPORT);\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1350,"y":400,"wires":[["fefbc8f857531323"]]},{"id":"aba6057474d50d98","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"zelfconsumptie elektriciteitsverbruik","func":"var ELEK_ZELFCONSUMPTIE = global.get('elek_zelfconsumptie') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_ZELFCONSUMPTIE[i]= msg.payload.consumptions[i].selfConsumption\n}\n\nmsg.payload= ELEK_ZELFCONSUMPTIE;\nglobal.set('elek_zelfconsumptie',ELEK_ZELFCONSUMPTIE);\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1360,"y":440,"wires":[["fefbc8f857531323"]]},{"id":"76d232fe41bdc056","type":"function","z":"e9cc758ca9c0e264","d":true,"name":"zelfvoorziening elektriciteitsverbruik","func":"var ELEK_ZELFVOORZIEING = global.get('elek_zelfvoorziening') || [];\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n ELEK_ZELFVOORZIEING[i]= msg.payload.consumptions[i].selfSufficiency\n}\n\nmsg.payload= ELEK_ZELFVOORZIEING;\nglobal.set('elek_zelfvoorziening',ELEK_ZELFVOORZIEING);\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1360,"y":480,"wires":[["fefbc8f857531323"]]},{"id":"2ada35437fef6bf9","type":"debug","z":"e9cc758ca9c0e264","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1230,"y":140,"wires":[]},{"id":"de99f35833361ef8","type":"function","z":"e9cc758ca9c0e264","name":"","func":"global.set(\"WaardenZonneEnergie\",[\n    ['Tijd'],\n    ['Verbruik'],\n    ['Zonne Energie'],\n    ['Sluimerverbruik'],\n    ['GridImport'],\n    ['GridExport'],\n    ['Zelfconsumptie'],\n    ['Zelfvoorziening'],\n    ])\n\n\nvar WaardenZonneEnergie = global.get('WaardenZonneEnergie');\n\nfor(var i = 0; i <msg.payload.consumptions.length ; i++){\n WaardenZonneEnergie[0][i]= msg.payload.consumptions[i].timestamp\n WaardenZonneEnergie[1][i]= msg.payload.consumptions[i].consumption\n WaardenZonneEnergie[2][i]= msg.payload.consumptions[i].solar\n WaardenZonneEnergie[3][i]= msg.payload.consumptions[i].alwaysOn\n WaardenZonneEnergie[4][i]= msg.payload.consumptions[i].gridImport\n WaardenZonneEnergie[5][i]= msg.payload.consumptions[i].gridExport\n WaardenZonneEnergie[6][i]= msg.payload.consumptions[i].selfConsumption\n WaardenZonneEnergie[7][i]= msg.payload.consumptions[i].selfSufficiency\n    \n}\n\nmsg.payload= WaardenZonneEnergie;\n\nreturn msg;\n \n \n ","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1280,"y":540,"wires":[["d84e1fc537fcc899"]]},{"id":"d84e1fc537fcc899","type":"debug","z":"e9cc758ca9c0e264","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1450,"y":540,"wires":[]},{"id":"1a8ad8791ef61f84","type":"debug","z":"e9cc758ca9c0e264","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1290,"y":580,"wires":[]},{"id":"b784de15b0f65054","type":"ui_group","name":"Vul hier de datums in van het gewenste bereik:","tab":"3bf763b3a01dd2b9","order":1,"disp":true,"width":"6","collapse":false,"className":""},{"id":"3bf763b3a01dd2b9","type":"ui_tab","name":"Zonne Energie","icon":"dashboard","order":6,"disabled":false,"hidden":true}]

zenofmud · 22 February 2022 14:26

can you give an example of what you want it to look like?

Olivia · 22 February 2022 14:32

Knipsel

Steve-Mcl · 22 February 2022 14:36

Olivia, arrays cannot be named.

Do you want an array of Objects or an Object with properties?

See my earlier post.

Olivia · 22 February 2022 14:37

I think that properties will be the most efficient

Steve-Mcl · 22 February 2022 14:42

Do you want this data turned into an object with properties BEFORE you add it to Global context

OR

Do you want this data turned into an object with properties from the arrays in Global context

Olivia · 22 February 2022 14:46

Before

thanks in advance Steve

Steve-Mcl · 22 February 2022 14:47

OK, last thing, you will need to provide sample data (as we have no access to that API).

Can you grab a copy of your data that comes from the API (you can sanitise it if necessary)

click the copy value button like this...

... then paste data in a reply (wrapped in a code fence ``` )

Olivia · 22 February 2022 14:49

[[1644192000000,1644195600000,1644199200000,1644202800000,1644206400000,1644210000000,1644213600000,1644217200000,1644220800000,1644224400000,1644228000000,1644231600000,1644235200000,1644238800000,1644242400000,1644246000000,1644249600000,1644253200000,1644256800000,1644260400000,1644264000000,1644267600000,1644271200000,1644274800000],[336.025,300.081,333.897,319.564,367.382,577.826,1330.893,3824.829,11695.405,11767.041,11982.796,442.856,299.342,425.192,312.828,737.092,486.569,380.691,386.07,401.626,406.684,399.657,386.328,405.801],[-9.634,-9.628,-9.629,-9.629,-9.631,-9.63,-9.734,107.991,1526.015,3033.317,4176.648,4936.099,4742.628,3962.638,2837.953,1320.26,96.161,-10.345,-9.637,-9.63,-9.634,-9.632,-9.632,-9.633],[274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826,274.826],[346.06,310.011,343.827,329.394,377.115,587.457,1340.828,3716.839,10169.29,8733.724,7806.148,73.421,0,0,0,349.3,390.473,391.337,395.908,411.557,416.518,409.591,396.261,415.735],[0,0,0,0,0,0,0,0,0,0,0,4566.864,4443.586,3537.445,2525.325,932.568,0.065,0,0,0,0,0,0,0],[0,0,0,0,0,0,0,100,100,100,100,7.48,6.31,10.73,11.02,29.36,99.93,0,0,0,0,0,0,0],[0,0,0,0,0,0,0,2.82,13.05,25.78,34.86,83.42,100,100,100,52.61,19.75,0,0,0,0,0,0,0]]

Steve-Mcl · 22 February 2022 14:52

Are you 100% certain that is exactly what comes directly from the HTTP Request node?

There is nothing to identify which row is which?

Olivia · 22 February 2022 14:55

[{"timestamp":1644192000000,"consumption":336.025,"solar":-9.634,"alwaysOn":274.826,"gridImport":346.06,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[102.9,117.8,125.4,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-127,62.7,-139.5,20.4,19.2,19.4,51.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[242.3,242.4,243.4],"phaseVoltages":[242.3,242.4,243.4],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644195600000,"consumption":300.081,"solar":-9.628,"alwaysOn":274.826,"gridImport":310.011,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[101.8,85.4,122.8,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-125.6,41.6,-140.2,20.4,19,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.5,239.5,240.4],"phaseVoltages":[239.5,239.5,240.4],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644199200000,"consumption":333.897,"solar":-9.629,"alwaysOn":274.826,"gridImport":343.827,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[101.9,118.8,123,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-125.6,60.3,-140,20.4,18.9,19.2,50.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.6,239.5,240.5],"phaseVoltages":[239.6,239.5,240.5],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644202800000,"consumption":319.564,"solar":-9.629,"alwaysOn":274.826,"gridImport":329.394,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[101,105.9,122.8,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-124.6,49.5,-141.4,20.1,18.3,19.2,49.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.1,239.2,240.2],"phaseVoltages":[239.1,239.2,240.2],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644206400000,"consumption":367.382,"solar":-9.631,"alwaysOn":274.826,"gridImport":377.115,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[126.6,127.5,123.2,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-130.2,64.7,-141.2,20.4,18.9,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.6,239.4,240.7],"phaseVoltages":[239.6,239.4,240.7],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644210000000,"consumption":577.826,"solar":-9.63,"alwaysOn":274.826,"gridImport":587.457,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[205.9,169.9,211.9,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-126.5,47.2,-151.1,20.1,18.5,19.2,49.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[238.2,238.2,239.3],"phaseVoltages":[238.2,238.2,239.3],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644213600000,"consumption":1330.893,"solar":-9.734,"alwaysOn":274.826,"gridImport":1340.828,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[287.5,515.2,538.2,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-161.8,54.4,-173.1,19.8,18.3,19.2,49.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[237.3,237.1,238],"phaseVoltages":[237.3,237.1,238],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644217200000,"consumption":3824.829,"solar":107.991,"alwaysOn":274.826,"gridImport":3716.839,"gridExport":0,"selfConsumption":100,"selfSufficiency":2.82,"active":[1151.2,1306.8,1258.7,5.4,38.9,31.1,32.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-238.3,-121.3,-312.4,149.3,151.9,131.8,117.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[238.3,238.9,239.3],"phaseVoltages":[238.3,238.9,239.3],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644220800000,"consumption":11695.405,"solar":1526.015,"alwaysOn":274.826,"gridImport":10169.29,"gridExport":0,"selfConsumption":100,"selfSufficiency":13.05,"active":[3569.6,3525.6,3073.9,329.9,352.6,348.2,495.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-282.3,158.9,-319.1,131,132.3,125.5,-71.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[235.6,236.1,236.6],"phaseVoltages":[235.6,236.1,236.6],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644224400000,"consumption":11767.041,"solar":3033.317,"alwaysOn":274.826,"gridImport":8733.724,"gridExport":0,"selfConsumption":100,"selfSufficiency":25.78,"active":[3253.1,3238.9,2241.8,656.7,682.2,677.1,1017.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-251.4,268.7,320.8,85.9,87.6,87,-104.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[236.3,236.6,237.7],"phaseVoltages":[236.3,236.6,237.7],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644228000000,"consumption":11982.796,"solar":4176.648,"alwaysOn":274.826,"gridImport":7806.148,"gridExport":0,"selfConsumption":100,"selfSufficiency":34.86,"active":[3042.8,3075.6,1687.7,903.5,933.2,926.4,1413.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-40.2,278.3,351.4,94.4,97.8,96.2,-40.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[238.6,239.1,240.1],"phaseVoltages":[238.6,239.1,240.1],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644231600000,"consumption":442.856,"solar":4936.099,"alwaysOn":274.826,"gridImport":73.421,"gridExport":4566.864,"selfConsumption":7.48,"selfSufficiency":83.42,"active":[-937.9,-942.9,-2612.6,1065.6,1098.8,1091,1680.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-151.7,109,-185.4,85.4,88.4,83.1,-66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.4,240.3,241.1],"phaseVoltages":[239.4,240.3,241.1],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644235200000,"consumption":299.342,"solar":4742.628,"alwaysOn":274.826,"gridImport":0,"gridExport":4443.586,"selfConsumption":6.31,"selfSufficiency":100,"active":[-933.2,-957.5,-2552.9,1020.2,1051,1044.8,1626.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-158.3,99.2,-207.4,92.9,92.4,91,77.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[238.5,239.1,240],"phaseVoltages":[238.5,239.1,240],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644238800000,"consumption":425.192,"solar":3962.638,"alwaysOn":274.826,"gridImport":0,"gridExport":3537.445,"selfConsumption":10.73,"selfSufficiency":100,"active":[-758,-702.3,-2077,846.4,874.2,868.3,1373.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-148.8,96.9,-185.3,82.4,80,79.9,-91.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.2,239.3,240.3],"phaseVoltages":[239.2,239.3,240.3],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644242400000,"consumption":312.828,"solar":2837.953,"alwaysOn":274.826,"gridImport":0,"gridExport":2525.325,"selfConsumption":11.02,"selfSufficiency":100,"active":[-510.9,-516.5,-1497.8,598.8,624.5,617.9,996.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-154.9,41.3,-176.3,80.4,78.2,74.8,-94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.1,239.5,240],"phaseVoltages":[239.1,239.5,240],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644246000000,"consumption":737.092,"solar":1320.26,"alwaysOn":274.826,"gridImport":349.3,"gridExport":932.568,"selfConsumption":29.36,"selfSufficiency":52.61,"active":[-170.4,-11.5,-401.4,272.7,294,290,463.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-216.1,-93.6,-244.6,142.1,141.7,136.7,-38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[238.2,238.5,239],"phaseVoltages":[238.2,238.5,239],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644249600000,"consumption":486.569,"solar":96.161,"alwaysOn":274.826,"gridImport":390.473,"gridExport":0.065,"selfConsumption":99.93,"selfSufficiency":19.75,"active":[91.1,170.6,128.4,9.4,29.5,26.1,30.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-239,-97.2,-305,159.7,158.2,152.4,113,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[238.7,239,239.7],"phaseVoltages":[238.7,239,239.7],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644253200000,"consumption":380.691,"solar":-10.345,"alwaysOn":274.826,"gridImport":391.337,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[156,113.2,122.2,-5.3,0,0,-5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-133.1,58.2,-143.7,20.4,18.8,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.4,239.5,240.5],"phaseVoltages":[239.4,239.5,240.5],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644256800000,"consumption":386.07,"solar":-9.637,"alwaysOn":274.826,"gridImport":395.908,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[182.7,90.4,122.7,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-134.9,45.4,-141.7,20.4,18.7,19.2,50.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.6,239.8,240.9],"phaseVoltages":[239.6,239.8,240.9],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644260400000,"consumption":401.626,"solar":-9.63,"alwaysOn":274.826,"gridImport":411.557,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[182.1,106.8,122.5,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-134.9,54.5,-141,20.4,18.8,19.2,50.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.7,239.5,241],"phaseVoltages":[239.7,239.5,241],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644264000000,"consumption":406.684,"solar":-9.634,"alwaysOn":274.826,"gridImport":416.518,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[181.5,112.6,122.3,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-134.8,57.8,-141.6,20.4,18.6,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.3,239.3,240.5],"phaseVoltages":[239.3,239.3,240.5],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644267600000,"consumption":399.657,"solar":-9.632,"alwaysOn":274.826,"gridImport":409.591,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[181,106.6,122,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-135.2,55.1,-142.5,20.2,18.4,19.2,49.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[238.9,239,240.1],"phaseVoltages":[238.9,239,240.1],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644271200000,"consumption":386.328,"solar":-9.632,"alwaysOn":274.826,"gridImport":396.261,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[181.6,91.9,122.7,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-135.1,45.1,-140.7,20.4,19.2,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[239.9,240.3,241],"phaseVoltages":[239.9,240.3,241],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{"timestamp":1644274800000,"consumption":405.801,"solar":-9.633,"alwaysOn":274.826,"gridImport":415.735,"gridExport":0,"selfConsumption":0,"selfSufficiency":0,"active":[182.1,110.3,123.3,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"reactive":[-134.9,58.3,-141,20.4,19.2,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"voltages":[240.5,240.9,241.6],"phaseVoltages":[240.5,240.9,241.6],"currentHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"voltageHarmonics":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]}]

Steve-Mcl · 22 February 2022 15:09

Hi Olivia.

As you have not clearly indicated what the output should look like, I have done 3 examples you can use the most suitable (or adapt it) - it should be enough to get you moving...

Demo Flow...

[{"id":"2df1f39c23ce8698","type":"comment","z":"62dd2f0711b4f336","name":"Info elektriciteitsverbruik","info":"Elektriciteitsverbruik, hieruit kan je volgende \nzaken gaan halen:\n - tijdstip \n - consumptie \n - zonne-energie\n - sluimerverbruik\n - grid import\n - grid export\n - zelfconsumptie \n - zelfvoorziening \n - actief vermogen\n - reactief vermogen\n - fasespanningen\n\nDe tijdstippen kunnen afhankelijk van de \naggregation ingesteld worden, daarnaast moeten \ner ook 2 tijdstippen gegeven worden","x":1120,"y":480,"wires":[]},{"id":"2ddfcf16b6092402","type":"inject","z":"62dd2f0711b4f336","name":"API data","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"timestamp\":1644192000000,\"consumption\":336.025,\"solar\":-9.634,\"alwaysOn\":274.826,\"gridImport\":346.06,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[102.9,117.8,125.4,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-127,62.7,-139.5,20.4,19.2,19.4,51.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[242.3,242.4,243.4],\"phaseVoltages\":[242.3,242.4,243.4],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644195600000,\"consumption\":300.081,\"solar\":-9.628,\"alwaysOn\":274.826,\"gridImport\":310.011,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[101.8,85.4,122.8,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-125.6,41.6,-140.2,20.4,19,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.5,239.5,240.4],\"phaseVoltages\":[239.5,239.5,240.4],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644199200000,\"consumption\":333.897,\"solar\":-9.629,\"alwaysOn\":274.826,\"gridImport\":343.827,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[101.9,118.8,123,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-125.6,60.3,-140,20.4,18.9,19.2,50.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.6,239.5,240.5],\"phaseVoltages\":[239.6,239.5,240.5],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644202800000,\"consumption\":319.564,\"solar\":-9.629,\"alwaysOn\":274.826,\"gridImport\":329.394,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[101,105.9,122.8,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-124.6,49.5,-141.4,20.1,18.3,19.2,49.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.1,239.2,240.2],\"phaseVoltages\":[239.1,239.2,240.2],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644206400000,\"consumption\":367.382,\"solar\":-9.631,\"alwaysOn\":274.826,\"gridImport\":377.115,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[126.6,127.5,123.2,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-130.2,64.7,-141.2,20.4,18.9,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.6,239.4,240.7],\"phaseVoltages\":[239.6,239.4,240.7],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644210000000,\"consumption\":577.826,\"solar\":-9.63,\"alwaysOn\":274.826,\"gridImport\":587.457,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[205.9,169.9,211.9,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-126.5,47.2,-151.1,20.1,18.5,19.2,49.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.2,238.2,239.3],\"phaseVoltages\":[238.2,238.2,239.3],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644213600000,\"consumption\":1330.893,\"solar\":-9.734,\"alwaysOn\":274.826,\"gridImport\":1340.828,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[287.5,515.2,538.2,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-161.8,54.4,-173.1,19.8,18.3,19.2,49.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[237.3,237.1,238],\"phaseVoltages\":[237.3,237.1,238],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644217200000,\"consumption\":3824.829,\"solar\":107.991,\"alwaysOn\":274.826,\"gridImport\":3716.839,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":2.82,\"active\":[1151.2,1306.8,1258.7,5.4,38.9,31.1,32.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-238.3,-121.3,-312.4,149.3,151.9,131.8,117.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.3,238.9,239.3],\"phaseVoltages\":[238.3,238.9,239.3],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644220800000,\"consumption\":11695.405,\"solar\":1526.015,\"alwaysOn\":274.826,\"gridImport\":10169.29,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":13.05,\"active\":[3569.6,3525.6,3073.9,329.9,352.6,348.2,495.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-282.3,158.9,-319.1,131,132.3,125.5,-71.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[235.6,236.1,236.6],\"phaseVoltages\":[235.6,236.1,236.6],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644224400000,\"consumption\":11767.041,\"solar\":3033.317,\"alwaysOn\":274.826,\"gridImport\":8733.724,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":25.78,\"active\":[3253.1,3238.9,2241.8,656.7,682.2,677.1,1017.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-251.4,268.7,320.8,85.9,87.6,87,-104.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[236.3,236.6,237.7],\"phaseVoltages\":[236.3,236.6,237.7],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644228000000,\"consumption\":11982.796,\"solar\":4176.648,\"alwaysOn\":274.826,\"gridImport\":7806.148,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":34.86,\"active\":[3042.8,3075.6,1687.7,903.5,933.2,926.4,1413.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-40.2,278.3,351.4,94.4,97.8,96.2,-40.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.6,239.1,240.1],\"phaseVoltages\":[238.6,239.1,240.1],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644231600000,\"consumption\":442.856,\"solar\":4936.099,\"alwaysOn\":274.826,\"gridImport\":73.421,\"gridExport\":4566.864,\"selfConsumption\":7.48,\"selfSufficiency\":83.42,\"active\":[-937.9,-942.9,-2612.6,1065.6,1098.8,1091,1680.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-151.7,109,-185.4,85.4,88.4,83.1,-66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.4,240.3,241.1],\"phaseVoltages\":[239.4,240.3,241.1],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644235200000,\"consumption\":299.342,\"solar\":4742.628,\"alwaysOn\":274.826,\"gridImport\":0,\"gridExport\":4443.586,\"selfConsumption\":6.31,\"selfSufficiency\":100,\"active\":[-933.2,-957.5,-2552.9,1020.2,1051,1044.8,1626.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-158.3,99.2,-207.4,92.9,92.4,91,77.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.5,239.1,240],\"phaseVoltages\":[238.5,239.1,240],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644238800000,\"consumption\":425.192,\"solar\":3962.638,\"alwaysOn\":274.826,\"gridImport\":0,\"gridExport\":3537.445,\"selfConsumption\":10.73,\"selfSufficiency\":100,\"active\":[-758,-702.3,-2077,846.4,874.2,868.3,1373.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-148.8,96.9,-185.3,82.4,80,79.9,-91.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.2,239.3,240.3],\"phaseVoltages\":[239.2,239.3,240.3],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644242400000,\"consumption\":312.828,\"solar\":2837.953,\"alwaysOn\":274.826,\"gridImport\":0,\"gridExport\":2525.325,\"selfConsumption\":11.02,\"selfSufficiency\":100,\"active\":[-510.9,-516.5,-1497.8,598.8,624.5,617.9,996.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-154.9,41.3,-176.3,80.4,78.2,74.8,-94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.1,239.5,240],\"phaseVoltages\":[239.1,239.5,240],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644246000000,\"consumption\":737.092,\"solar\":1320.26,\"alwaysOn\":274.826,\"gridImport\":349.3,\"gridExport\":932.568,\"selfConsumption\":29.36,\"selfSufficiency\":52.61,\"active\":[-170.4,-11.5,-401.4,272.7,294,290,463.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-216.1,-93.6,-244.6,142.1,141.7,136.7,-38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.2,238.5,239],\"phaseVoltages\":[238.2,238.5,239],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644249600000,\"consumption\":486.569,\"solar\":96.161,\"alwaysOn\":274.826,\"gridImport\":390.473,\"gridExport\":0.065,\"selfConsumption\":99.93,\"selfSufficiency\":19.75,\"active\":[91.1,170.6,128.4,9.4,29.5,26.1,30.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-239,-97.2,-305,159.7,158.2,152.4,113,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.7,239,239.7],\"phaseVoltages\":[238.7,239,239.7],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644253200000,\"consumption\":380.691,\"solar\":-10.345,\"alwaysOn\":274.826,\"gridImport\":391.337,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[156,113.2,122.2,-5.3,0,0,-5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-133.1,58.2,-143.7,20.4,18.8,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.4,239.5,240.5],\"phaseVoltages\":[239.4,239.5,240.5],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644256800000,\"consumption\":386.07,\"solar\":-9.637,\"alwaysOn\":274.826,\"gridImport\":395.908,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[182.7,90.4,122.7,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.9,45.4,-141.7,20.4,18.7,19.2,50.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.6,239.8,240.9],\"phaseVoltages\":[239.6,239.8,240.9],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644260400000,\"consumption\":401.626,\"solar\":-9.63,\"alwaysOn\":274.826,\"gridImport\":411.557,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[182.1,106.8,122.5,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.9,54.5,-141,20.4,18.8,19.2,50.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.7,239.5,241],\"phaseVoltages\":[239.7,239.5,241],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644264000000,\"consumption\":406.684,\"solar\":-9.634,\"alwaysOn\":274.826,\"gridImport\":416.518,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[181.5,112.6,122.3,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.8,57.8,-141.6,20.4,18.6,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.3,239.3,240.5],\"phaseVoltages\":[239.3,239.3,240.5],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644267600000,\"consumption\":399.657,\"solar\":-9.632,\"alwaysOn\":274.826,\"gridImport\":409.591,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[181,106.6,122,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-135.2,55.1,-142.5,20.2,18.4,19.2,49.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.9,239,240.1],\"phaseVoltages\":[238.9,239,240.1],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644271200000,\"consumption\":386.328,\"solar\":-9.632,\"alwaysOn\":274.826,\"gridImport\":396.261,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[181.6,91.9,122.7,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-135.1,45.1,-140.7,20.4,19.2,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.9,240.3,241],\"phaseVoltages\":[239.9,240.3,241],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644274800000,\"consumption\":405.801,\"solar\":-9.633,\"alwaysOn\":274.826,\"gridImport\":415.735,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[182.1,110.3,123.3,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.9,58.3,-141,20.4,19.2,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[240.5,240.9,241.6],\"phaseVoltages\":[240.5,240.9,241.6],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]}]","payloadType":"json","x":1140,"y":520,"wires":[["2622769a196bb0a3","b01a11d8979a66f9","a0b37fc4bc7c54ac"]]},{"id":"2622769a196bb0a3","type":"function","z":"62dd2f0711b4f336","name":"as array of objects","func":"function transformRow(row) {\n    return {\n        Tijd: row.timestamp,\n        Verbruik: row.consumption,\n        Zonne: row.solar,\n        Sluimerverbruik: row.alwaysOn,\n        GridImport: row.gridImport,\n        GridExport: row.gridExport,\n        Zelfconsumptie: row.selfConsumption,\n        Zelfvoorziening: row.selfSufficiency,\n    }\n}\n\nconst APIdata = msg.payload;\nconst transformedData = []\nfor (let index = 0; index < APIdata.length; index++) {\n    const row = APIdata[index];\n    transformedData.push(transformRow(row))\n}\n\nmsg.payload = transformedData;\n\nreturn msg;\n\n\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1370,"y":480,"wires":[["9fa54abc126649a5"]]},{"id":"9fa54abc126649a5","type":"debug","z":"62dd2f0711b4f336","name":"as array of objects","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1590,"y":480,"wires":[]},{"id":"b01a11d8979a66f9","type":"function","z":"62dd2f0711b4f336","name":"rotate data","func":"const rotated = {\n    timestamp: [],\n    consumption: [],\n    solar: [],\n    alwaysOn: [],\n    gridImport: [],\n    gridExport: [],\n    selfConsumption: [],\n    selfSufficiency: [],\n}\n\n\nconst APIdata = msg.payload;\nfor (var i = 0; i < APIdata.length; i++) {\n    rotated.timestamp[i] = APIdata[i].timestamp\n    rotated.consumption[i] = APIdata[i].consumption\n    rotated.solar[i] = APIdata[i].solar\n    rotated.alwaysOn[i] = APIdata[i].alwaysOn\n    rotated.gridImport[i] = APIdata[i].gridImport\n    rotated.gridExport[i] = APIdata[i].gridExport\n    rotated.selfConsumption[i] = APIdata[i].selfConsumption\n    rotated.selfSufficiency[i] = APIdata[i].selfSufficiency\n\n}\n\nmsg.payload = rotated;\n\nreturn msg;\n\n\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1350,"y":520,"wires":[["59f2ad6b265f8c90"]]},{"id":"59f2ad6b265f8c90","type":"debug","z":"62dd2f0711b4f336","name":"Rotated Data","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1570,"y":520,"wires":[]},{"id":"a0b37fc4bc7c54ac","type":"function","z":"62dd2f0711b4f336","name":"rotate and rename","func":"const rotated = {\n    Tijd: [],\n    Verbruik: [],\n    Zonne: [],\n    Sluimerverbruik: [],\n    GridImport: [],\n    GridExport: [],\n    Zelfconsumptie: [],\n    Zelfvoorziening: [],\n}\n\n\nconst APIdata = msg.payload;\nfor (var i = 0; i < APIdata.length; i++) {\n    rotated.Tijd[i] = APIdata[i].timestamp\n    rotated.Verbruik[i] = APIdata[i].consumption\n    rotated.Zonne[i] = APIdata[i].solar\n    rotated.Sluimerverbruik[i] = APIdata[i].alwaysOn\n    rotated.GridImport[i] = APIdata[i].gridImport\n    rotated.GridExport[i] = APIdata[i].gridExport\n    rotated.Zelfconsumptie[i] = APIdata[i].selfConsumption\n    rotated.Zelfvoorziening[i] = APIdata[i].selfSufficiency\n\n}\n\nmsg.payload = rotated;\n\nreturn msg;\n\n\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1370,"y":560,"wires":[["2fda25aff567b69b"]]},{"id":"2fda25aff567b69b","type":"debug","z":"62dd2f0711b4f336","name":"rotate and rename","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1590,"y":560,"wires":[]}]

as array of objects

rotate data

rotate and rename

Olivia · 22 February 2022 15:18

Thanks Steve !!

Olivia · 23 February 2022 08:05

Hi Steve,

just another little question. I would like to plot some lines of the array but i get some errors when i try this... Could you or someone else help me please ?

[{"id":"2ddfcf16b6092402","type":"inject","z":"a3bd51210d5662bf","name":"API data","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"timestamp\":1644192000000,\"consumption\":336.025,\"solar\":-9.634,\"alwaysOn\":274.826,\"gridImport\":346.06,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[102.9,117.8,125.4,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-127,62.7,-139.5,20.4,19.2,19.4,51.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[242.3,242.4,243.4],\"phaseVoltages\":[242.3,242.4,243.4],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644195600000,\"consumption\":300.081,\"solar\":-9.628,\"alwaysOn\":274.826,\"gridImport\":310.011,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[101.8,85.4,122.8,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-125.6,41.6,-140.2,20.4,19,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.5,239.5,240.4],\"phaseVoltages\":[239.5,239.5,240.4],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644199200000,\"consumption\":333.897,\"solar\":-9.629,\"alwaysOn\":274.826,\"gridImport\":343.827,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[101.9,118.8,123,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-125.6,60.3,-140,20.4,18.9,19.2,50.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.6,239.5,240.5],\"phaseVoltages\":[239.6,239.5,240.5],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644202800000,\"consumption\":319.564,\"solar\":-9.629,\"alwaysOn\":274.826,\"gridImport\":329.394,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[101,105.9,122.8,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-124.6,49.5,-141.4,20.1,18.3,19.2,49.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.1,239.2,240.2],\"phaseVoltages\":[239.1,239.2,240.2],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644206400000,\"consumption\":367.382,\"solar\":-9.631,\"alwaysOn\":274.826,\"gridImport\":377.115,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[126.6,127.5,123.2,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-130.2,64.7,-141.2,20.4,18.9,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.6,239.4,240.7],\"phaseVoltages\":[239.6,239.4,240.7],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644210000000,\"consumption\":577.826,\"solar\":-9.63,\"alwaysOn\":274.826,\"gridImport\":587.457,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[205.9,169.9,211.9,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-126.5,47.2,-151.1,20.1,18.5,19.2,49.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.2,238.2,239.3],\"phaseVoltages\":[238.2,238.2,239.3],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644213600000,\"consumption\":1330.893,\"solar\":-9.734,\"alwaysOn\":274.826,\"gridImport\":1340.828,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[287.5,515.2,538.2,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-161.8,54.4,-173.1,19.8,18.3,19.2,49.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[237.3,237.1,238],\"phaseVoltages\":[237.3,237.1,238],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644217200000,\"consumption\":3824.829,\"solar\":107.991,\"alwaysOn\":274.826,\"gridImport\":3716.839,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":2.82,\"active\":[1151.2,1306.8,1258.7,5.4,38.9,31.1,32.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-238.3,-121.3,-312.4,149.3,151.9,131.8,117.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.3,238.9,239.3],\"phaseVoltages\":[238.3,238.9,239.3],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644220800000,\"consumption\":11695.405,\"solar\":1526.015,\"alwaysOn\":274.826,\"gridImport\":10169.29,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":13.05,\"active\":[3569.6,3525.6,3073.9,329.9,352.6,348.2,495.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-282.3,158.9,-319.1,131,132.3,125.5,-71.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[235.6,236.1,236.6],\"phaseVoltages\":[235.6,236.1,236.6],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644224400000,\"consumption\":11767.041,\"solar\":3033.317,\"alwaysOn\":274.826,\"gridImport\":8733.724,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":25.78,\"active\":[3253.1,3238.9,2241.8,656.7,682.2,677.1,1017.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-251.4,268.7,320.8,85.9,87.6,87,-104.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[236.3,236.6,237.7],\"phaseVoltages\":[236.3,236.6,237.7],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644228000000,\"consumption\":11982.796,\"solar\":4176.648,\"alwaysOn\":274.826,\"gridImport\":7806.148,\"gridExport\":0,\"selfConsumption\":100,\"selfSufficiency\":34.86,\"active\":[3042.8,3075.6,1687.7,903.5,933.2,926.4,1413.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-40.2,278.3,351.4,94.4,97.8,96.2,-40.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.6,239.1,240.1],\"phaseVoltages\":[238.6,239.1,240.1],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644231600000,\"consumption\":442.856,\"solar\":4936.099,\"alwaysOn\":274.826,\"gridImport\":73.421,\"gridExport\":4566.864,\"selfConsumption\":7.48,\"selfSufficiency\":83.42,\"active\":[-937.9,-942.9,-2612.6,1065.6,1098.8,1091,1680.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-151.7,109,-185.4,85.4,88.4,83.1,-66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.4,240.3,241.1],\"phaseVoltages\":[239.4,240.3,241.1],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644235200000,\"consumption\":299.342,\"solar\":4742.628,\"alwaysOn\":274.826,\"gridImport\":0,\"gridExport\":4443.586,\"selfConsumption\":6.31,\"selfSufficiency\":100,\"active\":[-933.2,-957.5,-2552.9,1020.2,1051,1044.8,1626.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-158.3,99.2,-207.4,92.9,92.4,91,77.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.5,239.1,240],\"phaseVoltages\":[238.5,239.1,240],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644238800000,\"consumption\":425.192,\"solar\":3962.638,\"alwaysOn\":274.826,\"gridImport\":0,\"gridExport\":3537.445,\"selfConsumption\":10.73,\"selfSufficiency\":100,\"active\":[-758,-702.3,-2077,846.4,874.2,868.3,1373.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-148.8,96.9,-185.3,82.4,80,79.9,-91.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.2,239.3,240.3],\"phaseVoltages\":[239.2,239.3,240.3],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644242400000,\"consumption\":312.828,\"solar\":2837.953,\"alwaysOn\":274.826,\"gridImport\":0,\"gridExport\":2525.325,\"selfConsumption\":11.02,\"selfSufficiency\":100,\"active\":[-510.9,-516.5,-1497.8,598.8,624.5,617.9,996.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-154.9,41.3,-176.3,80.4,78.2,74.8,-94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.1,239.5,240],\"phaseVoltages\":[239.1,239.5,240],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644246000000,\"consumption\":737.092,\"solar\":1320.26,\"alwaysOn\":274.826,\"gridImport\":349.3,\"gridExport\":932.568,\"selfConsumption\":29.36,\"selfSufficiency\":52.61,\"active\":[-170.4,-11.5,-401.4,272.7,294,290,463.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-216.1,-93.6,-244.6,142.1,141.7,136.7,-38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.2,238.5,239],\"phaseVoltages\":[238.2,238.5,239],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644249600000,\"consumption\":486.569,\"solar\":96.161,\"alwaysOn\":274.826,\"gridImport\":390.473,\"gridExport\":0.065,\"selfConsumption\":99.93,\"selfSufficiency\":19.75,\"active\":[91.1,170.6,128.4,9.4,29.5,26.1,30.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-239,-97.2,-305,159.7,158.2,152.4,113,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.7,239,239.7],\"phaseVoltages\":[238.7,239,239.7],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644253200000,\"consumption\":380.691,\"solar\":-10.345,\"alwaysOn\":274.826,\"gridImport\":391.337,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[156,113.2,122.2,-5.3,0,0,-5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-133.1,58.2,-143.7,20.4,18.8,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.4,239.5,240.5],\"phaseVoltages\":[239.4,239.5,240.5],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644256800000,\"consumption\":386.07,\"solar\":-9.637,\"alwaysOn\":274.826,\"gridImport\":395.908,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[182.7,90.4,122.7,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.9,45.4,-141.7,20.4,18.7,19.2,50.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.6,239.8,240.9],\"phaseVoltages\":[239.6,239.8,240.9],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644260400000,\"consumption\":401.626,\"solar\":-9.63,\"alwaysOn\":274.826,\"gridImport\":411.557,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[182.1,106.8,122.5,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.9,54.5,-141,20.4,18.8,19.2,50.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.7,239.5,241],\"phaseVoltages\":[239.7,239.5,241],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644264000000,\"consumption\":406.684,\"solar\":-9.634,\"alwaysOn\":274.826,\"gridImport\":416.518,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[181.5,112.6,122.3,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.8,57.8,-141.6,20.4,18.6,19.2,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.3,239.3,240.5],\"phaseVoltages\":[239.3,239.3,240.5],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644267600000,\"consumption\":399.657,\"solar\":-9.632,\"alwaysOn\":274.826,\"gridImport\":409.591,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[181,106.6,122,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-135.2,55.1,-142.5,20.2,18.4,19.2,49.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[238.9,239,240.1],\"phaseVoltages\":[238.9,239,240.1],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644271200000,\"consumption\":386.328,\"solar\":-9.632,\"alwaysOn\":274.826,\"gridImport\":396.261,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[181.6,91.9,122.7,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-135.1,45.1,-140.7,20.4,19.2,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[239.9,240.3,241],\"phaseVoltages\":[239.9,240.3,241],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]},{\"timestamp\":1644274800000,\"consumption\":405.801,\"solar\":-9.633,\"alwaysOn\":274.826,\"gridImport\":415.735,\"gridExport\":0,\"selfConsumption\":0,\"selfSufficiency\":0,\"active\":[182.1,110.3,123.3,-4.8,0,0,-4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"reactive\":[-134.9,58.3,-141,20.4,19.2,19.2,50.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"voltages\":[240.5,240.9,241.6],\"phaseVoltages\":[240.5,240.9,241.6],\"currentHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],\"voltageHarmonics\":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]]}]","payloadType":"json","x":140,"y":80,"wires":[["a0b37fc4bc7c54ac"]]},{"id":"a0b37fc4bc7c54ac","type":"function","z":"a3bd51210d5662bf","name":"rotate and rename","func":"\n//Context aanmaken\nconst rotated = {\n Tijd: [],\n Verbruik: [],\n ZonneEnergie: [],\n Sluimerverbruik: [],\n GridImport: [],\n GridExport: [],\n Zelfconsumptie: [],\n Zelfvoorziening: [],\n}\n\n//Uitgelezen data in de context steken\nconst APIdata = msg.payload;\nfor (var i = 0; i < APIdata.length; i++) {\n rotated.Tijd[i] = APIdata[i].timestamp\n rotated.Verbruik[i] = APIdata[i].consumption\n rotated.ZonneEnergie[i] = APIdata[i].solar\n rotated.Sluimerverbruik[i] = APIdata[i].alwaysOn\n rotated.GridImport[i] = APIdata[i].gridImport\n rotated.GridExport[i] = APIdata[i].gridExport\n rotated.Zelfconsumptie[i] = APIdata[i].selfConsumption\n rotated.Zelfvoorziening[i] = APIdata[i].selfSufficiency\n}\n\n//Cotext toekennen aan een globale variabele\nglobal.set (\"ZonneEnergie\",rotated)\n\n//Waardern scheiden om te plotten\nmsg.payload = rotated;\nmsg1.payload = rotated.Verbruik;\nmsg2.payload = rotated.ZonneEnergie;\nmsg3.payload = rotated.Sluimerverbruik;\n\n//Weergeven in console\nreturn [msg,msg1,msg2,msg3];\n\n","outputs":4,"noerr":0,"initialize":"","finalize":"","libs":[],"x":410,"y":80,"wires":[["2fda25aff567b69b"],["2fda25aff567b69b"],["2fda25aff567b69b"],["2fda25aff567b69b"]]},{"id":"2fda25aff567b69b","type":"debug","z":"a3bd51210d5662bf","name":"rotate and rename","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":730,"y":80,"wires":[]}]

thanks in advance !
Olivia

Steve-Mcl · 23 February 2022 08:24

Hi Olivia.
Please let me make a suggestion.

When you post a question, it really helps your chances of getting a response if you post details relevant to the current problem.

for example, had you posted this question like this...

Hi, I have modified the function code but now I get an error "ReferenceError: msg1 is not defined (line 32, col 1)"

This is my new function...


//Context aanmaken
const rotated = {
    Tijd: [],
    Verbruik: [],
    ZonneEnergie: [],
    Sluimerverbruik: [],
    GridImport: [],
    GridExport: [],
    Zelfconsumptie: [],
    Zelfvoorziening: [],
}

//Uitgelezen data in de context steken
const APIdata = msg.payload;
for (var i = 0; i < APIdata.length; i++) {
    rotated.Tijd[i] = APIdata[i].timestamp
    rotated.Verbruik[i] = APIdata[i].consumption
    rotated.ZonneEnergie[i] = APIdata[i].solar
    rotated.Sluimerverbruik[i] = APIdata[i].alwaysOn
    rotated.GridImport[i] = APIdata[i].gridImport
    rotated.GridExport[i] = APIdata[i].gridExport
    rotated.Zelfconsumptie[i] = APIdata[i].selfConsumption
    rotated.Zelfvoorziening[i] = APIdata[i].selfSufficiency
}

//Cotext toekennen aan een globale variabele
global.set("ZonneEnergie", rotated)

//Waardern scheiden om te plotten
msg.payload = rotated;
msg1.payload = rotated.Verbruik;
msg2.payload = rotated.ZonneEnergie;
msg3.payload = rotated.Sluimerverbruik;

//Weergeven in console
return [msg, msg1, msg2, msg3];

Pretty much anyone with JS experience could help you - (without having to import and run your flow) - what the problem was.

Which is: You have not declared msg1, msg2 or msg3 to be objects and therefore you cannot set a payload property on any of these undefined variables.

Fix V1.

/**** <snipped for brevity> ****/
//Waardern scheiden om te plotten
msg.payload = rotated;
var msg1 = { payload: rotated.Verbruik };
var msg2 = { payload: rotated.ZonneEnergie };
var msg3 = { payload: rotated.Sluimerverbruik };
/**** <snipped for brevity> ****/

Fix V2.

/**** <snipped for brevity> ****/
//Waardern scheiden om te plotten
var msg1 = {}, msg2 = {}, msg3 = {};
msg.payload = rotated;
msg1.payload = rotated.Verbruik;
msg2.payload = rotated.ZonneEnergie;
msg3.payload = rotated.Sluimerverbruik;
/**** <snipped for brevity> ****/

The better fix

dont send 4 payloads, instead, use change nodes AFTER the function to move msg.payload.Verbruik into msg.payload

system · 9 March 2022 08:24

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
[Solved] How to get ObjectName (Object property) from array General	7	1121	10 October 2021
How can I change property name in object array? General	8	1067	2 January 2021
2-dimensional arrays General	4	2207	18 December 2020
Array Object Variable General	3	402	1 January 2021
Array selection help - Selecting last item in array General	15	108	30 December 2023