REST API - Find the current primary on-call person for a given group?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2018 02:22 PM
Is it possible to get the current primary on-call person for a given group using the REST API? If so, which table(s) would I need to use?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2018 12:05 PM
I think you can get the info from cmn_rota_member (labeled as On-Call Member) table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2018 12:42 PM
cmn_rota_member doesn't appear to have any links to groups.
What I've done so far is query the sys_user_group table for the given group. Then search the cmn_rota table for an entry that references the group sys_id. That cmn_rota result has links to a parent schedule. Then, searching the cmn_schedule table for schedules that have a parent matching the previously found parent schedule returns the child schedules. Each child schedule has links to cmn_rota_member entries. From there the trail goes cold. I'm not sure how to tell which user is currently the primary. Or maybe there's an easier way?
Other tables that may play a part: cmn_rota_rotation, v_user_rotation ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2018 12:50 PM
Other option is to look at UI page called 'user_on_call_schedule' and look at processing script how it's building the calendar view.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2018 01:01 PM
Where would I find the script? In the browser developer tools window?
