Knowledgebase
Search the Rally Knowledgebase to find solutions to your Rally product questions.
How To
Export data from a web service query in Excel using Excel...
18689 Views, 2 Comments
Title:
Export data from a web service query in Excel using Excel Data sources
Abstract:
How to use Excel (2007) web data sources to import web service query results
How To:
Open up a new workbook in Excel.
Click on your data menu or 'tab' in the ribbon.
Click the From Web Button.
Put in the url for your query as the URL for the location of the data (see screenshot) and click go - this will prompt you for your Rally Credentials and load the data in the window.
Click the import button and go through the last validations and you will get something like the screenshot for the results.
Screenshot:
Comments
I'm trying to do something like this but I have 2 problems:
1. Excel URL is limited to < 256 characters - complicated REST URIs will exceed this
2. pagesize < 200 (even though API says 100) - how do I get 1 table with more results?
Hi Michael - yup - I had meant this to be an example for the simple scenario as we are limited by Excel.
1. Are you using a complex query that makes the URL long? The best suggestion I have had for a workaround on this is to get the data into excel and then filter down in excel to the data you want doing the 'query' that way.
2. Pagesize is tricky - the best I can suggest is to stitch together multiple worksheets using the start=201&pagesize=200
Beyond that, if you are looking at getting a large amount of data out, I would want to look at writing something in Javascript against our batchtoolkit to generate the output or look at using our Ruby toolkit to get the data into csv. Both have more information here: http://agilecommons.org/hives/8c62015be6/summary