Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Possible to post time to JIRA using Excel?

Neil Hans
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 1, 2016

I am using Excel 2013 to track my time throughout the day using a timer.  At the end of the day or week, I would like to post my time from Excel to JIRA issues or subtasks.  We are on JIRA 7.2.0.  I have all the necessary data in Excel (JIRA issue key, etc.).  Is it possible to do this using Excel VBA and the JIRA REST API?  I looked at the API Reference and it seems the only resource that comes close is the api/2/issue resource with the Add or Update Worklog method.  But the parms available only add/update the Estimate field.  The fields we have to post time to seem to be custom fields (e.g. Date, Worked (hrs), Remaining Estimate (hrs), Description, Incident #, Market).

Anyone know of a way?

1 answer

1 vote
Deleted user
April 1, 2016

The JIRA REST Endpoint that you are looking for is addWorklog

https://docs.atlassian.com/jira/REST/latest/#api/2/issue-addWorklog

Suggest an answer

Log in or Sign up to answer