+8Hello,
I use the REST API to read via Python the protection report (XML).
Now the output of this report describes first the columns and in the next session the records. I use normally xml.etree.ElementTree, to read xml contend, but for this looks not useful, what is the easiest way to get this formatted output in dict or in a list. sorry i am new in python scripting.
regards Jürgen
Best answer by Juergen
In the meanwhile I solved my issue, if anyone has interesting here the code snip:
r = requests.get(<url|>, headers=<headers>)
result = json.loads(r.text)
#print(result["records"])
for line in result["records"]:
#print(line)
# remove SLA excluded records
#print(line[2], line[6], line[7], line[12], line[19])
lastbackup["number"] = num
lastbackup["Hostname"] = line[4]
lastbackup["Client"] = line[5]
lastbackup["Agent"] = line[6]
lastbackup["Instance"] = line[8]
lastbackup["Backupset"] = line[7]
lastbackup["Subclient"] = line[9]
lastbackup["JobId"] = line[15]
lastbackup["Status"] = line[14]
lastbackup["type"] = line[19]
num = num + 1
lastbackuplist.append(lastbackup)
#print(lastbackup)
lastbackup = {}
+8Hello,
Sorry this is a question for a Python forum, not for Commvault, is there a way to remove this topic?
Jürgen
+23Tagging in some of our peerrs who have asked python REST API questions and might have ideas!
+8In the meanwhile I solved my issue, if anyone has interesting here the code snip:
r = requests.get(<url|>, headers=<headers>)
result = json.loads(r.text)
#print(result["records"])
for line in result["records"]:
#print(line)
# remove SLA excluded records
#print(line[2], line[6], line[7], line[12], line[19])
lastbackup["number"] = num
lastbackup["Hostname"] = line[4]
lastbackup["Client"] = line[5]
lastbackup["Agent"] = line[6]
lastbackup["Instance"] = line[8]
lastbackup["Backupset"] = line[7]
lastbackup["Subclient"] = line[9]
lastbackup["JobId"] = line[15]
lastbackup["Status"] = line[14]
lastbackup["type"] = line[19]
num = num + 1
lastbackuplist.append(lastbackup)
#print(lastbackup)
lastbackup = {}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
