telegraf json api query naar influxdb werkt niet.

[bucovaina89]

Ik probeer met telegraf de json uit te lezen van forecast.solar. Ik heb een professional API key en zou verwachten dan telegraf een measurement "forecastsolar" aanmaakt in mijn huidige influxdb database elektriciteit. Maar ik zie niets verschijnen in de database. Als ik de input apart test, dan krijg ik wel degelijk een resultaat. Mijn query lijkt juist te zijn. Het lijkt er mij dan op dat ofwel telegraf wel naar de database schrijft maar dat er door filters niets overblijft om te schrijven, ofwel dat telegraf helemaal niets naar de database schrijft.

Andere plugins zoals modbus en mqtt werken wel goed in deze setup.

Ziet iemand wat ik over het hoofd zie?

code:

root@stats:/etc/telegraf/telegraf.d# telegraf --config ./forecast.solar.conf --test --debug
2022-05-22T06:11:41Z I! Starting Telegraf 1.22.4
2022-05-22T06:11:41Z I! Loaded inputs: exec
2022-05-22T06:11:41Z I! Loaded aggregators: 
2022-05-22T06:11:41Z I! Loaded processors: 
2022-05-22T06:11:41Z W! Outputs are not used in testing mode!
2022-05-22T06:11:41Z I! Tags enabled: host=stats.smetnet.be
2022-05-22T06:11:41Z D! [agent] Initializing plugins
2022-05-22T06:11:41Z D! [agent] Starting service inputs
2022-05-22T06:11:42Z D! [agent] Stopping service inputs
2022-05-22T06:11:42Z D! [agent] Input channel closed
2022-05-22T06:11:42Z D! [agent] Stopped Successfully
> forecastsolar_forecast.solar,host=stats.smetnet.be message_code=0,message_info_latitude=51,message_info_longitude=4,message_ratelimit_limit=60,message_ratelimit_period=3600,message_ratelimit_remaining=53,result_2022-05-22\ 05:42:00=0,result_2022-05-22\ 05:45:00=5,result_2022-05-22\ 06:00:00=57,result_2022-05-22\ 06:15:00=131,result_2022-05-22\ 06:30:00=238,result_2022-05-22\ 06:45:00=380,result_2022-05-22\ 07:00:00=560,result_2022-05-22\ 07:15:00=784,result_2022-05-22\ 07:30:00=1057,result_2022-05-22\ 07:45:00=1382,result_2022-05-22\ 08:00:00=1764,result_2022-05-22\ 08:15:00=2204,result_2022-05-22\ 08:30:00=2703,result_2022-05-22\ 08:45:00=3263,result_2022-05-22\ 09:00:00=3884,result_2022-05-22\ 09:15:00=4564,result_2022-05-22\ 09:30:00=5300,result_2022-05-22\ 09:45:00=6092,result_2022-05-22\ 10:00:00=6938,result_2022-05-22\ 10:15:00=7836,result_2022-05-22\ 10:30:00=8781,result_2022-05-22\ 10:45:00=9771,result_2022-05-22\ 11:00:00=10788,result_2022-05-22\ 11:15:00=11827,result_2022-05-22\ 11:30:00=12905,result_2022-05-22\ 11:45:00=14014,result_2022-05-22\ 12:00:00=15154,result_2022-05-22\ 12:15:00=16325,result_2022-05-22\ 12:30:00=17520,result_2022-05-22\ 12:45:00=18735,result_2022-05-22\ 13:00:00=19968,result_2022-05-22\ 13:15:00=21213,result_2022-05-22\ 13:30:00=22461,result_2022-05-22\ 13:45:00=23713,result_2022-05-22\ 14:00:00=24968,result_2022-05-22\ 14:15:00=26207,result_2022-05-22\ 14:30:00=27421,result_2022-05-22\ 14:45:00=28608,result_2022-05-22\ 15:00:00=29764,result_2022-05-22\ 15:15:00=30890,result_2022-05-22\ 15:30:00=31974,result_2022-05-22\ 15:45:00=33014,result_2022-05-22\ 16:00:00=34014,result_2022-05-22\ 16:15:00=34962,result_2022-05-22\ 16:30:00=35854,result_2022-05-22\ 16:45:00=36696,result_2022-05-22\ 17:00:00=37478,result_2022-05-22\ 17:15:00=38207,result_2022-05-22\ 17:30:00=38899,result_2022-05-22\ 17:45:00=39546,result_2022-05-22\ 18:00:00=40142,result_2022-05-22\ 18:15:00=40696,result_2022-05-22\ 18:30:00=41207,result_2022-05-22\ 18:45:00=41666,result_2022-05-22\ 19:00:00=42077,result_2022-05-22\ 19:15:00=42442,result_2022-05-22\ 19:30:00=42761,result_2022-05-22\ 19:45:00=43034,result_2022-05-22\ 20:00:00=43261,result_2022-05-22\ 20:15:00=43450,result_2022-05-22\ 20:30:00=43605,result_2022-05-22\ 20:45:00=43730,result_2022-05-22\ 21:00:00=43827,result_2022-05-22\ 21:15:00=43897,result_2022-05-22\ 21:30:00=43945,result_2022-05-22\ 21:38:00=43955,result_2022-05-23\ 05:41:00=0,result_2022-05-23\ 05:45:00=3,result_2022-05-23\ 06:00:00=25,result_2022-05-23\ 06:15:00=57,result_2022-05-23\ 06:30:00=101,result_2022-05-23\ 06:45:00=159,result_2022-05-23\ 07:00:00=232,result_2022-05-23\ 07:15:00=311,result_2022-05-23\ 07:30:00=387,result_2022-05-23\ 07:45:00=453,result_2022-05-23\ 08:00:00=495,result_2022-05-23\ 08:15:00=530,result_2022-05-23\ 08:30:00=575,result_2022-05-23\ 08:45:00=626,result_2022-05-23\ 09:00:00=682,result_2022-05-23\ 09:15:00=752,result_2022-05-23\ 09:30:00=837,result_2022-05-23\ 09:45:00=928,result_2022-05-23\ 10:00:00=1026,result_2022-05-23\ 10:15:00=1142,result_2022-05-23\ 10:30:00=1274,result_2022-05-23\ 10:45:00=1414,result_2022-05-23\ 11:00:00=1560,result_2022-05-23\ 11:15:00=1713,result_2022-05-23\ 11:30:00=1857,result_2022-05-23\ 11:45:00=1978,result_2022-05-23\ 12:00:00=2087,result_2022-05-23\ 12:15:00=2185,result_2022-05-23\ 12:30:00=2270,result_2022-05-23\ 12:45:00=2357,result_2022-05-23\ 13:00:00=2429,result_2022-05-23\ 13:15:00=2486,result_2022-05-23\ 13:30:00=2543,result_2022-05-23\ 13:45:00=2601,result_2022-05-23\ 14:00:00=2642,result_2022-05-23\ 14:15:00=2668,result_2022-05-23\ 14:30:00=2709,result_2022-05-23\ 14:45:00=2765,result_2022-05-23\ 15:00:00=2822,result_2022-05-23\ 15:15:00=2877,result_2022-05-23\ 15:30:00=2932,result_2022-05-23\ 15:45:00=2986,result_2022-05-23\ 16:00:00=3038,result_2022-05-23\ 16:15:00=3090,result_2022-05-23\ 16:30:00=3152,result_2022-05-23\ 16:45:00=3225,result_2022-05-23\ 17:00:00=3295,result_2022-05-23\ 17:15:00=3362,result_2022-05-23\ 17:30:00=3425,result_2022-05-23\ 17:45:00=3474,result_2022-05-23\ 18:00:00=3510,result_2022-05-23\ 18:15:00=3543,result_2022-05-23\ 18:30:00=3574,result_2022-05-23\ 18:45:00=3602,result_2022-05-23\ 19:00:00=3628,result_2022-05-23\ 19:15:00=3651,result_2022-05-23\ 19:30:00=3671,result_2022-05-23\ 19:45:00=3689,result_2022-05-23\ 20:00:00=3704,result_2022-05-23\ 20:15:00=3717,result_2022-05-23\ 20:30:00=3727,result_2022-05-23\ 20:45:00=3736,result_2022-05-23\ 21:00:00=3743,result_2022-05-23\ 21:15:00=3747,result_2022-05-23\ 21:30:00=3751,result_2022-05-23\ 21:40:00=3752,result_2022-05-24\ 05:40:00=0,result_2022-05-24\ 05:45:00=3,result_2022-05-24\ 06:00:00=23,result_2022-05-24\ 06:15:00=51,result_2022-05-24\ 06:30:00=91,result_2022-05-24\ 06:45:00=145,result_2022-05-24\ 07:00:00=211,result_2022-05-24\ 07:15:00=292,result_2022-05-24\ 07:30:00=388,result_2022-05-24\ 07:45:00=500,result_2022-05-24\ 08:00:00=628,result_2022-05-24\ 08:15:00=776,result_2022-05-24\ 08:30:00=955,result_2022-05-24\ 08:45:00=1169,result_2022-05-24\ 09:00:00=1419,result_2022-05-24\ 09:15:00=1709,result_2022-05-24\ 09:30:00=2039,result_2022-05-24\ 09:45:00=2412,result_2022-05-24\ 10:00:00=2821,result_2022-05-24\ 10:15:00=3265,result_2022-05-24\ 10:30:00=3764,result_2022-05-24\ 10:45:00=4308,result_2022-05-24\ 11:00:00=4890,result_2022-05-24\ 11:15:00=5505,result_2022-05-24\ 11:30:00=6143,result_2022-05-24\ 11:45:00=6800,result_2022-05-24\ 12:00:00=7476,result_2022-05-24\ 12:15:00=8157,result_2022-05-24\ 12:30:00=8840,result_2022-05-24\ 12:45:00=9536,result_2022-05-24\ 13:00:00=10231,result_2022-05-24\ 13:15:00=10933,result_2022-05-24\ 13:30:00=11638,result_2022-05-24\ 13:45:00=12331,result_2022-05-24\ 14:00:00=13024,result_2022-05-24\ 14:15:00=13701,result_2022-05-24\ 14:30:00=14346,result_2022-05-24\ 14:45:00=14958,result_2022-05-24\ 15:00:00=15536,result_2022-05-24\ 15:15:00=16078,result_2022-05-24\ 15:30:00=16596,result_2022-05-24\ 15:45:00=17089,result_2022-05-24\ 16:00:00=17544,result_2022-05-24\ 16:15:00=17959,result_2022-05-24\ 16:30:00=18346,result_2022-05-24\ 16:45:00=18705,result_2022-05-24\ 17:00:00=19025,result_2022-05-24\ 17:15:00=19327,result_2022-05-24\ 17:30:00=19642,result_2022-05-24\ 17:45:00=19964,result_2022-05-24\ 18:00:00=20289,result_2022-05-24\ 18:15:00=20611,result_2022-05-24\ 18:30:00=20926,result_2022-05-24\ 18:45:00=21235,result_2022-05-24\ 19:00:00=21527,result_2022-05-24\ 19:15:00=21798,result_2022-05-24\ 19:30:00=22050,result_2022-05-24\ 19:45:00=22274,result_2022-05-24\ 20:00:00=22466,result_2022-05-24\ 20:15:00=22627,result_2022-05-24\ 20:30:00=22762,result_2022-05-24\ 20:45:00=22872,result_2022-05-24\ 21:00:00=22956,result_2022-05-24\ 21:15:00=23018,result_2022-05-24\ 21:30:00=23060,result_2022-05-24\ 21:41:00=23072,result_2022-05-25\ 05:39:00=0,result_2022-05-25\ 05:45:00=9,result_2022-05-25\ 06:00:00=61,result_2022-05-25\ 06:15:00=135,result_2022-05-25\ 06:30:00=240,result_2022-05-25\ 06:45:00=379,result_2022-05-25\ 07:00:00=555,result_2022-05-25\ 07:15:00=774,result_2022-05-25\ 07:30:00=1040,result_2022-05-25\ 07:45:00=1358,result_2022-05-25\ 08:00:00=1732,result_2022-05-25\ 08:15:00=2163,result_2022-05-25\ 08:30:00=2654,result_2022-05-25\ 08:45:00=3204,result_2022-05-25\ 09:00:00=3816,result_2022-05-25\ 09:15:00=4486,result_2022-05-25\ 09:30:00=5214,result_2022-05-25\ 09:45:00=5999,result_2022-05-25\ 10:00:00=6839,result_2022-05-25\ 10:15:00=7732,result_2022-05-25\ 10:30:00=8676,result_2022-05-25\ 10:45:00=9669,result_2022-05-25\ 11:00:00=10709,result_2022-05-25\ 11:15:00=11794,result_2022-05-25\ 11:30:00=12921,result_2022-05-25\ 11:45:00=14088,result_2022-05-25\ 12:00:00=15292,result_2022-05-25\ 12:15:00=16528,result_2022-05-25\ 12:30:00=17790,result_2022-05-25\ 12:45:00=19073,result_2022-05-25\ 13:00:00=20375,result_2022-05-25\ 13:15:00=21688,result_2022-05-25\ 13:30:00=23000,result_2022-05-25\ 13:45:00=24305,result_2022-05-25\ 14:00:00=25594,result_2022-05-25\ 14:15:00=26861,result_2022-05-25\ 14:30:00=28097,result_2022-05-25\ 14:45:00=29298,result_2022-05-25\ 15:00:00=30458,result_2022-05-25\ 15:15:00=31569,result_2022-05-25\ 15:30:00=32631,result_2022-05-25\ 15:45:00=33633,result_2022-05-25\ 16:00:00=34573,result_2022-05-25\ 16:15:00=35444,result_2022-05-25\ 16:30:00=36242,result_2022-05-25\ 16:45:00=36974,result_2022-05-25\ 17:00:00=37630,result_2022-05-25\ 17:15:00=38243,result_2022-05-25\ 17:30:00=38849,result_2022-05-25\ 17:45:00=39437,result_2022-05-25\ 18:00:00=39993,result_2022-05-25\ 18:15:00=40521,result_2022-05-25\ 18:30:00=41017,result_2022-05-25\ 18:45:00=41474,result_2022-05-25\ 19:00:00=41891,result_2022-05-25\ 19:15:00=42266,result_2022-05-25\ 19:30:00=42596,result_2022-05-25\ 19:45:00=42879,result_2022-05-25\ 20:00:00=43117,result_2022-05-25\ 20:15:00=43313,result_2022-05-25\ 20:30:00=43478,result_2022-05-25\ 20:45:00=43611,result_2022-05-25\ 21:00:00=43714,result_2022-05-25\ 21:15:00=43789,result_2022-05-25\ 21:30:00=43841,result_2022-05-25\ 21:42:00=43857 1653199902000000000

