Skip to content

πŸ”ŽπŸ“‡πŸ“ˆ Atlassian to CSV Query Tool allows quick review of Atlassian(JIRA) Column Data in one simple Node.JS script running(npm node [appName].js)

Notifications You must be signed in to change notification settings

JSWesterfield/atlassian-query-tool

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

11 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Atlassian Query Tool

πŸ”ŽπŸ“‡πŸ“ˆAtlassian Query Tool is a NodeJS application for fetching data from JIRA to excel

Installation

Use the package manager npm to get started with a Slack Slash Command.

npm install atlassianQueryTool

Usage

We set up our application by adding the below code:

var searchString="project='okrs' and ((createdDate<='2025/11/1' and createdDate>='2025/3/1') or (updatedDate <='2025/11/1' and updatedDate >='2025/3/1')) "
jira.searchJira(searchString).then(function(issue) {
    var fields = ['ISSUE_Number', 'TITLE', 'STATUS'];
    var myISSUE=[];
    for(let i=0; i<issue.total ;i++ ) {
        myISSUE.push(
            {
                "ISSUE_Number":issue.issues[i].key,
                "TITLE": issue.issues[i].fields.status.name,
                "STATUS": issue.issues[i].fields.summary,
            }
        )
    };
    var csv = json2csv({ data: myISSUE});
    fs.writeFile('file.csv', csv, function(err) {
        if (err) throw err;
            console.log('file saved');
        });
    })
    .catch(function(err) {
        console.error(err);
    }
);

Built With πŸ› οΈ

  • NodeJS - a JavaScript runtime built on Chrome's V8 JavaScript engine. Version 12.16.1 LTS
  • Express - Dependency Management. Default package manager for the JS runtime environment Node.js
  • NPM - Dependency Management. Default package manager for the JS runtime environment Node.js
  • Atlassian API - a proprietary issue tracking product developed by Atlassian that allows bug tracking and agile project management API
  • fs - module provides a lot of very useful functionality to access and interact with the file system.
  • Node-Cron - A simple cron-like job scheduler for Node.js
  • Jasmine - A behavior-driven development framework for testing JavaScript code.
  • Nodemon - A utility that will monitor for any changes in your source and automatically restart your server. Perfect for development. Install it using npm.[devDependency]
  • [ES6/ES7](http://es6-features.org/#Constants | https://developer.mozilla.org/en-US/docs/Archive/Web/JavaScript/ECMAScript_Next_support_in_Mozilla#ECMAScript_2017) - ECMAScript Next refers to new features of the ECMA-262 standard (commonly referred to as JavaScript) introduced after ECMAScript 2015. New versions of ECMAScript specifications are released yearly.

Contributing πŸ‘

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

Authors πŸ“–

  • Jake Westerfield - Primary Work

License πŸ”¬

MIT

About

πŸ”ŽπŸ“‡πŸ“ˆ Atlassian to CSV Query Tool allows quick review of Atlassian(JIRA) Column Data in one simple Node.JS script running(npm node [appName].js)

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published