how to get worklog for stories included subtasks

Sushil Yadav_hjloyi

I need to get story wise hours including subtasks in Jira worklog plugin

David Nickell

• This REST API call will do it.   You can paste this in a browser to see what the results will look like.  yoursite/rest/api/3/issue/issueKey/worklog
• Document is here:  https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-worklogs/#api-rest-api-3-issue-issueidorkey-worklog-get
• Here is the power query code. if you pass in the issue key and "1" as the InPass, you'll be good for up to 5,000 results before you need to worry about pagination

let IssueWL = (inKey as text, inPass as number) => 
let LocalBaseURL=P_BaseURL,
LocalRelPath="/rest/api/3/issue/" & inKey & "/worklog?maxResults=5000&startAt=0",
Source = Json.Document(Web.Contents(LocalBaseURL,[RelativePath=LocalRelPath,Headers=[Authorization=P_BaseAuth]])),
TotalIssues = Source[total],
#"Converted to Table" = Table.FromRecords({Source})
in #"Converted to Table"
in IssueWL

Good luck!