Get Jira data using Rest APIs

Like (0) Share

Report

Posted on 26 Mar 2024 22:45:32 by Amaya2013

103

Hi guys,

Just wondering if it's possible to extract Jira data using certain filters and upload it as an excel file to an existing SharePoint folder in Power automate?

Can we use Rest APIs to achieve this? If yes then can anyone please help me to build the flow.

Thanks a lot.

All responses (7)

Answers (0)

WillPage 1,907 on 03 Apr 2024 at 02:17:44

Like (0)

Report

Re: Get Jira data using Rest APIs

Is your Jira instance exposed to the public Internet, or internal (or via VPN) only?
Amaya2013 103 on 02 Apr 2024 at 15:52:49

Like (0)

Report

Re: Get Jira data using Rest APIs

The Jira I'm using is on-premises so can we use Rest APIs or existing connectors in power automate to connect to Jira?
WillPage 1,907 on 29 Mar 2024 at 01:12:09

Like (0)

Report

Re: Get Jira data using Rest APIs

It looks like you put the wrong URL in or the service is down
Amaya2013 103 on 27 Mar 2024 at 11:30:14

Like (0)

Report

Re: Get Jira data using Rest APIs

Hi guys,

I'm getting below error:
I've used below HTTP request to connect to Jira but it doesn't seem to be working:

Any help will be much appreciated. Thanks
Amaya2013 103 on 27 Mar 2024 at 11:20:42

Like (0)

Report

Re: Get Jira data using Rest APIs

I've managed to connect to Jira using HTTP request. Now I'm trying to get data from Jira and copy it on excel spreadsheet saved down in Teams Channel. I'm able to get the file name but the other 3 drop downs (Table, Key Column and Key Value) are blank so can't select anything. Can anyone please help me to fix the issue? Thanks
Amaya2013 103 on 27 Mar 2024 at 10:15:37

Like (0)

Report

Re: Get Jira data using Rest APIs

@WillPage - Thanks. I'm trying to build the flow and using the trigger "When a new issue is created in Jira" but somehow getting a connection error while selecting project name as below
I've connected using Jira API Token but getting the above error. Any help will be much appreciated. Thanks
WillPage 1,907 on 27 Mar 2024 at 01:48:21

Like (0)

Report

Re: Get Jira data using Rest APIs

You are basically asking the community to make your flow for you. This is way too general a question for anyone to answer. I suggest you do some googling, get started then when you get stuck you can ask a specific question about the thing you're stuck on and people will be likely to help you out.