Showing results for 
Search instead for 
Did you mean: 

Import JSON file to DIADEM


Hi, I need some help. Do you know how can I import a JSON file to DIADEM? Currently I'm importing the data with Excel using Queries and then to DIADEM. But I would like to save some steps.

0 Kudos
Message 1 of 3

Hi Chegolata,


I'm not familiar with querying a JSON file for data.  If this is an SQL query, then we could reproduce that in a DIAdem VBScript using Microsoft ADO objects for the SQL access.  It might also be possible that we could write a DataPlugin to read your JSON files.  Could you post one?


Brad Turpin

DIAdem Product Support Engineer

National Instruments

0 Kudos
Message 2 of 3

There is an vbs based json implementation at


There is a fix that needs to be attached to read empty arrays.


In additional jq.exe can be used to convert json files to CSV files that can easily be imported.

0 Kudos
Message 3 of 3