Segregate Attached Excel File data of Jira in different sub-tasks

Question

Hi,

I am trying to segregate the data of an excel file that is attached to a jira ticket.

So currently my issue is in To-Do state and an excel file is attached to the issue (in description). I want when I move my ticket from To-do to In-Progress state, the file that is attached to the issue, provide me the data in sub-tasks based on the "keys" I provide.

Assuming, excel file has the data like:

1. Column - S.No.

2. Column - List of Servers

3. Column - Status (Eligible, Not Eligible, Dropped)

Is it possible?

Bill Sheboy · Answer

Hi @Deeksha Pal -- Welcome to the Atlassian Community!

First thing, I wonder: why not just import the subtasks from the file when needed rather than add the attachment?  Is there a reason you are not doing that?

Regarding your question...Using the REST API called from a rule, I tried this with a CSV file, and it does appear to be possible to read and use the contents of an attachment within the rule.  You will need the attachment id value for the call.

Here is a how-to article for calling the REST API from a rule: https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

The REST AP method to call to get the attachment contents is: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-attachments/#api-rest-api-3-attachment-content-id-get

And an example rule could be:

* trigger: whatever is needed, and it appears to be Issue transitioned for your scenario
* action: call the REST API with the Send Web Request action, ensuring you select the option to delay execution until the response occurs
* condition: check the results with {{webResponse.status}}
* actions...parse your results.  I found for a CSV that using {{webResponse.body.split("
")}} provided a list of rows to access.

Kind regards,
Bill