Use Automation for Jira to add a row in Excel file

Question

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 · Answer

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 · Answer

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

Rudy Holtkamp · Answer

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?