How to import AgileHive Capacity to eazyBI?

Questions & Answers
, ,
1

We use AgileHive on Jira DC which adds the capacity to the sprint properties. I am trying to get the capacity value from the sprint’s properties. Can you help please?

https://jira.mycompany.com/rest/agile/1.0/sprint/5332/properties/agile-hive-sprint-capacity
{
  "key": "agile-hive-sprint-capacity",
  "value": 33
}



https://jira.mycompany.com/rest/agile/1.0/sprint/5332/properties


{
  "keys": [
    {
      "self": "https://jira.mycompany.com/rest/api/2/sprint/5332/properties/agile-hive-sprint-capacity",
      "key": "agile-hive-sprint-capacity"
    },
    {
      "self": "https://jira.mycompany.com/rest/api/2/sprint/5332/properties/AgileHiveSprintProperty",
      "key": "AgileHiveSprintProperty"
    },
    {
      "self": "https://jira.mycompany.com/rest/api/2/sprint/5332/properties/AgileHiveSprintStatistics",
      "key": "AgileHiveSprintStatistics"
    },
    {
      "self": "https://jira.mycompany.com/rest/api/2/sprint/5332/properties/is-agile-hive-sprint",
      "key": "is-agile-hive-sprint"
    }
  ]
}
2

Hi @Vijay_Chandra,

Welcome to the eazyBI community :partying_face: !

Does the app provide REST API endpoints itself, or is the Jira Software Sprint property API the only way to retrieve the value of the sprint capacity?

If it is the latter, one of the options would be to specify which boards and their sprints you want to consider, and make a call to retrieve the board sprints. Then, for each sprint, make an additional request to retrieve the property value. You can review one example, similar to this use case, on our documentation page - https://docs.eazybi.com/eazybi/data-import/data-adjustments-using-javascript#DataadjustmentsusingJavaScript-GetadditionaldatafromRESTAPIs.

Then in the data mapping you could import the capacity for each Sprint dimension “Sprint” level member as a property and/or measure with the additional data mapping - https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube.

Best,
Roberts // support@eazybi.com