Forum Discussion

Renuka's avatar
Renuka
Occasional Contributor
8 years ago

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
    8 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).

Radford's avatar
Radford
Super Contributor

Has you investigated using the File Wait test step to read your file? The contents of the file will be put into the file wait test step property "fileContent" which you can then access in the normal ways.

Renuka's avatar
Renuka
Occasional Contributor
8 years ago

I am a beginner in Soap UI. Can you please mention the steps to read data using FileWait test step?

Thanks in advance

  • Radford's avatar
    Radford
    Super Contributor
    8 years ago

    Exactly as nmrao said, add the File Wait test step before your Rest request and then in the Rest request reference the data from the File Wait test step with a property expansion (a property expansion is the ${ ... } thing that nmrao mentions) 

     

    If you are new to SoapUI, are you aware of the "point and click" Get Data functionality. This will allow you to use the GUI to reference data form one step to another Note: The point and click functionality is actually just a way to create the property expansions that nmrao mentioned via the GUI.

     

    There is an alternative to using the property expansions, you could put a Property Transfer test step between your File Wait and Rest test step and then configure to transfer the file contents. Try both methods and pick the one you are most comfortable with.

     

    Please note: My answers have assumed that you wanted to copy the entire contents of the file into the request body.

    • Renuka's avatar
      Renuka
      Occasional Contributor
      8 years ago

      RadfordI tried it, but my fileContent property have no value in it

  • nmrao's avatar
    nmrao
    Champion Level 3
    8 years ago
    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
      8 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
        8 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.