How to extract data from JSON file in Java? Automation/SDET interview question to parse JSON?

Java Interview question Set-1:
SET-01 1-10

Java Interview question Set-2:

SET-02 10-20

Java Interview question Set-3:

SET-03 21-30

Data driven testing for Selenium and Rest Assured with Json file

Learn how to extract data from a JSON file in Java, we will discuss two ways, but any method can be used in your framework, Remember to add it to Utility.

This will help us to perform Data driven testing for Selenium and Rest Assured with Json file.

There are two ways we can fetch data from the JSON file:

- using jsonobject

- using jsonpath

Let's discuss both the approaches.

SDET Interview Question and Answers.  

Jenkins Interview Questions and Answers. 

Appium Interview Questions and Answers

Selenium Interview Questions and answers. 

GIT Interview Questions and Answers

How to fetch test data from json file using jsonobject

1. Create a testdata.json file

2. Create a method which will fetch value from json object using key

public static String getTestData(String input) throws IOException, ParseException {
        String testdata;
        return testdata = (String) getJsonData().get(input);//input is the key
       
    }
   

3. Create a method as  getJsonData() with return type as JsonObject

public static JSONObject getJsonData() throws IOException, ParseException  {
       
        //pass the path of the testdata.json file
        File filename = new File("TestData//testdata.json");
        //convert json file into string
        String json = FileUtils.readFileToString(filename, "UTF-8");
        //parse the string into object
        Object obj = new JSONParser().parse(json);
        //give jsonobject o that I can return it to the function everytime it get called
        JSONObject jsonObject = (JSONObject) obj;
        return jsonObject;

    }

To learn more about JSON please refer below link:

https://www.json.org/

"String Question and Answers" <== Click

 

How to fetch test data from json file using jsonPath?

    Note: Use https://jsonpath.com/ to write your own jsonpath

    1. Create a testdata.json file

    2. Create a method which will fetch value from json object using key

public static String getdatafromjson(String path) throws IOException {
       
        File f = new File("TestData//testdata.json");
        String json = FileUtils.readFileToString(f, "UTF-8");
        String result;
        return result = JsonPath.read(json, path);
       
    }

There is one more way to do the same which is by using the POJO class, check the post below for all the steps in json to pojo conversion:

How to Convert JSON to POJO Class ?

Want to learn more about Framework Design, do check out the link below for configuration properties and extent reporting:

Framework Design

How to use mocking and create Stub with Wiremock for your integration tests?

Ans:Click Here For Answer With Code And Steps

Java Interview question Set-1:
SET-01 1-10

Java Interview question Set-2:

SET-02 10-20

Java Interview question Set-3:

SET-03 21-30

Learn (API-Microservice)Testing+(CoreJava+UI)-SDET with Self Paced Videos and one LIVE Doubt Session
TRANING VIDEOS AVAILABLE with Live Doubt Session @4500/-(course-1 below,API TRaining Videos With ClassNotes and Coding Set) and 6500/- (API+UI, both course-1 & 2 below) Check Training Page for Course Content or reach out @whatsapp +91-9619094122
Entire course content can be found below:  COURSE CONTENT

***********************************
Note: If anyone need help in designing framework or virtual support for Automation work then reach out to me @sidharth.shukla19@gmail.com/9619094122
***********************************

Check below link for question and answers with code:

Top API Interview Question 1-10

Top API INterview Questions 11-20

Top API AUTOMATION Interview Q&A - 21-30

Top API Interview Q&A SET - 06
 
Top 50 Selenium Automation Interview Q&A 
*************************************************
SeleniumWebdriver Automation Testing Interview Questions:
https://automationreinvented.blogspot.com/search/label/SeleniumWebdriver
API Testing Interview Question Set:
https://automationreinvented.blogspot.com/search/label/Rest-API
 
Kubernetes Interview Question Set
https://automationreinvented.blogspot.com/search/label/Kubernetes
 
Docker Interview Question Set
https://automationreinvented.blogspot.com/2020/02/top-18-docker-commands-for-aytomation.html
 
Linux Interview question Set
https://automationreinvented.blogspot.com/search/label/Linux
 
Automation Testing/SDET Framework Design
https://automationreinvented.blogspot.com/search/label/FrameworkDesign

Java Related Interview Question Set
https://automationreinvented.blogspot.com/search/label/Java

GIT Interview Question Set:
https://automationreinvented.blogspot.com/search/label/GIT

Coding Interview Question Set:
https://automationreinvented.blogspot.com/search/label/Coding%20Questions
Mobile Testing Interview Question Set:
https://automationreinvented.blogspot.com/search/label/Mobile%20Testing
Python Interview Question Set for QAE - SDET - SDE:
https://automationreinvented.blogspot.com/search/label/Python