Hi, I copyed a flow from an other user, to write solecast data (future) into influxdb:
[
{
"id": "de74762b.088578",
"type": "split",
"z": "a85445c69706ecc9",
"name": "",
"splt": "\\n",
"spltType": "str",
"arraySplt": 1,
"arraySpltType": "len",
"stream": false,
"addname": "",
"x": 530,
"y": 1400,
"wires": [
[
"b7a911ed.41d26"
]
]
},
{
"id": "b7a911ed.41d26",
"type": "change",
"z": "a85445c69706ecc9",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "{\"PV\": $.payload.pv_estimate * 1000,\t\"time\": $toMillis($.payload.period_end)}",
"tot": "jsonata"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 710,
"y": 1400,
"wires": [
[
"e0e1d82318e724b2",
"264bbb44.61e064"
]
]
},
{
"id": "264bbb44.61e064",
"type": "influxdb out",
"z": "a85445c69706ecc9",
"influxdb": "72e5611c.85f388",
"name": "Solecast",
"measurement": "Solecast",
"precision": "ms",
"retentionPolicy": "",
"database": "",
"retentionPolicyV18Flux": "",
"org": "",
"bucket": "",
"x": 960,
"y": 1420,
"wires": []
},
{
"id": "686ddd2f.0bcc64",
"type": "change",
"z": "a85445c69706ecc9",
"name": "",
"rules": [
{
"t": "move",
"p": "payload.forecasts",
"pt": "msg",
"to": "payload",
"tot": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 310,
"y": 1400,
"wires": [
[
"de74762b.088578"
]
]
},
{
"id": "b9dae1017d51fc2e",
"type": "inject",
"z": "a85445c69706ecc9",
"name": "",
"props": [
{
"p": "payload"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "{\"forecasts\":[{\"pv_estimate\":0.3022,\"pv_estimate10\":0.2508,\"pv_estimate90\":0.3569,\"period_end\":\"2023-02-23T14:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2765,\"pv_estimate10\":0.2315,\"pv_estimate90\":0.3279,\"period_end\":\"2023-02-23T14:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2379,\"pv_estimate10\":0.1543,\"pv_estimate90\":0.3215,\"period_end\":\"2023-02-23T15:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.1821,\"pv_estimate10\":0.1041,\"pv_estimate90\":0.2797,\"period_end\":\"2023-02-23T15:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.1236,\"pv_estimate10\":0.0715,\"pv_estimate90\":0.2146,\"period_end\":\"2023-02-23T16:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0592,\"pv_estimate10\":0.0263,\"pv_estimate90\":0.1053,\"period_end\":\"2023-02-23T16:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0067,\"pv_estimate10\":0,\"pv_estimate90\":0.0133,\"period_end\":\"2023-02-23T17:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T17:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T18:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T18:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T19:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T19:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T20:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T20:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T21:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T21:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T22:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T22:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T23:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T23:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T00:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T00:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T01:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T01:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T02:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T02:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T03:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T03:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T04:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T04:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T05:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T05:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T06:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T06:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0349,\"pv_estimate10\":0.021,\"pv_estimate90\":0.0489,\"period_end\":\"2023-02-24T07:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.1537,\"pv_estimate10\":0.0978,\"pv_estimate90\":0.2305,\"period_end\":\"2023-02-24T07:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.3283,\"pv_estimate10\":0.2095,\"pv_estimate90\":0.5329,\"period_end\":\"2023-02-24T08:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.6121,\"pv_estimate10\":0.3381,\"pv_estimate90\":0.936,\"period_end\":\"2023-02-24T08:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.7924,\"pv_estimate10\":0.3948,\"pv_estimate90\":1.2099,\"period_end\":\"2023-02-24T09:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.9001,\"pv_estimate10\":0.419,\"pv_estimate90\":1.4348,\"period_end\":\"2023-02-24T09:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.0146,\"pv_estimate10\":0.4723,\"pv_estimate90\":1.6679,\"period_end\":\"2023-02-24T10:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.0863,\"pv_estimate10\":0.4844,\"pv_estimate90\":1.8208,\"period_end\":\"2023-02-24T10:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.111,\"pv_estimate10\":0.4796,\"pv_estimate90\":1.8839,\"period_end\":\"2023-02-24T11:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.1114,\"pv_estimate10\":0.4747,\"pv_estimate90\":1.8993,\"period_end\":\"2023-02-24T11:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.0774,\"pv_estimate10\":0.4487,\"pv_estimate90\":1.8523,\"period_end\":\"2023-02-24T12:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.0661,\"pv_estimate10\":0.4256,\"pv_estimate90\":1.8523,\"period_end\":\"2023-02-24T12:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.036,\"pv_estimate10\":0.379,\"pv_estimate90\":1.8617,\"period_end\":\"2023-02-24T13:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.0225,\"pv_estimate10\":0.3516,\"pv_estimate90\":1.8776,\"period_end\":\"2023-02-24T13:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.9908,\"pv_estimate10\":0.3307,\"pv_estimate90\":1.8175,\"period_end\":\"2023-02-24T14:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.9532,\"pv_estimate10\":0.3272,\"pv_estimate90\":1.6959,\"period_end\":\"2023-02-24T14:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.8517,\"pv_estimate10\":0.3166,\"pv_estimate90\":1.4531,\"period_end\":\"2023-02-24T15:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.5656,\"pv_estimate10\":0.2358,\"pv_estimate90\":1.0532,\"period_end\":\"2023-02-24T15:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2796,\"pv_estimate10\":0.1265,\"pv_estimate90\":0.5844,\"period_end\":\"2023-02-24T16:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.128,\"pv_estimate10\":0.0606,\"pv_estimate90\":0.2358,\"period_end\":\"2023-02-24T16:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0202,\"pv_estimate10\":0.0067,\"pv_estimate90\":0.0337,\"period_end\":\"2023-02-24T17:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T17:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T18:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T18:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T19:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T19:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T20:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T20:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T21:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T21:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T22:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T22:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T23:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T23:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T00:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T00:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T01:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T01:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T02:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T02:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T03:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T03:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T04:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T04:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T05:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T05:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T06:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T06:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0966,\"pv_estimate10\":0.0345,\"pv_estimate90\":0.10143,\"period_end\":\"2023-02-25T07:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.3159,\"pv_estimate10\":0.138,\"pv_estimate90\":0.331695,\"period_end\":\"2023-02-25T07:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.639,\"pv_estimate10\":0.276,\"pv_estimate90\":0.67095,\"period_end\":\"2023-02-25T08:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.3616,\"pv_estimate10\":0.4915,\"pv_estimate90\":1.42968,\"period_end\":\"2023-02-25T08:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":2.1272,\"pv_estimate10\":0.6843,\"pv_estimate90\":2.5047,\"period_end\":\"2023-02-25T09:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":2.9715,\"pv_estimate10\":0.7924,\"pv_estimate90\":3.7127,\"period_end\":\"2023-02-25T09:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":3.9186,\"pv_estimate10\":0.8818,\"pv_estimate90\":4.8948,\"period_end\":\"2023-02-25T10:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":4.7296,\"pv_estimate10\":0.9294,\"pv_estimate90\":5.8901,\"period_end\":\"2023-02-25T10:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":5.3336,\"pv_estimate10\":0.9532,\"pv_estimate90\":6.8516,\"period_end\":\"2023-02-25T11:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":5.8668,\"pv_estimate10\":0.9889,\"pv_estimate90\":7.551,\"period_end\":\"2023-02-25T11:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":6.4985,\"pv_estimate10\":1.0483,\"pv_estimate90\":8.0997,\"period_end\":\"2023-02-25T12:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":7.1252,\"pv_estimate10\":1.1076,\"pv_estimate90\":8.5223,\"period_end\":\"2023-02-25T12:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":7.6771,\"pv_estimate10\":1.1431,\"pv_estimate90\":8.7482,\"period_end\":\"2023-02-25T13:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":8.0338,\"pv_estimate10\":1.1787,\"pv_estimate90\":8.6158,\"period_end\":\"2023-02-25T13:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":8.2509,\"pv_estimate10\":1.2023,\"pv_estimate90\":8.5065,\"period_end\":\"2023-02-25T14:00:00.0000000Z\",\"period\":\"PT30M\"}]}",
"payloadType": "json",
"x": 90,
"y": 1400,
"wires": [
[
"686ddd2f.0bcc64"
]
]
},
{
"id": "e0e1d82318e724b2",
"type": "debug",
"z": "a85445c69706ecc9",
"name": "debug 1",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 960,
"y": 1380,
"wires": []
},
{
"id": "296a73edbd0f4497",
"type": "inject",
"z": "a85445c69706ecc9",
"name": "",
"props": [
{
"p": "payload"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "{\"forecasts\":[{\"pv_estimate\":0.0707,\"pv_estimate10\":0.0595,\"pv_estimate90\":0.082,\"period_end\":\"2023-02-23T14:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0627,\"pv_estimate10\":0.0434,\"pv_estimate90\":0.0804,\"period_end\":\"2023-02-23T15:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0504,\"pv_estimate10\":0.0244,\"pv_estimate90\":0.0878,\"period_end\":\"2023-02-23T15:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0325,\"pv_estimate10\":0.0163,\"pv_estimate90\":0.0585,\"period_end\":\"2023-02-23T16:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0148,\"pv_estimate10\":0.0066,\"pv_estimate90\":0.0247,\"period_end\":\"2023-02-23T16:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0017,\"pv_estimate10\":0,\"pv_estimate90\":0.0033,\"period_end\":\"2023-02-23T17:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T17:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T18:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T18:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T19:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T19:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T20:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T20:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T21:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T21:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T22:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T22:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T23:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-23T23:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T00:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T00:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T01:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T01:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T02:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T02:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T03:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T03:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T04:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T04:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T05:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T05:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T06:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T06:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0087,\"pv_estimate10\":0.0052,\"pv_estimate90\":0.0122,\"period_end\":\"2023-02-24T07:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0384,\"pv_estimate10\":0.0244,\"pv_estimate90\":0.0576,\"period_end\":\"2023-02-24T07:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0821,\"pv_estimate10\":0.0524,\"pv_estimate90\":0.1332,\"period_end\":\"2023-02-24T08:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.153,\"pv_estimate10\":0.0845,\"pv_estimate90\":0.234,\"period_end\":\"2023-02-24T08:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.1981,\"pv_estimate10\":0.0987,\"pv_estimate90\":0.3025,\"period_end\":\"2023-02-24T09:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.225,\"pv_estimate10\":0.1048,\"pv_estimate90\":0.3587,\"period_end\":\"2023-02-24T09:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2536,\"pv_estimate10\":0.1181,\"pv_estimate90\":0.417,\"period_end\":\"2023-02-24T10:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2716,\"pv_estimate10\":0.1211,\"pv_estimate90\":0.4552,\"period_end\":\"2023-02-24T10:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2777,\"pv_estimate10\":0.1199,\"pv_estimate90\":0.471,\"period_end\":\"2023-02-24T11:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2779,\"pv_estimate10\":0.1187,\"pv_estimate90\":0.4748,\"period_end\":\"2023-02-24T11:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2694,\"pv_estimate10\":0.1122,\"pv_estimate90\":0.4631,\"period_end\":\"2023-02-24T12:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2665,\"pv_estimate10\":0.1064,\"pv_estimate90\":0.4631,\"period_end\":\"2023-02-24T12:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.259,\"pv_estimate10\":0.0948,\"pv_estimate90\":0.4654,\"period_end\":\"2023-02-24T13:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2556,\"pv_estimate10\":0.0879,\"pv_estimate90\":0.4694,\"period_end\":\"2023-02-24T13:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2477,\"pv_estimate10\":0.0827,\"pv_estimate90\":0.4544,\"period_end\":\"2023-02-24T14:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2383,\"pv_estimate10\":0.0818,\"pv_estimate90\":0.424,\"period_end\":\"2023-02-24T14:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.2129,\"pv_estimate10\":0.0792,\"pv_estimate90\":0.3633,\"period_end\":\"2023-02-24T15:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.1414,\"pv_estimate10\":0.0589,\"pv_estimate90\":0.2633,\"period_end\":\"2023-02-24T15:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0699,\"pv_estimate10\":0.0316,\"pv_estimate90\":0.1461,\"period_end\":\"2023-02-24T16:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.032,\"pv_estimate10\":0.0152,\"pv_estimate90\":0.0589,\"period_end\":\"2023-02-24T16:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0051,\"pv_estimate10\":0.0017,\"pv_estimate90\":0.0084,\"period_end\":\"2023-02-24T17:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T17:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T18:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T18:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T19:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T19:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T20:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T20:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T21:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T21:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T22:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T22:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T23:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-24T23:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T00:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T00:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T01:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T01:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T02:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T02:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T03:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T03:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T04:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T04:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T05:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T05:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T06:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0,\"pv_estimate10\":0,\"pv_estimate90\":0,\"period_end\":\"2023-02-25T06:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.0431,\"pv_estimate10\":0.0086,\"pv_estimate90\":0.1611,\"period_end\":\"2023-02-25T07:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.3762,\"pv_estimate10\":0.0345,\"pv_estimate90\":0.8804,\"period_end\":\"2023-02-25T07:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.7016,\"pv_estimate10\":0.069,\"pv_estimate90\":1.3194,\"period_end\":\"2023-02-25T08:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":0.8729,\"pv_estimate10\":0.1229,\"pv_estimate90\":1.6029,\"period_end\":\"2023-02-25T08:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.0713,\"pv_estimate10\":0.1711,\"pv_estimate90\":1.8643,\"period_end\":\"2023-02-25T09:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.306,\"pv_estimate10\":0.1981,\"pv_estimate90\":2.0195,\"period_end\":\"2023-02-25T09:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.5154,\"pv_estimate10\":0.2204,\"pv_estimate90\":2.0933,\"period_end\":\"2023-02-25T10:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.6368,\"pv_estimate10\":0.2324,\"pv_estimate90\":2.1587,\"period_end\":\"2023-02-25T10:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.6067,\"pv_estimate10\":0.2383,\"pv_estimate90\":2.1394,\"period_end\":\"2023-02-25T11:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.597,\"pv_estimate10\":0.2472,\"pv_estimate90\":2.0865,\"period_end\":\"2023-02-25T11:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.6043,\"pv_estimate10\":0.2621,\"pv_estimate90\":1.9963,\"period_end\":\"2023-02-25T12:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.5784,\"pv_estimate10\":0.2769,\"pv_estimate90\":1.8676,\"period_end\":\"2023-02-25T12:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.4799,\"pv_estimate10\":0.2858,\"pv_estimate90\":1.6623,\"period_end\":\"2023-02-25T13:00:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.3376,\"pv_estimate10\":0.2947,\"pv_estimate90\":1.4191,\"period_end\":\"2023-02-25T13:30:00.0000000Z\",\"period\":\"PT30M\"},{\"pv_estimate\":1.1454,\"pv_estimate10\":0.3006,\"pv_estimate90\":1.1731,\"period_end\":\"2023-02-25T14:00:00.0000000Z\",\"period\":\"PT30M\"}]}",
"payloadType": "json",
"x": 90,
"y": 1440,
"wires": [
[
"ca0349c4b56f63f3"
]
]
},
{
"id": "4b6891796610eab0",
"type": "split",
"z": "a85445c69706ecc9",
"name": "",
"splt": "\\n",
"spltType": "str",
"arraySplt": 1,
"arraySpltType": "len",
"stream": false,
"addname": "",
"x": 530,
"y": 1440,
"wires": [
[
"f3a49d02c82d107a"
]
]
},
{
"id": "ca0349c4b56f63f3",
"type": "change",
"z": "a85445c69706ecc9",
"name": "",
"rules": [
{
"t": "move",
"p": "payload.forecasts",
"pt": "msg",
"to": "payload",
"tot": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 310,
"y": 1440,
"wires": [
[
"4b6891796610eab0"
]
]
},
{
"id": "f3a49d02c82d107a",
"type": "change",
"z": "a85445c69706ecc9",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "{\"PV2\": $.payload.pv_estimate * 1000,\t\"time\": $toMillis($.payload.period_end)}",
"tot": "jsonata"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 710,
"y": 1440,
"wires": [
[
"e0e1d82318e724b2",
"264bbb44.61e064"
]
]
},
{
"id": "72e5611c.85f388",
"type": "influxdb",
"hostname": "127.0.0.1",
"port": "8086",
"protocol": "http",
"database": "db",
"name": "InfluxDB",
"usetls": false,
"tls": "",
"influxdbVersion": "1.x",
"url": "http://localhost:8086",
"rejectUnauthorized": false
}
]
inject = my data from solecast for you.
Question:
Can I combine the 2 strands at the beginning?
So that both queries are not written to the database in parallel at the end.