exporting to json

Norbert_L

Forums

Hi Brian, 
do you know if it is possible to export data from IDEA to the json format?
I would like to export the data within our script and import it to PowerBI.
I havent found anything in the menus or the internet - so I've planned it to export to a delimited utf8 file as workaround.
 
Thx in Advance :)
Greets
Norbert

Brian Element Fri, 11/08/2019 - 09:42

Hi Norbert,

There is no option to export to json but there are a few options for you.  Depending on the version of IDEA you are using you could create ODBC drivers to allow Power BI to connect directly to IDEA.  That is what I am doing in one of the projects I am working on.  Another option is to output the information as a text delimited file and then use that in Power BI.

Brian