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! 🙂
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
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
I believe if the JQL query expression is too large you can use the POST instead:
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!
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
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.
User | Count |
---|---|
89 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
131 | |
51 | |
48 | |
36 | |
26 |