retrieving sub-tasks subfield assignee from jira cloud for sheets

[Marcelo Polizzotto]

Due to the fact that we can retrieve sub-tasks subfields and for every sub-task we can assign different team members, it would be good to retrieve the sub-task subfield assignee

[Niranjan · Accepted solution]

Hi @Marcelo Polizzotto ,

Can you elaborate the requirement? What is this "retrieve sub-tasks subfields"?

[Marcelo Polizzotto]

Hi Niranajan

take a look to my subtask ex image

I have an issue with 4 subtasks and 2 different assignee 

this assignee field is what I am looking for to return when I go jira cloud for sheets and  check subtasks subfields (see subtasks image) 

Best regards

Marcelo

[Niranjan]

Can you search for assignee or issueassignee?

[Marcelo Polizzotto]

My wished output should be like

incident xx assignee mp

                   subtask 1 assignee cb

                   subtask 2 assignee df

incident yy assignee fg

                   subtask 1 assignee df

                   subtask 2 assignee mp

the thing is that we cannot return both (incident assignee and subtask assignee)

I hope this can clarify what I need

Best regards