Forum Discussion

dev16's avatar
dev16
Contributor
7 years ago

how to validate excel csv data which coming in GET Response

Hi 

I m usuing soapui 5.2.1 free version

where in my GET request i am getting excel report in csv data format

so how i will assert or validated the same.

E.g. below data is coming in respone in xml section.

 

<data contentType="text/csv" contentLength="318284"><![CDATA[participant_id,first_name,middle_name,last_name,date_of_birth,age,gender,address,city,state,pincode,address_l

1,xyzfirst name ,1983-08-10,34,MALE,"","","","",,,,,,,,"","","",,/data/pdfs/1216_ConsentAssent.pdf,7,f,f,,NaN,NaN,2017-08-10,1529,1216,,,,,,,,,,,12341,2017-08-08,7,V. J. Gupta hospital,1,,,1,Nagaroad€“Vadgaon,1
]]></data>

 

plz request you tell me all validations method

 

Regards

Dev

7 Replies

  • nmrao's avatar
    nmrao
    Champion Level 3
    What do you mean by " all validations method"?
    • dev16's avatar
      dev16
      Contributor

      all validations means ..based on response csv data need to add assertions

       

      Thanks

      Dev

       

      • nmrao's avatar
        nmrao
        Champion Level 3
        How would someone else know what assertion to be made, it is you to tell what to assert.