How to fetch a userstory's Actuals,Todo,Estimate fields from detail page of rally using RallyrestApi

Question

I am able to take userstory actual, estimate and Values from its Task.But when tasks are not there for an user story i have to take values from the userstories detail page from rally.

Ex:(i need to fetch as like below from rallyrestapi c# toolkit) https://rally1.rallydev.com/#/262768386856d/detail/defect/161729744764

Currently i tried as below , but its not working out

// Query for UserStories

    [![Request storyRequest = new Rally.RestApi.Request("hierarchicalrequirement");
                storyRequest.Workspace = workspaceRef;
                // storyRequest.Project = projectRef;
                storyRequest.ProjectScopeUp = projectScopingUp;
                storyRequest.ProjectScopeDown = projectScopingDown;
                storyRequest.Fetch = new List<string>()
                {
                    "Name",
                    "ObjectID",
                    "ScheduleState",
                    "State",
                    "FormattedID",
                    "CreationDate",
                    "ReleaseDate",
                    "PlanEstimate",
                    "Iteration",
                    "StartDate",
                    "EndDate",
                    "Release",
                    "ScheduleState",
                    "Tasks",                    
                };
                string userstoryId = "";
                long userstoryObjId ;
                storyRequest.Query = new Query("Iteration.Name", Query.Operator.Equals, myIterationName);
                QueryResult queryStoryResults = rallyRestApi.Query(storyRequest);
                ConvertToJSon(queryStoryResults);
                // Fetch Actual and Estimated Time request for task
                foreach (var userstory in queryStoryResults.Results)
                {                                  
                    Rally.RestApi.Request tasksRequest = new Rally.RestApi.Request(userstory\["Tasks"\]);
                    QueryResult queryTaskResult = rallyRestApi.Query(tasksRequest);                 
                }

Request details = new Rally.RestApi.Request("details");
                details.Workspace = workspaceRef;
                // storyRequest.Project = projectRef;
                details.ProjectScopeUp = projectScopingUp;
                details.ProjectScopeDown = projectScopingDown;
                details.Fetch = new List<string>()
                {
                    "Estimate",
                    "Actuals",
                    "ToDo"
                };
                storyRequest.Query = new Query("Defect.ObjectID", Query.Operator.Equals, "298510499032");
                QueryResult detailsdata = rallyRestApi.Query(details);][1]][1]

Unauthorized 401 error it gives. Please guide me how to fetch the above fields from rally details page.

score 1 · Accepted Answer · answered Aug 09 '19 at 07:15

I have the same example in Java but it may help you:

import com.google.gson.JsonObject;
import com.rallydev.rest.RallyRestApi;
import com.rallydev.rest.request.QueryRequest;
import com.rallydev.rest.response.QueryResponse;
import com.rallydev.rest.util.Fetch;
import com.rallydev.rest.util.QueryFilter;
import java.io.IOException;
import java.net.URI;

public class FindUserStoryByID {

  public static void main(String[] args) throws IOException {
    String host = "https://rally1.rallydev.com";
    String apiKey = "YOUR_API_KEY"; #or you may use login/password

    RallyRestApi rallyRestApi = null;

    try {
      rallyRestApi = new RallyRestApi(URI.create(host), apiKey);

      QueryRequest query = new QueryRequest("HierarchicalRequirement");
      query.setFetch(new Fetch("FormattedID", "Name", "TaskEstimateTotal", "TaskRemainingTotal",
          "TaskActualTotal"));
      query.setLimit(1000);
      query.setScopedDown(true);
      query.setQueryFilter(new QueryFilter("FormattedID", "=", "US11111"));

      QueryResponse response = rallyRestApi.query(query);

      if (response.wasSuccessful()) {
        for (int i = 0; i < response.getTotalResultCount(); i++) {
          JsonObject jsonObject = response.getResults().get(i).getAsJsonObject();
          System.out.println("FormattedID: " + jsonObject.get("FormattedID"));
          System.out.println("Name: " + jsonObject.get("Name"));
          System.out.println("TaskEstimateTotal: " + jsonObject.get("TaskEstimateTotal"));
          System.out.println("TaskRemainingTotal: " + jsonObject.get("TaskRemainingTotal"));
          System.out.println("TaskActualTotal: " + jsonObject.get("TaskActualTotal"));
        }
      }
    } finally {
      if (rallyRestApi != null) {
        rallyRestApi.close();
      }
    }
  }

}

Output will be like this:

FormattedID: "US11111"
Name: "My cool user story"
TaskEstimateTotal: 29.0
TaskRemainingTotal: 29.0
TaskActualTotal: 0.0

Thanks for your answer , If we have tasks for an userstory or defect we will get the above taskestimate, taskactual values , but for some of user stories or defects are not having tasks in that , so i am getting 0.0 as output. In such cases how can we get an userstory or defect's actual and estimate value. Because even if we dont have task also there is time limitations there , I want to calculate Rework and Estimation accuracy metrics based on that.Please help me out — Boopathirajan, Aug 12 '19 at 05:50

score 0 · Answer 2 · answered Jun 24 '20 at 12:25

0

check in https://rally1.rallydev.com/account and check api key whehter key access is full grant or not that is the issue

answered Jun 24 '20 at 12:25

test

1

How to fetch a userstory's Actuals,Todo,Estimate fields from detail page of rally using RallyrestApi

2 Answers2