I am trying to recreate the weekly SLA report displayed under application -> reports -> SLA -> weekly. This is also the same report sent in the weekly email. I am using the API explorer and the suggestions on this page SLA Example to get the correct curl commands to run. In doing so, I am unable to get the same values as displayed on the website or in the email. They are close, but not close enough. I think it might be the to and from values I am choosing. The weekly SLA reports end on Sundays and we are located in Portland, OR. What would the appropriate to and from values for the week ending 3/23/14?
The closest I have come to getting the correct values uses:
I thought subtracting 7 hours from each would work because we are in UTC-7 currently, but that made the value even further apart from the expected. Any help would be appreciated.
My second question deals with uptime. Uptime is currently also reported in our weekly SLA, but I am unable to find any documentation on how to get it from the API? If it is even possible.