how to get worklog for stories included subtasks

[Sushil Yadav]

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!