Excel Macro - query data from Jira and format

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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.

Zpracování dat Excel Visual Basic Visual Basic pro aplikace

Identifikační číslo projektu: #18032318

O projektu

12 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

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 Další

$30 USD za 4 dní
(340 recenzí)
8.0

12 Freelnceři na tento projekt zveřejňují nabídky v průměru $123

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 za 3 dní
(98 Recenzí)
6.7
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 Další

$150 USD za 3 dní
(123 Recenzí)
6.3
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 Další

$111 USD za 5 dní
(77 Recenzí)
5.9
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 Další

$50 USD za 1 den
(58 Recenzí)
5.3
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 Další

$150 USD za 3 dní
(20 Recenzí)
4.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 za 3 dní
(62 Recenzí)
5.1
Sunil986020

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

$166 USD za 3 dní
(2 Recenzí)
2.6
mihalceageorgica

Experience with jira plugins. I can work on this.

$222 USD za 6 dní
(1 recenze)
2.1
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. Další

$45 USD za 1 den
(0 Recenzí)
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 Další

$100 USD za 3 dní
(2 Recenzí)
0.0