Forum Discussion

Renuka's avatar
Renuka
Occasional Contributor
7 years ago
Solved

How to read JSON data from file and use it in request body ?

I have one JSON file which contains following data: {   "registrationKey": "sadnskjadsdkfj",   "firstName": "Renuka",   "lastName": "Saini",   "email": "reom@gmail.com",   "phone": "1234567890"...
  • Radford's avatar
    Radford
    7 years ago

    I'm sorry but I do not have experience of the JSON data source (The vast majority of my SoapUI use is with XML data).

     

    If you haven't already I suggest you read the documentation section on Data Driven Testing, this has a lot of useful information, in particular the JSON Data Source section. It looks like you could set your File Wait test step as the source of the JSON data (Please Note: I have not tried or tested this).

nmrao's avatar
nmrao
Champion Level 3
Have you checked the documentation link provided in the earlier reply?

According to the above reply by Radford, you need add a step type File Wait test step before your existing Rest Request step.

For the rest request body use : ${fileContent} and see if that helps.
Renuka's avatar
Renuka
Occasional Contributor
7 years ago

I did the points which you both mentioned, but couldn't get the file data in request body.Steps I followed:
1) Added 'File Wait' step(Refer attached screenshot File_WaitStep)
2) Browse the file which I want to load in request body i.e. ...\...\TestData.json
3) In Request body of the api step, called the get data i.e. ${File Wait#fileContent}  ((Refer attached screenshot 'RestApiStep')

4) Play the step
5) Didn't get request body in api call (Refer attached screenshot RawDataRequest)

Please guide me!!

  • Radford's avatar
    Radford
    Super Contributor
    7 years ago

    My first initial thought is did you run the test case or just the rest test step? I think that the File Wait test step only reads the file (thus populating the fileContents property) at runtime, thus it won't work just running the Rest step.

    • Renuka's avatar
      Renuka
      Occasional Contributor
      7 years ago

      RadfordIt worked when I run the whole test case.
      File Wait is basically copying the whole data from file wherever needed and I am thankful that I learned it from both of you.

      Can you please guide me how we can do it using JSON data source as that is what I also somewhere needed in my test cases?

      • Radford's avatar
        Radford
        Super Contributor
        7 years ago

        I'm sorry but I do not have experience of the JSON data source (The vast majority of my SoapUI use is with XML data).

         

        If you haven't already I suggest you read the documentation section on Data Driven Testing, this has a lot of useful information, in particular the JSON Data Source section. It looks like you could set your File Wait test step as the source of the JSON data (Please Note: I have not tried or tested this).