How to unload data from the Insight (Assets) Scheme in .xlsx format?
On our Jira instance we have an Insight (Assets) database. The task is to unload a report with all objects of a particular type and values of all their attributes.
I know that Insight allows you to export objects in .csv format, but that doesn't always work correctly for our task, so this option is not suitable.
You need the output in this format (.xlsx):
How can this be done? If I need to use a SQL query, does anyone have an example of an implementation?