have tried several hours to find the right jmespath without success. attached I will post the error code from the kog file. I need to extract the value “curr_w”. Any help is welcome. thx
2024-11-29 12:18:57,279 - ERROR - mycodo.inputs.mqtt_paho_json_0dc1eefc - Error in JSON ‘{‘StatusSNS’: {‘Time’: ‘2024-11-29T12:18:56’, ‘SML’: {‘server_id’: ‘0a01484c590200155d58’, ‘export_total_kwh’: 152.3689, ‘total_kwh’: 2266.6131, ‘curr_w’: -22, ‘volt_p1’: 233.4, ‘volt_p2’: 237.4, ‘volt_p3’: 235.5, ‘amp_p1’: 0.5, ‘amp_p2’: 0.8, ‘amp_p3’: 0.2, ‘phase_angle_l2_l1’: 119.0, ‘phase_angle_l3_l1’: 238.0, ‘phase_angle_p1’: 294.0, ‘phase_angle_p2’: 115.0, ‘phase_angle_p3’: 291.0, ‘freq’: 50}}}’ finding ‘StatusSNS.*.“curr_w”’: float() argument must be a string or a number, not ‘list’
Try StatusSNS.SML.curr_w
Thx for the prompt reply. This solved my problem