Ask Rallypublic

Knowledgebase

Search the Rally Knowledgebase to find solutions to your Rally product questions.

This is a public Hive  publicRSS

How To

    Import data from a web service query entirely in Excel
    How To posted 04/16/09 by Dave Smith, last edited 04/20/09 , tagged Data Management, Web Services API
    18130 Views
    Title:
    Import data from a web service query entirely in Excel
    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: