Extract json values in beanshell script

Question

This is my json i want to extract firstname and code using beanshell script.But i'm not able to extract the values . Please help

{  
   "code":"HNYC",
   "message":"Sucess",
   "data":{  
      "Employeid":"TGRDH-887",
      "Perosonal":{  
         "Details":{  
            "firstname":"Sam",
            "id":3566,
            "dob":"23/11/1990",
            "Yearofjoing":"2018",
            "Salary":30000,
            "Address":"New Delhi",
            "City":"Delhi"
         }
      }
   }
}

Beanshell Code:

import com.eclipsesource.json.JsonObject;
String jsonString = prev.getResponseDataAsString();  
JsonObject accountId = JsonObject.readFrom(jsonString); 
String code = accountId.getJSONObject("code");   
print("value "+code);

@SuhasBachhav this is java, not javascript

Matsemann
– Matsemann

2018-11-09 08:45:01 +00:00
Commented Nov 9, 2018 at 8:45 — Matsemann
– Matsemann, Commented Nov 9, 2018 at 8:45

Dmitri T · Accepted Answer · 2018-11-09 06:46:52Z

1

First of all, do you know about JSON Extractor? If not - consider using it as it provides possibility to fetch JSON data using simple JSONPath queries like $..code and $.. firstname

If you still want to go for scripting be aware that since JMeter 3.1 it is recommended to use Groovy for any form of scripting. Groovy is more "modern" language than Beanshell, it supports all new Java features and it has a lot of enhancements on top of Java SDK

One of them is built-in JSON support via JsonSlurper class, so you can shorten your code to something like:

def json = new groovy.json.JsonSlurper().parseText(prev.getResponseDataAsString())
String code = json.code
log.info(code)

Demo:

More information:

answered Nov 9, 2018 at 6:46

Dmitri T

169k6 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ryuzaki L · Accepted Answer · 2018-11-09 06:01:24Z

1

You can get code value directly from JSONObject, since it is property in JSONObject refer

String code = accountId.get("code");

edited Nov 9, 2018 at 6:01

answered Nov 9, 2018 at 5:54

Ryuzaki L

40.4k14 gold badges81 silver badges111 bronze badges

4 Comments

saravanan Over a year ago

I got below error when i tried above Problem in BeanShell script: org.apache.jorphan.util.JMeterException: Error invoking bsh method: eval Sourced file: inline evaluation of: ``import com.eclipsesource.json.JsonObject; String jsonString = prev.getResponseD . . . '' : Typed variable declaration : Class: JsonObject not found in namespace

Ryuzaki L Over a year ago

did you have JSON library in your class path?

saravanan Over a year ago

yes i have minimal-json-0.9.2.jar in lib of my jmeter, and also i have imported below import import com.eclipsesource.json.JsonObject;

Ryuzaki L Over a year ago

stackoverflow.com/questions/37855894/…, check this and once again check import statement

SANTOSHKUMAR SINGH · Accepted Answer · 2018-11-09 06:01:17Z

0

JSONObject jsonObject = new JSONObject(jsonString);
JSONObject getData = jsonObject.getJSONObject("data");
JSONObject getPerosonal = getData.getJSONObject("Perosonal");
JSONObject getDetails = getPerosonal.getJSONObject("Details");
Object firstname= getDetails.get("firstname");

System.out.println(firstname);

answered Nov 9, 2018 at 6:01

SANTOSHKUMAR SINGH

4763 silver badges11 bronze badges

1 Comment

SANTOSHKUMAR SINGH Over a year ago

Use import org.json.simple.JSONObject; package or find the equivalent in import com.eclipsesource.json.JsonObject;

Collectives™ on Stack Overflow

Extract json values in beanshell script

3 Answers 3

Comments

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related