web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extracting fields in Jira
Power Automate
Unanswered

Extracting fields in Jira

(0) ShareShare
ReportReport
Posted on by 10

I'm new to the platform and I'm having difficulty extracting fields in Jira.

I did a get on http in my jira and I want to extract some fields.
Below is

 

def jira_extract(issues):
ticket = []
for j in issues['issues']:
aux = []
try:
aux.append(j['fields']['assignee']['emailAddress'])
except:
aux.append(None)
try:
aux.append(j['fields']['status']['name'])
except:
aux.append(None)
try:
aux.append(j['fields']['summary'])
except:
aux.append(None)
try:
aux.append(j['fields']['description'])
except:
aux.append(None)
try:
aux.append(j['fields']['customfield_12987'])
except:
aux.append(None)
try:
aux.append(j['fields']['priority']['name'])
except:
aux.append(None)
try:
aux.append(j['fields']['issuetype']['name'])
except:
aux.append(None)
try:
aux.append(j['fields']['created'])
except:
aux.append(None)
try:
aux.append(j['fields']['resolutiondate'])
except:
aux.append(None)
try:
aux.append(j['fields']['customfield_13373']['value'])
except:
aux.append(None)
try:
aux.append(j['fields']['customfield_12574']['value'])
except:
aux.append(None)
try:
aux.append(j['fields']['customfield_15961']['value'])
except:
aux.append(None)
ticket.append(aux)



 

 

 

please!


Follow your videos where I'm trying to learn, if you saw my question please answer me and if I could make a video

 

Categories:
I have the same question (0)
  • jose_nascimento Profile Picture
    10 on at

    @abm 

  • abm abm Profile Picture
    32,975 Most Valuable Professional on at

    Hi @jose_nascimento 

     

    Could you post your flow and the run history?

     

    Thanks

  • jose_nascimento Profile Picture
    10 on at

     

    I'm studying a way to extract the information. To proceed, my idea would be to do it in the same format as the code in Python, but I haven't managed to do it yet.

    Untitled.png
  • abm abm Profile Picture
    32,975 Most Valuable Professional on at

    Hi @jose_nascimento 

     

    Thanks for your reply. So what you are trying to do via flow? 

     

    What's your trigger? What data you want to extract? Explain your requirements. I don't have a JIRA subscription but I could spin up a trail version and try.

     

    Thanks

  • jose_nascimento Profile Picture
    10 on at

    My intention would be to make a query in Jira via jql

    project = "Security Operations Center" AND updated >= -12h AND status in (Closed, Resolved, "In Progress", Pending)

    and in this I would like to extract these fields
    ['fields']['assignee']['emailAddress']
    ['fields']['status']['name']
    ['fields']['summary']
    ['fields']['description']
    ['fields'] ['customfield_12987']
    ['fields']['priority']['name']
    ['fields']['issuetype']['name']
    ['fields']['created']
    ['fields']['resolutiondate']
    ['fields']['customfield_13373']['value']
    ['fields']['customfield_12574']['value']
    ['fields']['customfield_15961']['value']

    I receive a huge output from http in json and I located the fields I want below a small snippet.

    jose_nascimento_0-1711048609631.png

     

    After that, I will try to migrate this data to be displayed visually in tables and graphs and send it via email.

  • jose_nascimento Profile Picture
    10 on at

    jose_nascimento_0-1711391153613.png

    To be able to extract the fields I would like, now I would need to create a graph with the data, can you tell me if this is possible? It is like.

    My idea is to transform this automation into a daily report via email, however I wanted to create some graphics to make it better visually and possible? There is a reference in one of your videos.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard