How can i read json data

[Lakshmi53]

  {

  "jobs": [

        {

                "details": {

                "code": "123"

            },      

           "userinfo": [

                {

                    "user": "test"

                },

                {

                    "user": "abc"

                }

            ]

            }

]

}

above is the sample JSON i have. using above json how can i get user details.

[Maddysunil]

@Lakshmi53 

Please like below:

# Sample JSON data
json_data = '''
{
  "jobs": [
        {
                "details": {
                "code": "123"
            },      
           "userinfo": [
                {
                    "user": "test"
                },
                {
                    "user": "abc"
                }
            ]
        }
    ]
}
'''

# Load JSON data
data = json.loads(json_data)

# Extract user details
user_details = []
for job in data["jobs"]:
    for userinfo in job["userinfo"]:
        user_details.append(userinfo)

# Print user details
for user_info in user_details:
    print(user_info)

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks

[Harish KM]

Hi @Lakshmi53 please find below script:

var json = {

  "jobs": [

        {

                "details": {

                "code": "123"

            },      

           "userinfo": [

                {

                    "user": "test"

                },

                {

                    "user": "abc"

                }

            ]

            }

]

};

json.jobs.forEach(function(job) {

  job.userinfo.forEach(function(user) {

    gs.info(user.user);

  });

});

[Lakshmi53]

how can i call this in scripted rest api

[Harish KM]

Hi @Lakshmi53 you need to call after you receive JSON response