Forum Discussion

prasath_2k's avatar
prasath_2k
Occasional Contributor
4 years ago
Solved

How to read a JSON file

Hi experts,   I wanted to read and work with JSON files. Is there best ways to read JSON files using TestComplete? I wanted to trigger the script to fetch the JSON file and do curtains operation by...
Desktop Testing
Test Run
ishu's avatar
ishu
Occasional Visitor
3 years ago

Hi prasath_2k,

 

I also trying to do the same and searching for the solution. If you have any solution please let me know.

 

Thanks,

IshuS

  • prasath_2k's avatar
    prasath_2k
    Occasional Contributor
    3 years ago

    Hi ishu,

    I am trying to use "eval" function. Initially fetch the Json file from bath and convert the file content to object. Then each element of the file can be used to fetch data from file. Let me attach the code spinet below which might be useful. 

     

    //Get the path of JSon file and read the file//
    path = Project.Path
    var JSonFilepath = path+"Test Data\\"+"DisplayTab.json";    .....(DisplayTab.Json is my file name)

     

    //Reading the Text file//

    var data = aqFile.ReadWholeTextFile(JSonFilepath, aqFile.ctANSI);

     

    //Converting the Text file to a single object//
    var TestObj = eval("(" + data + ")")                 ......("TestObj" is entire Text file converted to single object)

     

    Now we have designed our  Json file with our desired with nodes and sub nodes, we can easily access the each of it present in Json file using that "TestObj".

    Example: TestObj.Node.SubNode --> Will fetch that particular value.

     

    Hope you found this useful.

     

    Thanks