It will execut the Jira JQL command in column B1 and return the results starting in the table at A8 which is referred to by a defined name in excel as "StartRow".See the example of the excel workbook in the image above in the background section.On the macroValues worksheet there is a table that is used to define how to extract the returned data from Jira that is in JSON format so that it can be inserted into the excel worksheet.The the excel workbook sheet 'Tickets' row 5 which is hidden contains the key for each column. In Jira The Issue type together with the project is referred to as an Issue context and it is used to find the Jira schemes that control which fields are available for an issue, what the default values are, and which fields are mandatory.When you have the project and the issue type, you can retrieve the information for the issue fields by calling the If you are building an integration that works across Jira versions (versions later and earlier than 8.4), you may want to check if the new endpoints are already available for your Jira instance. OAuth for REST APIs. The basic flow for creating a word templates is:The following code does the parsing. 'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 2/16/2016 10:02:49 AM : from manifest:3414394 gist https://gist.github.com/brucemcpherson/3414346/raw' Acknowledgement for the microtimer procedures used here toThe only real unique aspect about this method is the s = GetUrl line. 1. A request to a paged API will result in a Some resources support ordering by a specific field.

A future version of the code will likely support this so that additional authorization methods can be supported.The more interesting method here is once the Json is returned from Jira the code loops through the rows in the returned Json and the columns in the worksheet. This dynamically creates a macro called getValue and uses this table to create a sub routine that knows how to reference the desired data from the data returned by Jira.Before moving on to the points of interest and talking through some of the code. I'm using the Tempo REST API to extract data about work logs, projects and accounts, to feed into some custom reports. The following authentication methods are supported for the Jira REST APIs: 1. data, PUT updates, and so on) via the REST API.In the Jira REST API, custom fields are uniquely identified by the field ID, as the display names are not unique planned work is greater than my team capacity. So if you open the UI editor open an excel file and udpate the xml then save it, but keep the excel file open in the UI editor, any chances you make to your macros in excel are overwritten if you come back to the UI editor and make changes and save again. To create an issue, Instead of trying to create custom icon's for my custom menu I picked from the stock set of office icon's. information (for example, you need to make many requests) or too much information (for example, performance impact on Jira).To find out which fields are expandable, look at the You can use the dot notation to specify expansion of entities within another entity. This seemed to be more user friendly and user informative. In the points of interest section I'll document the learnings and key code fragments.The excel work book that comes with this article contains the custom menu additions and the macros both those that I developed on others. I utilized the reference at the following link to browse through the available icons.

This guide contains different examples of how to use the Jira REST API, including how to query issues, create an issue, of results to a specified number of issues.Two additional URL parameters are provided in the request: This example request searches for issues assigned to a user with the username "charlie" and orders the returned
It's pretty cool that you can create custom menus for each excel file. The menu only appears when you have the associated excel file open and it has the focus.To use the Custom UI Editor for Microsoft Office you simple open the excel file in the tool, note: the excel file cannot be open in excel, create the XML and save the file. The image below show where the developer tab in word has been enabled. Tempo is time, planning, and scheduling software designed to enhance the efficiency of JIRA, Atlassian's project tracking product. For example, you could have two fields named "Escalation date", one with an ID of "12221" like Currently there are two API names available, which will be discussed later on this page:As an example, if you wanted to retrieve the JSON representation of issue  But it serves as a good reference and tip on how you can extract the Json.
The Jira Server platform provides the REST API for common features, like issues and workflows.The Jira Software and Jira Service Desk applications have REST APIs for their application-specific features,