Forum Discussion

user2's avatar
user2
Occasional Contributor
6 years ago

DataSource Loop on SoapUI Pro

Hi, I'am using SoapUI Pro to test the Rest Nominatim Api(https://nominatim.openstreetmap.org/reverse.php?format=json&lat={latitude}&lon={longitude}).
I want to know how to loop through the 2 needed parameters (latitude, longitude) received from a Data source(Excel file),
Thank you for your help.

 

 

  • avidCoder's avatar
    avidCoder
    6 years ago

    It doesn't matter whether its successive columns or not. Do you have columns like this:-

    Sl No latitude country iso2 iso3 longitude
    1 23 China Hippo Wesr 43
    2 34 India Zeta Che 56

     

    Just mention the correct column name against the parameterization.

    • user2's avatar
      user2
      Occasional Contributor
      6 years ago

      avidCoder Thank your for your response

       

      i have an excel file that contains a list of informations about some citites(latitude,country,iso2,iso3,longitude),the probleme is that i can't set 2 properties(latitude,longitude) to receive data from excel file(latitude,longitude) since they are not successive columns.

      • avidCoder's avatar
        avidCoder
        Super Contributor
        6 years ago

        It doesn't matter whether its successive columns or not. Do you have columns like this:-

        Sl No latitude country iso2 iso3 longitude
        1 23 China Hippo Wesr 43
        2 34 India Zeta Che 56

         

        Just mention the correct column name against the parameterization.