At the moment, I am leveraging google sheets for a range of complex analytics. I rely upon the Atlassian provided "Jira Cloud for Sheets" add-on.
There are few issues I've found including the daily scheduled refresh failing, for which there is no retry option. Further, this refresh doesn't support a thoughtful stateful comparison and update changes, which would be great.
Is it possible to access the functionality of this plug-in via AppScript?
It seems as though there are only two options.
1. Use appscript to set / update a formula (..setFormula("=JIRA(....))
2. Use the UrlFetchApp to query the API directly (though it seems like it requires embedding your token in the script (bad) or in a protected and hidden sheet (decent).
Any suggestions or ideas if the plug-ins' functionality us App Script... able?
Thanks,
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.