exporting to json

6 posts / 0 new
Last post
Norbert_L's picture
Norbert_L
Offline
Joined: 09/03/2014 - 10:37
exporting to json

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's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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

Norbert_L's picture
Norbert_L
Offline
Joined: 09/03/2014 - 10:37

Hi Brian, 
thx for your hints.
 
Greets Norbert

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Just another thought.  If you are using 10.4 or higher you could extract the data to python and have ptyhon create the json file.

klmi
Offline
Joined: 02/13/2019 - 08:41

Brian please let me correct you it works with 10.3 and higher. 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi klmi, thanks for the correction.