Issue search and excel export for JIRA, outside JIRA

%3CLINGO-SUB%20id%3D%22lingo-sub-280396%22%20slang%3D%22en-US%22%3EIssue%20search%20and%20excel%20export%20for%20JIRA%2C%20outside%20JIRA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-280396%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20to%20download%20a%20list%20of%20issues%20from%20our%20JIRA%20issue%20list%2C%20to%20process%20further%20in%20VBA%20and%20generate%20a%20report%20from%20the%20issue%20list.%20I%20want%20this%20process%20to%20be%20automated%20from%20start%20to%20end%20so%20e.g.%20I%20run%20a%20java%20or%20VB%20or%20C%23%20program%2C%20which%20does%20a%20search%20and%20download%20from%20JIRA%20(somehow)%20then%20runs%20a%20VBA%20program%20to%20extract%20and%20format%20the%20issues%20into%20a%20report.%20Is%20there%20anyway%20this%20can%20be%20done%3F%20I'm%20using%20JIRA%203.13.%3C%2FP%3E%3CP%3EI've%20looked%20at%20the%3CA%20href%3D%22https%3A%2F%2Fmindmajix.com%2Fjira-interview-questions-answers%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20JIRA%3C%2FA%3E%20and%20Atlassian%20plugins%20but%20don't%20quite%20understand%20how%20they%20work.%20Aren't%20plugins%20meant%20to%20be%20deployed%20into%20the%20JIRA%20instance.%20I%20don't%20see%20how%20plugins%20can%20achieve%20what%20i%20want%20to%20do%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-280396%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENetworking%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I'm looking to download a list of issues from our JIRA issue list, to process further in VBA and generate a report from the issue list. I want this process to be automated from start to end so e.g. I run a java or VB or C# program, which does a search and download from JIRA (somehow) then runs a VBA program to extract and format the issues into a report. Is there anyway this can be done? I'm using JIRA 3.13.

I've looked at the JIRA and Atlassian plugins but don't quite understand how they work. Aren't plugins meant to be deployed into the JIRA instance. I don't see how plugins can achieve what i want to do

1 Reply
Highlighted

@Soujanya-naganuri tekslate 

 

Version 3 of the Jira Cloud platform REST API, which is the latest version.

The URIs for resources have the following structure:

https://<site-url>/rest/api/3/<resource-name>

For example, https://your-domain.atlassian.net/rest/api/3/issue/DEMO-1

Note that version 3 of the Jira Cloud platform REST API is in beta.

However, they are under development and may change.

  • body in comments, including where comments are used in issue, issue link, and transition resources.
  • comment in worklogs.
  • description and environment fields in issues.
  • textarea type custom fields (multi-line text fields) in issues. Single line custom fields (textfield) accept a string and don't handle Atlassian Document Format content.