I am looking for help on how to parse some json data from the following endpoint.
https://www.tva.com/RestApi/predicted-data/DUGT1.json
I am unable to configure anything to get the reponse parsed for display in a mardown card on teh dashboard. Anyone have any idea how I can get all this parsed for display?
#configuration.yaml
rest:
- resource: https://www.tva.com/RestApi/predicted-data/DUGT1.json
scan_interval: 10800 # every 3 hours
headers:
User-Agent: "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36"
Content-Type: application/json
sensor:
- name: Average Inflow Today
value_template: "{{ value_json[0].AverageInflow/60 }}"
unit_of_measurement: "ft³/min"
device_class: volume_flow_rate
state_class: measurement
- name: Average Outflow Today
value_template: "{{ value_json[0].AverageOutflow/60 }}"
unit_of_measurement: "ft³/min"
device_class: volume_flow_rate
state_class: measurement
- name: Midnight Elevation
value_template: "{{ value_json[0].MidnightElevation }}"
unit_of_measurement: "ft"
state_class: measurement
- name: Average Inflow Tomorrow
value_template: "{{ value_json[1].AverageInflow/60 }}"
unit_of_measurement: "ft³/min"
device_class: volume_flow_rate
state_class: measurement
- name: Average Outflow Tomorrow
value_template: "{{ value_json[1].AverageOutflow/60 }}"
unit_of_measurement: "ft³/min"
device_class: volume_flow_rate
state_class: measurement
- name: Average Inflow Day after Tomorrow
value_template: "{{ value_json[2].AverageInflow/60 }}"
unit_of_measurement: etc...