Exporting Rally Multi-Dropdown JSON Schema to CSV
search cancel

Exporting Rally Multi-Dropdown JSON Schema to CSV

book

Article ID: 268505

calendar_today

Updated On:

Products

Rally SaaS

Issue/Introduction

How do you export Rally multi-value dropdown to CSV?

Environment

Release : SAAS

Resolution

Navigate to the setup for the workspace you want to export the values for

Click Fields on the left side

Choose the work item type from the dropdown at the top of the field list

Click the gear icon next to the field that you want to export values for and then click Edit

A new window appears

In the address bar of this window, get the numeric value for "oid" and save this number to a notepad file.  Do not use cpoid or typeDefOid.

 

Use that number to update the following address, replacing the <oid value> with the number above

https://rally1.rallydev.com/slm/webservice/v2.0/attributedefinition/<oid value>/AllowedValues?pagesize=2000

Once you have the completed URL, paste this into your address bar and press enter

The resulting page should look like the following:

At this point you will need to save this page, but the method may vary from browser to browser and may be different between Windows, Mac and Linux.  Many times you can right click on an area without any text and choose "Save As"

Once you have the text saved, open up Excel

Click Data in the menu

Click Get Data (Power Query) in the ribbon

Click the JSON button

Click the Browse button and then navigate to the location where you saved the file

Open the file

Click Next

Click "Record" next to QueryResult

Click [List] next to Results

Click "To table" in the toolbar

Click OK

Click the Column selector tool and select the desired fields to export:

Click Close & load