API to pull hours out per month

[Jonathan Bohlmann]

We use another system to for schedule resourcing and would like to be able to pull monthly data out of Opsgenie.  We have looked at the Get Schedule and Get Schedule timeline apis but don't see an easy way to pull this data.  What we would like is something like this:

• October
  • Person 1 - 162 hours
  • Person 2 - 16 hours
  • Person 3 - 176 hours
• November
  • ...

This would allow us to then import into our resource allocation software (Netsuite - Openair).

Has anyone done something like this before?

[Elelta D]

Hey there Jonathan,

Thanks for posting here with an interesting problem, as you state the Get Schedule api does not give you the time a person was on call. 

The analytics with Opsgenie would have this information in the format you need it, it is possible to schedule an export of this data in a CSV format to be delivered to on of the Opsgenie users.

Here is an outline of how to do that.

https://community.atlassian.com/t5/Opsgenie-articles/Creating-a-Scheduled-Report-in-Opsgenie-Explanation-of/ba-p/2720680

would this wokr for you?