Retrieve data from a JSON file

To retrieve data from a JSON file using Java and Selenium, you can use a library like Gson or Jackson for handling JSON parsing.

{

  "username": "Tester1",

  "password": "Test1234",

  "url": "https://demoqa.com/"

}

package com.seleniumExamples2024;

import java.io.FileReader;
import java.io.Reader;
import com.google.gson.Gson;
import com.google.gson.JsonObject;

public class RetrievDataFromJson {
	public static void main(String[] args) {
		try {
 // Specify the path to your JSON file
            String jsonFilePath = ".//Userdata.json";
 // Create a FileReader to read the JSON file
            Reader reader = new FileReader(jsonFilePath);
  // Use Gson to parse the JSON content
            Gson gson = new Gson();
 JsonObject jsonObject = gson.fromJson(reader, JsonObject.class);
    // Retrieve data from the JsonObject
            String username = jsonObject.get("username").getAsString();
            String password = jsonObject.get("password").getAsString();
            String url = jsonObject.get("url").getAsString();
   // Print the retrieved data
            System.out.println("Username: " + username);
            System.out.println("Password: " + password);
            System.out.println("URL: " + url);
    // Close the reader
            reader.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
	}

Use Python

import json

# Specify the path to your JSON file
json_file_path = "./Tester.json"

# Read the JSON file
with open(json_file_path, 'r') as file:
    # Load the JSON content
    data = json.load(file)

# Access and print specific values from the loaded data
print("Name:", data["name"])
print("Age:", data["age"])
print("City:", data["city"])
print("Is Student:", data["isStudent"])
print("Skills:", data["skills"])

JSON file Example

{
 "employees": {
  "employee": [{
  "name": "John Doe",
  "age": 20,
  "city": "New York",
  "isStudent": true,
  "skills": ["Java", "C#", "Python", "JavaScript"]
},
{
  "name": "John Smith",
  "age": 30,
  "city": "Raleigh",
  "isStudent": false,
  "skills": ["Java", "Python", "JavaScript", "Ruby"]
},
{
  "name": "Kattie josh",
  "age": 23,
  "city": "Ellicott city",
  "isStudent": true,
  "skills": ["Java", "Python", "JavaScript"]
}
 ]
 }
}

package com.seleniumExamples2024;

import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;
import com.fasterxml.jackson.databind.JsonNode;
import com.fasterxml.jackson.databind.ObjectMapper;

public class EmployeeDataFromJson2 {

	public static void main(String[] args) {

		try {
    // Specify the path to your JSON file
			String jsonFilePath = "Employees.json";

	// Read the JSON file as a string
			String jsonContent = new String(Files.readAllBytes(Paths.get(jsonFilePath)));

    // Parse the JSON content using Jackson
	ObjectMapper objectMapper = new ObjectMapper();
	JsonNode rootNode = objectMapper.readTree(jsonContent);

    // Retrieve the "employees" JSON array
			JsonNode employeesArray = rootNode.get("employees").get("employee");

   // Iterate over each employee object
			for (JsonNode employee : employeesArray) {
				String name = employee.get("name").asText();
				int age = employee.get("age").asInt();
				String city = employee.get("city").asText();
				boolean isStudent = employee.get("isStudent").asBoolean();
				JsonNode skillsArray = employee.get("skills");

	// Print employee information
				System.out.println("\nName: " + name);
				System.out.println("Age: " + age);
				System.out.println("City: " + city);
				System.out.println("Is Student: " + isStudent);
				System.out.print("Skills: ");
				for (JsonNode skill : skillsArray) {
					System.out.print(skill.asText());
		if (skill != skillsArray.get(skillsArray.size() - 1)) {
						System.out.print(", ");
					}
				}
				System.out.println();
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}