Need to get creation dates of all Rally WorkSpaces

Products

• CA Agile Central On Premise (Rally)

Issue/Introduction

I have been tasked by my management to get Creation Dates of all our WorkSpaces using the Rally APIs. I found one section that mentions CreationDate and many WorkSpace options but need help creating the request to get the data I need from Rally.

Environment

Release : 2018.1

Component : AGILE CENTRAL ON PREMISES

Resolution

The following API URL should return a list of Rally WorkSpace and their CreationDate: URL https://<rally address>/slm/webservice/v2.0/Subscription/<MY sub ObjID>/Workspaces?fetch=ObjectID,Name,CreationDate
(Don't forget for your specific environment make changes to <rally address> and <MY sub ObjID> in the URL above.)

Note: The direct CSV export does not work, so this will output raw JSON, so it will be necessary to convert it using a tool like https://json-csv.com/.