Please help a newbie with API/JSON issue due to size

Configuration
1

I volunteer for a search & rescue charity and we use D4H ( www.d4h.com/) to manage our on call teams. I am developing a dashboard and already have things like tides, river flow and more calling API’s from various sites.

I would really like to call the api from D4H (which exists and I can get working) but I am struggling. I can get the command to work in postman but no matter what I try it doesn’t display the on call status. I think I am hitting some sort of limit? I am at a loss. I don’t fully understand what I need to do in all honesty and am hoping one of you kind people can help.
The JSON it extracts is available here: JSON-Example.txt

The API call is https://api.team-manager.eu.d4h.com/v3/team/xxx/duties/on-call-now (where xxx is our team number) and requires bearer auth.

The JSON that is returned is 159 lines and 4995 characters, but could be larger if we have more on call.

All I want to display is the Member name that is on call and the end date they are on call till.

2

Thanks for the data. That helps a lot, but when redacting data please replace it with the same type e.g. 111 instead of xxx otherwise the json becomes invalid.

Anyway, after fixing that I pasted the data in the left and side here: https://jsonpathfinder.com/

Then on the right I drilled down to find the path to member name. The data path is shown at the top of the right hand side. Replace x with value_json.

However there are two member names in your data:

value_template: "{{ value_json.results[0].member.name }}"

value_template: "{{ value_json.results[0].currentPeriod.endsAt }}"

value_template: "{{ value_json.results[1].member.name }}"

value_template: "{{ value_json.results[1].currentPeriod.endsAt }}"

Which member do you want?

Can there be more?

Do you want all of them?

In separate sensors?

Either way this is best done with the rest integration (rather than the rest sensor platform) as you can fill all sensors with one call to the resource.

3

Hey, thanks for the speedy reply. - Sorry about the redaction too!
The ideal solution would be to list all on call members in 1 sensor so that it would display as:

On Call Volunteers
Rob until 06/04/2025 09:00
John until 07/05/2025 17:00
Peter until 09:05:2025 00:00

Hope that makes sense.