Ask a Question

DataSource Loop on SoapUI Pro

SOLVED
user2
Occasional Contributor

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
avidCoder
Super Contributor

Re: DataSource Loop on SoapUI Pro

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.

View solution in original post

4 REPLIES 4
avidCoder
Super Contributor

Re: DataSource Loop on SoapUI Pro

Add data to excel, Add DataSource and Parameterize this url like this;- 

https://nominatim.openstreetmap.org/reverse.php?format=json&lat=${DataSource#latitude}&lon=${DataSource#longitude}

 

After that Add DataSourceLoop, add source as DataSource and target as this Request url step.

user2
Occasional Contributor

Re: DataSource Loop on SoapUI Pro

@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
Super Contributor

Re: DataSource Loop on SoapUI Pro

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.

View solution in original post

patilawaken
Occasional Contributor

Re: DataSource Loop on SoapUI Pro

All you need to do is

  1. Add data source as excel
  2. Browser the Excel sheet an mention the sheet name.
  3. Create individual properties for each of the coloum say lat, country, iso2, iso3 and long.
  4. Use Lat and long in parameter using property expansion/ right click and get data dialogue in paramater section.

I hope this should serve the purpose..

cancel
Showing results for 
Search instead for 
Did you mean: