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
Forum Discussion
hi
i have excel sheet where all Customer name are available that i want to post /create
below are the data sample excel sheet
| CustId | First Name | Last Name | AGE | ADD | City |
| Cust1 | Anand | Mishra | 60 | sb road | jaipur |
| Cust2 | Sanjay | chaudhari | 56 | chaudhari chowk | Agra |
| Cust3 | Nilesh | Chavan | 40 | nirhari road | Beed |
want to insert/post the data
Plz guide
BR
Dev
Thank you. Now how this data needs to be used in the next request? Or sample next step request would be helpful.
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
- Have you followed link provided in the above reply? Have made any progress?
Thanks Rao for your reply
I tried but not worked ..its giving some pio jar related error
i am giving below my excel sheet sample data sheet which i need to use in my post json request to create patient name
so please request you guide me in details .. i am not comfortable with groovy scripting
i am using soapui 5.2.1 free version
addressLine1 addressLine2 birthDate city district email firstName homeTelNo landmark lastName latitude longitude middleName mobileNo pincode sex state suffix village aadharNo patientType ipdNumber pregnancyDuration pregnant guardianRelation guardianName guardianSignData new add new add2 1991-07-07 Pune Pune abc@gmail.com Test user male Maharashtra OPD new add 3 new add3 1991-09-08 Mumbai Mumbai xyz@gmail.com Test1 user female Maharashtra IPD IPD849343 7 Yes new add 4 new add4 1991-05-08 Nashik Nashik edf@gmail.com Test2 user male Maharashtra OPD Thanks
Dev
