Help me to fetch comments when list of jira ticket are parsed.

Question

Hi,

I have some jira ticket numbers in excel. I have to parse these to jira website and get the corresponding comments.

Please help me on this.

DPKJ · Answer

@AnnapurnaHere are steps you can follow,

1. Save excel file as CSV so that it will be easier for program to read.

2. Use CSV module (https://docs.python.org/3.7/library/csv.html# ) to read this file and get ID/KEY of each issue.

3. Use Python Jira library to fetch comments against each issue ( I suggest you do this one by one)

4. Write those comment back to CSV or use them where you like.