Ολοκληρωμένο

Excel Macro - query data from Jira and format

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

This is basically creating a release report.

Flow:
1) Connect to Jira from Excel using a Jira API token
2) Query Jira for a set of Epics contained in a release
3) For each Epic, query Jira for the set of stories in that epic
4) for each Story, query Epic for the set of test cases linked to that story
5) for each Test Case query Jira for linked bugs that block the test case
6) Format as a nested set of column as given in the example spreadsheet

There is a pretty good end to end example of a similar project here: https://www.codeproject.com/Articles/1088523/Excel-Jira-Rest-API-end-to-end-example

I have uploaded the spreadsheet as an example in the files section.

Requirements:
1) Runs on a 64 bit mac running Excel for Mac version 16.18
2) Would like the solution based off the example macro uploaded, it has nice UI features, but not a hard requirement. Anything that produces the required output is acceptable.

Ικανότητες: Επεξεργασία Δεδομένων, Excel, Visual Basic, Visual Basic για Εφαρμογές

Περισσότερα: excel macro move data existing cell, excel macro copy data column, macro move data cell database excel, excel macro enter data database, macro copy data excel, excel cut paste data macro, excel macro copy data windows application, excel macro paste data, excel macro web data read, excel macro cut data, excel macro returning data try, excel macro refresh data, excel macro oracle data entry, macro input data number already used excel, excel macro moving data cell cell, macro read data cell excel, excel refresh query data moves, excel macro check data format, excel 2003 macro query data

Σχετικά με τον Εργοδότη:
( 2 αξιολογήσεις ) Mill Valley, United States

Ταυτότητα Εργασίας: #18032318

Ανατέθηκε στον:

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Περισσότερα

$30 USD σε 4 μέρες
(295 Αξιολογήσεις)
7.7

15 freelancers κάνουν προσφορές κατά μέσο όρο $126 για αυτή τη δουλειά

polarjin2017

Hello? How are you? I have good skills in excel macro... So I can complete your job in time. Hope to work with you. Thank you.

$155 USD σε 3 μέρες
(64 Αξιολογήσεις)
6.4
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Περισσότερα

$150 USD σε 3 μέρες
(76 Αξιολογήσεις)
5.8
$250 USD σε 1 μέρα
(45 Αξιολογήσεις)
5.8
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis Περισσότερα

$111 USD σε 5 μέρες
(74 Αξιολογήσεις)
5.8
Orientwork

hello sir ! how are you?? i can do your work as per your requirements , just talk to me , then we able to

$50 USD σε 3 μέρες
(58 Αξιολογήσεις)
5.0
akritisood94

Dear hiring manager I have got your job posting on Excel Macro Project. According to your job description you need a fast worker for your data mining and web research. For your kind information I want to let you know Περισσότερα

$50 USD σε 1 μέρα
(20 Αξιολογήσεις)
4.7
sysdesigner13

Hi, bro! I've read your requirement. I have rich experience with data processing using Excel vba. I have finished many projects like this. I'm confident in your project and I promise to do your project in time. Περισσότερα

$100 USD σε 3 μέρες
(11 Αξιολογήσεις)
4.1
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Περισσότερα

$150 USD σε 3 μέρες
(16 Αξιολογήσεις)
3.5
Mickelson

Hi, I am expert in excel macro development. I want to know the detailed requirement from you. I can do perfect job for you. Hope to discuss more details via interview. Best Regards.

$155 USD σε 3 μέρες
(3 Αξιολογήσεις)
3.8
mihalceageorgica

Experience with jira plugins. I can work on this.

$222 USD σε 6 μέρες
(1 Κριτική)
2.1
NephSys

I have great team for the best marketing solutions, we are very excited for the opportunity to work with you in accomplishing your goals. We have developed thousands of websites in many programming languages for client Περισσότερα

$155 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
rashednp

Hi There I'm data entry expert & i have 3 years experienced on excel & data entry. I'm interested to do your project. Please give me your project if you think I'm perfect. My skills: excel, data entry, SEO & so on. Περισσότερα

$45 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
webscraper24

"Greetings! According to your stated project description you need an excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your Περισσότερα

$100 USD σε 3 μέρες
(2 Αξιολογήσεις)
0.0
Sunil986020

I am expert in VBA and Jira API. I can complete this project within 3 days.

$166 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0