Due the rising power prices in germany, i want to collect data from awattar for price comparison between awattar and my local power deliver company.
I have downloaded a python script for collecting the data and due my lack of programming skill its an try and error quest.
what i have done so far
Telegraf Conf
[[inputs.exec]]
commands = ["/usr/bin/python3 /etc/telegraf/scripts/awattar-api.py"]
timeout = "10s"
data_format = "prometheus"
python code / source GitHub - Gransi/awattar: Python client for aWATTar API
import sys
from datetime import datetime
date= datetime.utcnow() - datetime(1970, 1, 1)
seconds =(date.total_seconds())
milliseconds = round(seconds*1000)
from awattar import AwattarClient
#unix_timestamp = time.time()
def main(argv):
# print ('Connect to aWATTar')
client = AwattarClient('DE')
# print ('Get Market data from API')
data = client.request()
# for item in data:
# print(f'{item.start_datetime:%s} - {(item.marketprice / 1000):.4f}')
for item in data:
print(f'awattar-{item.start_datetime:%H} {milliseconds} {(item.marketprice / 1000):4f}')
if __name__ == "__main__":
main(sys.argv[1:])
Script Output:
awattar-16 1669308114149 0.322720
awattar-17 1669308114149 0.299590
awattar-18 1669308114149 0.285910
awattar-19 1669308114149 0.261560
awattar-20 1669308114149 0.229940
awattar-21 1669308114149 0.217100
awattar-22 1669308114149 0.173640
awattar-23 1669308114149 0.187290
awattar-00 1669308114149 0.175190
awattar-01 1669308114149 0.163070
awattar-02 1669308114149 0.151820
awattar-03 1669308114149 0.159150
awattar-04 1669308114149 0.181640
awattar-05 1669308114149 0.230600
awattar-06 1669308114149 0.297070
awattar-07 1669308114149 0.307650
awattar-08 1669308114149 0.289850
awattar-09 1669308114149 0.280450
awattar-10 1669308114149 0.263470
awattar-11 1669308114149 0.256030
awattar-12 1669308114149 0.272430
awattar-13 1669308114149 0.290170
awattar-14 1669308114149 0.318360
awattar-15 1669308114149 0.327360
Telegraf Test:
telegraf -config /etc/telegraf/telegraf.conf --debug -test > /tmp/test
2022-11-24T16:42:17Z I! Starting Telegraf 1.24.3
2022-11-24T16:42:17Z I! Available plugins: 222 inputs, 9 aggregators, 26 processors, 20 parsers, 57 outputs
2022-11-24T16:42:17Z I! Loaded inputs: exec http
2022-11-24T16:42:17Z I! Loaded aggregators:
2022-11-24T16:42:17Z I! Loaded processors:
2022-11-24T16:42:17Z W! Outputs are not used in testing mode!
2022-11-24T16:42:17Z I! Tags enabled: host=iot-data-collector
2022-11-24T16:42:17Z D! [agent] Initializing plugins
2022-11-24T16:42:17Z D! [agent] Starting service inputs
2022-11-24T16:42:18Z E! [inputs.exec] Error in plugin: reading text format failed: text format parsing error in line 1: spurious string after timestamp: " 0.322720"
2022-11-24T16:42:18Z D! [agent] Stopping service inputs
2022-11-24T16:42:18Z D! [agent] Input channel closed
2022-11-24T16:42:18Z D! [agent] Stopped Successfully
2022-11-24T16:42:18Z E! [telegraf] Error running agent: input plugins recorded 1 errors
Where is my failure? Thanks in advance for looking / helping with my problem