Getting data using Jira REST API, Parsing JSON, Updating excel

(0) Share

Report

Posted on by Automate123

128

Hi Power Automate community,

I am trying to create a flow that happens on recurrence (Once a day) that will use the HTTP connector to extract data using Jiras REST API using a JQL query. From him I want to parse that data to the Parse JSON connector, and then update a excel spreadsheet with the results. My current flow can be seen below:

The conntents of the HTTP conector can be seen below. It is essentially https://myorg.net/rest/api/3/search?jql=JQL query

When trying to test the flow I am presented with the following errors. See below:

Can anybody advise me on what might be wrong, or any fixes for this issue.

Thanks! 🙂

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

fchopo 8,003 Moderator on at

Like (2)

Report

Hello @Automate123

Have you tried to make the same HTTP Call to Jira using other tools like Swagger or Postman? It seems the error doesn't have any relation with Power Automate, and it's more related to the Jira PI.

Regards,

Ferran

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Automate123,

In addition to @fchopo, does your query work when you for instance only use this:

rest/api/3/search?jql=project%20%3D%20GTX

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get

I believe if the JQL query expression is too large you can use the POST instead:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-post

Was this reply helpful? Yes No
Automate123 128 on at

Like (0)

Report

Hey @Expiscornovus and @fchopo
Thank you very much for the responses. I have now managed to get 3/4 connectors to pass. I am now struggling with the updating the excel file on SharePoint.

I am trying to use the connector Add a row into a table. Through watching some videos I have been trying to add dynamic content for each of the fields. However when I do so it keeps on adding "apply to each" and ultimately the flow fails at this stage.

Do you have any advice on how I could successfully update the table with the data from the previous parse JSON step?

Thanks!

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hi @Automate123

Does the parse JSON return only one row or many rows? Power Automate is adding an apply-to-each because it's detecting you are adding a field in Excel that may have multiple values.

Do you receive any kind of error? Does the flow work?

Regards,

Ferran

Was this reply helpful? Yes No
Automate123 128 on at

Like (0)

Report

Hi @fchopo
Since posting yesterday I have now moved away from updating an excel file on sharepoint and I am now using the returned JSON to create a CSV file with all releveant fields.
In responce to your question my flow is currently working however I am getting errors of
"Array elements can only be selected using an integer index."

I have created a new thread as the flow has completely changed to my previous one. The link can be found below:
Array elements can only be selected using an integ... - Power Platform Community (microsoft.com)

If you have any ideas on how I can overcome my blockers it would be much appreciated.

Was this reply helpful? Yes No