09-27-2017 09:39 AM - edited 09-27-2017 09:44 AM
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.
09-28-2017 08:36 AM
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
09-28-2017 10:42 AM
There is an vbs based json implementation at
http://demon.tw/my-work/vbs-json.html
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.