Hello. We are attempting to link our phone system to our SN instance. The goal is that when a number is dialed the phone system makes a web call to SN to look at the on-call schedule to pull the cell number of the person that is on call for the group that corresponds to the number dialed. The mapping of number to group is done on phone system side. The issue is I am not able to figure out which table(s) we need to pull the information from. The v_rotation table has the information but that is only populated when you run the built in Schedule Report and the v_rotation table retains that information until the report is run again. I have also dug through every schedule table I could find.
If anyone know where I can pull who is on call for a group at any point in time please let me know. Thank you!
