Reading JSON from *.json File

Question

Hello All, 
 
 I have a JSON file from which i need to read data. The file is not in any particular format and may have about 45,000 lines of data. 
 To read document file the the only function i can find is readtextfromfile but problem with this function (in my scenario) is its converting JSON into a single text string 
 and because of which i am not able to use index function on it. I want data in any format. 
 
 We had a different input method before, Instead of JSON file we received data from DB so i was getting data in List of Variant instead of text.

mudit · Answer

Found an answer from this link . Thanks for quick reply everyone. 
 
 NOTE: I had null data in my JSON, i used substitute to replace null with "".

mudit · Answer

Thanks for reply. But in our case we are getting JSON from external system and it does not have a defined format. 
 
The issue is now resolved as i stated above.

Reading JSON from *.json File

Top Replies