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

[Automate123]

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! 🙂

[fchopo]

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

[Expiscornovus]

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-s...

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-s...

[Automate123]

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!

[fchopo]

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

[Automate123]

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.