Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Deeksha Pal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 29, 2023


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?

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 8, 2023

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:

The REST AP method to call to get the attachment contents is:

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("\n")}} provided a list of rows to access.

Kind regards,

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events