I am trying (unsuccessfully so far) to get data from the API into Excel. I want to know three things, Original Estimate, Time Remaining and Time Spent.
If I use postman I can see the element under fields:
"timetracking": {
"remainingEstimate": "0m",
"timeSpent": "6h",
"remainingEstimateSeconds": 0,
"timeSpentSeconds": 21600
}
However, when I make the call in Excel, the timetracking element does not exist. I have looped through the keys using:
For Each key In JSON("fields").Keys
Debug.Print key
Next
But it is not present in this set.
I have tried making the call to:
https://domain/rest/api/3/issue/KEY-123
https://domain/rest/agile/1.0/issue/KEY-123
Both work, but neither includes time tracking. I can happily get other elements json("fields")("status")("name") for example, or json("key") or json("fields")("summary"), but timetracking I cannot.
What am I missing? This is infuriating!
