json array - how to address individual fields? | Home Assistant | Page 1

deft current Feb 25, 2022, 10:38 AM

#

zinc terrace Feb 25, 2022, 10:39 AM

#

Seems we have the same questions huh ;)

jade swift Feb 25, 2022, 10:39 AM

#

Not really 🙂 but you need to create wat tommmii has 🙂

deft current Feb 25, 2022, 10:40 AM

#

rest:
  - resource: http://resource.ip:port/api/GetPersons?count=2
    headers:
      the-key: thvre5642vhre6254vre
    scan_interval: 60
    sensor:
      - name: "rest_get_last2_persons"

This is my sensor

zinc terrace Feb 25, 2022, 10:40 AM

#

Thx for the help. I'm just toying with an integration thats giving me a sensor with a lot of attributes. Each value is mm rain. Incrementally for each 5 min.

deft current Feb 25, 2022, 10:40 AM

#

this populates with :

[
  {
    "number": "0113",
    "name": "John",
    "time": "2022-02-25T10:31:31.023"
  },
  {
    "number": "0114",
    "name": "Jane",
    "time": "2022-02-25T10:31:26.103"
  }
]```

#

Now I would need to read out the person's names

zinc terrace Feb 25, 2022, 10:40 AM

#

Extracting max value and calculate that time is going to work I think.

deft current Feb 25, 2022, 10:41 AM

#

pesudo code : person[0].name would result in John

jade swift Feb 25, 2022, 10:41 AM

#

correct

deft current Feb 25, 2022, 10:41 AM

#

how ?

zinc terrace Feb 25, 2022, 10:42 AM

#

Imma head out for now. Good luck figuring it out Tommmii

jade swift Feb 25, 2022, 10:42 AM

#

Sorry, this thread with 2 different topics going at once made it even more complicated

#

ah, nice

deft current Feb 25, 2022, 10:42 AM

#

sensor.rest_get_last2_persons.name ?

jade swift Feb 25, 2022, 10:43 AM

#

You are not beign clear

jade swift Feb 25, 2022, 10:43 AM

#

deft current this populates with : ```json [ { "number": "0113", "name": "John", ...

where do you see this data? Is it the state of the sensor, an attribute?

zinc terrace Feb 25, 2022, 10:43 AM

#

jade swift Sorry, this thread with 2 different topics going at once made it even more compl...

Yes that's why I'm not gonna bother atm

deft current Feb 25, 2022, 10:44 AM

#

in devtools

{{
states.sensor.rest_get_last2_persons.state
}}

that shows the above json

#

Should I first of all change the sensor config ?

jade swift Feb 25, 2022, 10:46 AM

#

{% set data = states('sensor.rest_get_last2_persons`) | from_json %}
{{ data | map(attribute='name') | list }}

#

that should give you a list of names

#

[ 'Jane', 'John' ]

#

Well, other way around though

deft current Feb 25, 2022, 10:47 AM

#

ok, but what if I just want to access the 2nd name? or the 2nd time ?

jade swift Feb 25, 2022, 10:48 AM

#

{{ data[1].name }} for the second name (there are 2 items in this list, and counting starts at 0)

deft current Feb 25, 2022, 10:54 AM

#

hmm...so map() is effectively creating (mapping) attributes ?
Would it not be more elegant to do the mapping as part of the sensor config ?

jade swift Feb 25, 2022, 11:02 AM

#

Well, normally map() maps values to something. so {{ ["1", "5", "a"] | map("int", default=0) | list }} will result in [ 1, 5, 0]

#

it has multiple purposes 🙂

deft current Feb 25, 2022, 11:03 AM

#

ok, lots of stuff to experiment with... thanks !

deft current Feb 25, 2022, 11:23 AM

#

I'll drop this here, it looks to be the most elegant solution to my goal :
https://www.home-assistant.io/integrations/sensor.rest/#fetch-multiple-json-attributes-and-present-them-as-values

#

Specifically the 4th example, the one with multiple bedrooms each with multiple datapoints.

jade swift Feb 25, 2022, 11:41 AM

#

You never explained your goal.. That's what made it so difficult

#json array - how to address individual fields?