How to send multiple JSON in single request(Jmeter)

Question

Though I could see this question might be repeated but couldn't find any similar solution for the below JSON strut. Pls suggest.

I have excel sheet where the data's in columns look like : CSV file data

My expected JSON as:

       {
       "Child ": {
       "10"
          : { "Post": { "Kid-R":1 },
        "Var": [1,1 ],
        "Tar": [2,2],
        "Fur": [3,3]},

       "11": 
          {"Post": {"Kid-R":2 },
          "Var": [1,1 ],
          "Tar": [2,2 ],
          "Fur": [5,4 ]}
          },
         "Clone": [],
         "Birth": 2,
         "TT": 11,
         "Clock": ${__time(/1000,)}
           }

I have tried incorporating beanshell preprocessor in JMeter & tried below code:

    def builder = new groovy.json.JsonBuilder()
    @groovy.transform.Immutable
    class Child {
    String post
    String var
    String Tar
    String Fur
    }


    def villas = new File("Audit_27.csv")
    .readLines()
    .collect { line ->
        new child (line.split(",")[1],(line.split(",") 
    [2]+","+line.split(",")[3]),(line.split(",")[4]+","+line.split(",") 
   [5]),(line.split(",")[6]+","+line.split(",")[7]))}     

    builder(

    Child :villas.collect(),
         "Clone": [],
         "Birth": 2,
         "TT": 11,
         "Clock": ${__time(/1000,)}

    )
     log.info(builder.toPrettyString())
     vars.put("payload", builder.toPrettyString())

And I could see below response only:

Note: I dont know how to declare "Key" value (line.split(",")[0]) in the above solution.

      {
     "Child": [
      {
        "post": "\"\"\"Kid-R\"\":1\"",
        "var": "\"[2,2]\"",
        "Tar": "\"[1,1]\"",
        "Fur": "\"[3,3]\""
    },
    {
        "post": "\"\"\"Kid-R\"\":2\"",
        "var": "\"[2,2]\"",
        "Tar": "\"[1,1]\"",
        "Fur": "\"[3,3]\""
      }
     ],
     "Clone": [],
     "Birth": 2,
     "TT": 11,
     "CLock": 1585219797
      }

Any help would be greatly appreciated

Dmitri T Dmitri T · Accepted Answer · 2020-03-26T09:05:51

You're copying and pasting the solution from this answer without understanding what you're doing.

If you change class name from VILLA to own you need to use new own instead of new VILLA

Also this line won't compile: Clock: <take system current time> you need to use System.currentTimeMillis() or appropriate function of the Date class in order to generate the timestamp.

If you want a comprehensive answer, you need to provide:

Well-formatted CSV file
Valid JSON payload

In the meantime I would recommend getting familiarized with the following material:

How to send multiple JSON in single request(Jmeter)

2 Answers