Excel Macro - query data from Jira and format
$30-250 USD
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.
Identifikační číslo projektu: #18032318
O projektu
Uděleno uživateli:
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ší
12 Freelnceři na tento projekt zveřejňují nabídky v průměru $123
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.
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ší
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ší
"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ší
hello sir ! how are you?? i can do your work as per your requirements , just talk to me , then we able to
"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ší