code:

root@stats:/etc/telegraf/telegraf.d# cat forecast.solar.conf 
[[inputs.exec]]
  ## Commands array
  interval = "60m"  
  commands = ["/usr/bin/curl https://api.forecast.solar/<MIJNAPIKEY>/estimate/watthours/51/4/11/50/7"]
  name_override = "forecastsolar"

  ## measurement name suffix (for separating different commands)
  name_suffix = "_forecast.solar"

  ## Data format to consume.
  ## Each data format has its own unique set of configuration options, read
  ## more about them here:
  ## https://github.com/influxdata/telegraf/blob/master/docs/DATA_FORMATS_INPUT.md
  data_format = "json"

  ## List of tag names to extract from top-level of JSON server response
  tag_keys = [
    "result"
  ]

code:

 cat forecast.solar.json #resultaat van een curl query.
{"result":{"2022-05-22 05:42:00":0,"2022-05-22 05:45:00":5,"2022-05-22 06:00:00":57,"2022-05-22 06:15:00":131,"2022-05-22 06:30:00":238,"2022-05-22 06:45:00":380,"2022-05-22 07:00:00":560,"2022-05-22 07:15:00":784,"2022-05-22 07:30:00":1056,"2022-05-22 07:45:00":1381,"2022-05-22 08:00:00":1740,"2022-05-22 08:15:00":2132,"2022-05-22 08:30:00":2583,"2022-05-22 08:45:00":3094,"2022-05-22 09:00:00":3665,"2022-05-22 09:15:00":4292,"2022-05-22 09:30:00":4976,"2022-05-22 09:45:00":5717,"2022-05-22 10:00:00":6514,"2022-05-22 10:15:00":7364,"2022-05-22 10:30:00":8268,"2022-05-22 10:45:00":9225,"2022-05-22 11:00:00":10232,"2022-05-22 11:15:00":11279,"2022-05-22 11:30:00":12364,"2022-05-22 11:45:00":13481,"2022-05-22 12:00:00":14628,"2022-05-22 12:15:00":15807,"2022-05-22 12:30:00":17008,"2022-05-22 12:45:00":18230,"2022-05-22 13:00:00":19469,"2022-05-22 13:15:00":20723,"2022-05-22 13:30:00":21985,"2022-05-22 13:45:00":23247,"2022-05-22 14:00:00":24506,"2022-05-22 14:15:00":25749,"2022-05-22 14:30:00":26967,"2022-05-22 14:45:00":28163,"2022-05-22 15:00:00":29327,"2022-05-22 15:15:00":30455,"2022-05-22 15:30:00":31547,"2022-05-22 15:45:00":32594,"2022-05-22 16:00:00":33595,"2022-05-22 16:15:00":34545,"2022-05-22 16:30:00":35438,"2022-05-22 16:45:00":36279,"2022-05-22 17:00:00":37062,"2022-05-22 17:15:00":37791,"2022-05-22 17:30:00":38477,"2022-05-22 17:45:00":39119,"2022-05-22 18:00:00":39710,"2022-05-22 18:15:00":40250,"2022-05-22 18:30:00":40745,"2022-05-22 18:45:00":41189,"2022-05-22 19:00:00":41583,"2022-05-22 19:15:00":41931,"2022-05-22 19:30:00":42233,"2022-05-22 19:45:00":42488,"2022-05-22 20:00:00":42701,"2022-05-22 20:15:00":42878,"2022-05-22 20:30:00":43025,"2022-05-22 20:45:00":43144,"2022-05-22 21:00:00":43235,"2022-05-22 21:15:00":43301,"2022-05-22 21:30:00":43346,"2022-05-22 21:38:00":43356,"2022-05-23 05:41:00":0,"2022-05-23 05:45:00":3,"2022-05-23 06:00:00":24,"2022-05-23 06:15:00":50,"2022-05-23 06:30:00":82,"2022-05-23 06:45:00":114,"2022-05-23 07:00:00":141,"2022-05-23 07:15:00":167,"2022-05-23 07:30:00":194,"2022-05-23 07:45:00":223,"2022-05-23 08:00:00":253,"2022-05-23 08:15:00":288,"2022-05-23 08:30:00":333,"2022-05-23 08:45:00":384,"2022-05-23 09:00:00":440,"2022-05-23 09:15:00":510,"2022-05-23 09:30:00":595,"2022-05-23 09:45:00":686,"2022-05-23 10:00:00":784,"2022-05-23 10:15:00":900,"2022-05-23 10:30:00":1032,"2022-05-23 10:45:00":1172,"2022-05-23 11:00:00":1318,"2022-05-23 11:15:00":1471,"2022-05-23 11:30:00":1615,"2022-05-23 11:45:00":1736,"2022-05-23 12:00:00":1846,"2022-05-23 12:15:00":1943,"2022-05-23 12:30:00":2028,"2022-05-23 12:45:00":2115,"2022-05-23 13:00:00":2187,"2022-05-23 13:15:00":2244,"2022-05-23 13:30:00":2301,"2022-05-23 13:45:00":2359,"2022-05-23 14:00:00":2400,"2022-05-23 14:15:00":2426,"2022-05-23 14:30:00":2467,"2022-05-23 14:45:00":2524,"2022-05-23 15:00:00":2580,"2022-05-23 15:15:00":2635,"2022-05-23 15:30:00":2690,"2022-05-23 15:45:00":2744,"2022-05-23 16:00:00":2797,"2022-05-23 16:15:00":2848,"2022-05-23 16:30:00":2910,"2022-05-23 16:45:00":2983,"2022-05-23 17:00:00":3053,"2022-05-23 17:15:00":3120,"2022-05-23 17:30:00":3183,"2022-05-23 17:45:00":3232,"2022-05-23 18:00:00":3268,"2022-05-23 18:15:00":3301,"2022-05-23 18:30:00":3332,"2022-05-23 18:45:00":3361,"2022-05-23 19:00:00":3386,"2022-05-23 19:15:00":3409,"2022-05-23 19:30:00":3429,"2022-05-23 19:45:00":3447,"2022-05-23 20:00:00":3462,"2022-05-23 20:15:00":3475,"2022-05-23 20:30:00":3485,"2022-05-23 20:45:00":3494,"2022-05-23 21:00:00":3501,"2022-05-23 21:15:00":3506,"2022-05-23 21:30:00":3509,"2022-05-23 21:40:00":3510,"2022-05-24 05:40:00":0,"2022-05-24 05:45:00":3,"2022-05-24 06:00:00":23,"2022-05-24 06:15:00":51,"2022-05-24 06:30:00":91,"2022-05-24 06:45:00":145,"2022-05-24 07:00:00":211,"2022-05-24 07:15:00":292,"2022-05-24 07:30:00":388,"2022-05-24 07:45:00":500,"2022-05-24 08:00:00":628,"2022-05-24 08:15:00":776,"2022-05-24 08:30:00":955,"2022-05-24 08:45:00":1169,"2022-05-24 09:00:00":1419,"2022-05-24 09:15:00":1709,"2022-05-24 09:30:00":2039,"2022-05-24 09:45:00":2412,"2022-05-24 10:00:00":2821,"2022-05-24 10:15:00":3265,"2022-05-24 10:30:00":3764,"2022-05-24 10:45:00":4308,"2022-05-24 11:00:00":4890,"2022-05-24 11:15:00":5505,"2022-05-24 11:30:00":6143,"2022-05-24 11:45:00":6800,"2022-05-24 12:00:00":7476,"2022-05-24 12:15:00":8157,"2022-05-24 12:30:00":8840,"2022-05-24 12:45:00":9536,"2022-05-24 13:00:00":10231,"2022-05-24 13:15:00":10933,"2022-05-24 13:30:00":11638,"2022-05-24 13:45:00":12331,"2022-05-24 14:00:00":13024,"2022-05-24 14:15:00":13701,"2022-05-24 14:30:00":14346,"2022-05-24 14:45:00":14958,"2022-05-24 15:00:00":15536,"2022-05-24 15:15:00":16078,"2022-05-24 15:30:00":16596,"2022-05-24 15:45:00":17089,"2022-05-24 16:00:00":17544,"2022-05-24 16:15:00":17959,"2022-05-24 16:30:00":18346,"2022-05-24 16:45:00":18705,"2022-05-24 17:00:00":19025,"2022-05-24 17:15:00":19327,"2022-05-24 17:30:00":19642,"2022-05-24 17:45:00":19964,"2022-05-24 18:00:00":20289,"2022-05-24 18:15:00":20611,"2022-05-24 18:30:00":20926,"2022-05-24 18:45:00":21235,"2022-05-24 19:00:00":21527,"2022-05-24 19:15:00":21798,"2022-05-24 19:30:00":22050,"2022-05-24 19:45:00":22274,"2022-05-24 20:00:00":22466,"2022-05-24 20:15:00":22627,"2022-05-24 20:30:00":22762,"2022-05-24 20:45:00":22872,"2022-05-24 21:00:00":22956,"2022-05-24 21:15:00":23018,"2022-05-24 21:30:00":23060,"2022-05-24 21:41:00":23072,"2022-05-25 05:39:00":0,"2022-05-25 05:45:00":9,"2022-05-25 06:00:00":61,"2022-05-25 06:15:00":135,"2022-05-25 06:30:00":240,"2022-05-25 06:45:00":379,"2022-05-25 07:00:00":555,"2022-05-25 07:15:00":774,"2022-05-25 07:30:00":1040,"2022-05-25 07:45:00":1358,"2022-05-25 08:00:00":1732,"2022-05-25 08:15:00":2163,"2022-05-25 08:30:00":2654,"2022-05-25 08:45:00":3204,"2022-05-25 09:00:00":3816,"2022-05-25 09:15:00":4486,"2022-05-25 09:30:00":5214,"2022-05-25 09:45:00":5999,"2022-05-25 10:00:00":6839,"2022-05-25 10:15:00":7732,"2022-05-25 10:30:00":8676,"2022-05-25 10:45:00":9669,"2022-05-25 11:00:00":10709,"2022-05-25 11:15:00":11794,"2022-05-25 11:30:00":12921,"2022-05-25 11:45:00":14088,"2022-05-25 12:00:00":15292,"2022-05-25 12:15:00":16528,"2022-05-25 12:30:00":17790,"2022-05-25 12:45:00":19073,"2022-05-25 13:00:00":20375,"2022-05-25 13:15:00":21688,"2022-05-25 13:30:00":23000,"2022-05-25 13:45:00":24305,"2022-05-25 14:00:00":25594,"2022-05-25 14:15:00":26861,"2022-05-25 14:30:00":28097,"2022-05-25 14:45:00":29298,"2022-05-25 15:00:00":30458,"2022-05-25 15:15:00":31569,"2022-05-25 15:30:00":32631,"2022-05-25 15:45:00":33633,"2022-05-25 16:00:00":34573,"2022-05-25 16:15:00":35444,"2022-05-25 16:30:00":36242,"2022-05-25 16:45:00":36974,"2022-05-25 17:00:00":37630,"2022-05-25 17:15:00":38243,"2022-05-25 17:30:00":38849,"2022-05-25 17:45:00":39437,"2022-05-25 18:00:00":39993,"2022-05-25 18:15:00":40521,"2022-05-25 18:30:00":41017,"2022-05-25 18:45:00":41474,"2022-05-25 19:00:00":41891,"2022-05-25 19:15:00":42266,"2022-05-25 19:30:00":42596,"2022-05-25 19:45:00":42879,"2022-05-25 20:00:00":43117,"2022-05-25 20:15:00":43313,"2022-05-25 20:30:00":43478,"2022-05-25 20:45:00":43611,"2022-05-25 21:00:00":43714,"2022-05-25 21:15:00":43789,"2022-05-25 21:30:00":43841,"2022-05-25 21:42:00":43857},"message":{"code":0,"type":"success","text":"","info":{"latitude":51,"longitude":4,"place":"9200 Schoonaarde, Dendermonde, Vlaanderen, BE","timezone":"Europe/Brussels"},"ratelimit":{"period":3600,"limit":60,"remaining":57}}}

