Possible to post time to JIRA using Excel?

Neil Hans 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
GabrielleJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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