Use Automation for Jira to add a row in Excel file

[Rudy Holtkamp]

Hi all,

I want to use Automation for Jira to add a new row to an Excel file (on either Sharepoint or Onedrive). Has anybody done this before? And if so could you tell me how you did this?

A bit of background:
I've got a form, and after filling it in and make some updates to other fields, it will be accepted. Once accepted some of the captured data needs to be added to an Excel file (which is needed as source for an import into another system).

Thanks

Rudy

[MobilityStream]

Hi @Rudy Holtkamp ,

If you are open to an App from the Marketplace you could also use our Excel Online Integration. It can export new and updated Jira issues to Excel 365/OneDrive either one-time, real-time, or on a scheduled basis.

Kind regards,

The Mobility Team

[Mohamed Benziane]

If the Excel update is possible with a REST  API you could use automation and send a webhook

[Rudy Holtkamp]

I understand that if it is available, you can do this by REST API, but my question is how can you do this, are there any examples available?

[Mohamed Benziane]

This article may help you
https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828