From my developer:
The original issue that prompted the question looks like it has resolved itself. Trying to figure out how and why….but would still like a double check on our understanding. First some context:
Perhaps we’re not using the right terms (please coach us) --- when we say EPIC API --- we’re referring to the endpoint below:
https://rally1.rallydev.com/slm/webservice/v2.0/portfolioitem/epic?workspace=https://rally1.rallydev.com/slm/webservice/v2.0/workspace/***********&query=&fetch=true&start=1&pagesize=1
When we say PortfolioItem API – we’re referring to the endpoint below:
https://rally1.rallydev.com/slm/webservice/v2.0/portfolioitem?workspace=https://rally1.rallydev.com/slm/webservice/v2.0/workspace/***********&query=&fetch=true&start=1&pagesize=1
Our process involves loading the data from these 2 endpoints into 2 tables in our database. The available columns for each table were determined by having Visual Studio interpret and create the various classes in the underlying JSON data at each endpoint. We use those classes in a script task in SSIS to extract the data and route to appropriate columns for each table.
What prompted the question, was that we were getting different values for percent done by story count and percent done by plan estimate for a given Epic’s formatted ID when querying the table with data from the EPIC endpoint and comparing that data to the table with PortfolioItem endpoint data.
Our assumption was that this data should be the same – and it looks like it is now for us. The discrepancy was most likely self-inflicted.
So, with that context – we wanted to check our understanding of the functional relationship between Epic and Portfolio Item endpoints. (This would also apply to Features and MBIs since each of those also have their own endpoints and are included in the PortfolioItem endpoint’s data.)