Forum Discussion

dev16's avatar
dev16
Contributor
8 years ago

Using Externaal file bulk data and POST the same

HI I want to insert the Bulk data through through excel csv data file in soapui 5.2.1 so request you please guide me how to read external files data and post the request   Thanks Dev
nmrao's avatar
nmrao
Champion Level 3
Data / more specific details are more important while posting the question for better & quick help.
dev16's avatar
dev16
Contributor
8 years ago

hi

i have excel sheet where all Customer name are available that i want to post /create

below are the data sample excel sheet

 

CustIdFirst NameLast NameAGEADDCity
Cust1AnandMishra60sb roadjaipur
Cust2Sanjaychaudhari56chaudhari chowkAgra
Cust3NileshChavan40nirhari roadBeed

 

want to insert/post the data

 

Plz guide

 

BR

Dev

  • nmrao's avatar
    nmrao
    Champion Level 3
    8 years ago
    Thank you. Now how this data needs to be used in the next request? Or sample next step request would be helpful.
    • dev16's avatar
      dev16
      Contributor
      8 years ago

      Thanks for Reply.

      next request will be json request ..

      {
      "addressLine1": "sb road",
      "addressLine2": "Sb road",
      "birthDate": "1991-07-07",
      "city": "Jaipur",
      "district":"",
      "email": "abc@test.com",
      "firstName": "Leena ",
      "lastName": "W",
      }

       

       I m using free versions soapui5.2.1

      so please guide me 

      Thanks

      Mahadev Panchal

       

      • nmrao's avatar
        nmrao
        Champion Level 3
        8 years ago
        Have you followed link provided in the above reply? Have made any progress?