[vanaalten]

Hmmm, ik gok dat dit een vervolg is op
Modbus.tcp & telegraf, probleem met decimalen?
?

[bucovaina89]

Gerelateerd, het is dezelfde setup maar heeft niets met de modbus plugin te maken (voor zover ik weet).

[bucovaina89]

Kleine update, het lijkt nu wel te werken, maar ik krijg data in onverwachte measurements, ik ga er even mee aan de slag en als het werkt, post ik de werkende config hier.

[bucovaina89]

OK, er is nog wat werk aan de winkel maar ik lijk wel ergens te geraken

code:

root@stats:/etc/telegraf/telegraf.d# cat forecast.http.test.conf 
# Copied from https://forum.iobroker.net/topic/21847/influxdb-mit-tages-pv-vorhersage-f%C3%BCllen


[[inputs.http]]
  name_override = "zzzforecastsolar"
  interval = "60m"  
  urls = [
    "https://api.forecast.solar/MIJNAPIKEY/estimate/watthours/51/4/11/50/7"
  ]

  headers = {"accept" = "text/csv", "X-Delimiter" = "|", "X-Separator" = ";"}

  data_format = "csv"
  csv_header_row_count = 0
  csv_column_names = ["time","value"]
  csv_column_types = []
  csv_delimiter = ";"
  csv_timestamp_column = "time"
  csv_timestamp_format = "2006-01-02 15:04:05"

code:

> select * from zzzforecastsolar
name: zzzforecastsolar
time                host             url                                                                         value
----                ----             ---                                                                         -----
1653284460000000000 myhost https://api.forecast.solar/MIJNAPIKEY/estimate/watthours/51/4/11/50/7 0
1653284700000000000 myhost https://api.forecast.solar/MIJNAPIKEY/estimate/watthours/51/4/11/50/7 4
1653285600000000000 myhost https://api.forecast.solar/MIJNAPIKEY/estimate/watthours/51/4/11/50/7 36
...
...
...
...

Trouwens als de gegevens in de graph hierboven kloppen, geef ik m'n job op en word ik zelf energieleverancier .