Forum Discussion

678's avatar
678
Regular Contributor
8 years ago

JSON Request Parametrization

I am looking how to do a json Request parameterization as I am holding a hundreds of JSON if I can't create every single json as a Test case/Rest request so I want to pass JSON from Excel File / Text...
groovyguy's avatar
groovyguy
Community Hero

If you have an excel or text file, I've found a datasource step using a file as the input worked best for me.

678's avatar
678
Regular Contributor
8 years ago

groovyguy

 

appreciate if you share 

  • groovyguy's avatar
    groovyguy
    Community Hero
    8 years ago

    678: I don't have a direct example to share. It looks like you have two files that work together, which may not work with a single File DataSource. If you can provide a sample of the txt file and excel file, I may be able to work up a set of DataSources and/or a groovy script.

    • 678's avatar
      678
      Regular Contributor
      8 years ago

      Yes i am having a two files 

       

      1) Json 2) Excel/csv 

       

      JSON 

       

      Text File name :  Name.json

      "userName": "${userName}",
      "password": "${password}",

       

       

      2) Excel / Csv Data 

       

      userName password  inputjson

      kumar       kumar123 Name.json

      • New2API's avatar
        New2API
        Frequent Contributor
        8 years ago

        Hello there! we have implemented very similar approach. i.e., reading a canned JSON from a file then replacing JSON objects from Data-source value.

         

        Data-driven test case structure would look like this:

         

        Groovy script would read JSON file and then replace the JSON objects and build new JSON payload for your REST request.

         

         

        import net.sf.*
import net.sf.json.*
import net.sf.json.groovy.*
import groovy.json.JsonSlurper
import groovy.json.JsonBuilder

//## Get Directories ##//
def RequestPath = "C://TestUser//Request//"

log.info "Read canned JSON payload from $RequestPath"
log.info "Parsing JSON payload..."

//## READ canned request from a file to modify ##//
def JsonPayload = new File(RequestPath + "SampleJSON.txt").text
def JSONReq = new JsonSlurper().parseText JsonPayload


//## Get data from DataSource ##//
def userName = context.expand( '${DataSource#UserName}' )
def Password = context.expand( '${DataSource#Password}' )

log.info "Updating json nodes..."

JSONReq.userName = "$userName"
JSONReq.password = "$Password"

log.info "Updating JSON Payload at testCase level property eSignJSON"

//## build json body and write to a file for reference ##//
def REQUEST = new JsonBuilder(JSONReq).toString()
    testRunner.testCase.setPropertyValue("JSONPayload", REQUEST)

log.info "JSON payload is $REQUEST"

         

         

        In the Rest request point "JSONPayload" property to get the latest payload.

        i..e., ${#TestCase#JSONPayload}

         

        Hope this helps!