community 
API Call for Historical Reservation Information
Hey all,
Does anyone know if there is a way to retrieve historical reservation information via the API? Like within the GUI when you go to reservations and check option 'Completed' and can see all that had executed in the past.
Was attempting to go about it via FindResources but that doesn't appear to work:
>>> find_resource = quali_api.FindResourcesInTimeRange(resourceFullName=resource_name, includeSubResources=False, fromTime='01/01/2017 00:00', untilTime='04/20/2017 11:00')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.7/dist-packages/cloudshell/api/cloudshell_api.py", line 2626, in FindResourcesInTimeRange
return self.generateAPIRequest(OrderedDict([('method_name', 'FindResourcesInTimeRange'), ('resourceFamily', resourceFamily), ('resourceModel', resourceModel), ('fromTime', fromTime), ('untilTime', untilTime), ('attributeValues', CommonAPIRequest.toContainer(attributeValues)), ('showAllDomains', showAllDomains), ('resourceFullName', resourceFullName), ('exactName', exactName), ('includeSubResources', includeSubResources), ('resourceAddress', resourceAddress), ('resourceUniqueIdentifier', resourceUniqueIdentifier), ('maxResults', maxResults)]))
File "/usr/local/lib/python2.7/dist-packages/cloudshell/api/common_cloudshell_api.py", line 430, in generateAPIRequest
raise CloudShellAPIError(api_result.error_code, api_result.error, response_str)
cloudshell.api.common_cloudshell_api.CloudShellAPIError: CloudShell API error 101: The requested from/until date is historic
Best Answer
You can do something like this:
res = quali_api.GetScheduledReservations('01/01/2016 00:00','01/01/2017 00:00')
print vars(res.Reservations[0]) # list of vars for a reservations
for rv in res.Reservations:
print "Reservation name: {0}, Id: {1}, ActualEndTime: {2}".format(rv.Name, rv.Id, rv.ActualEndTime)
You can also use the Sandbox API, it's a RESTful API, and when you ask for the sanboxes there, you can also ask to get historic ones.
From that is there a way to pull the resources that were apart of those reservations? Or maybe utilizing a piece of information extracted from there?
You can use the reservation id and GetReservationDetails to get the resources that were there and other data.
