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
8 years ago

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