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
8 years ago
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