# Get data from different URLs

**URL:** <https://forum.katalon.com/t/get-data-from-different-urls/86613>\
**Category:** Web Testing\
**Tags:** scraping\
**Created:** [April 3, 2023, 1:13pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613 "2023-04-03T13:13:10Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![jamfouiny](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/jamfouiny/32/16104_2.png) [@jamfouiny](https://forum.katalon.com/u/jamfouiny)\
**Post date:** [April 3, 2023, 1:13pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/1 "2023-04-03T13:13:10Z")

</div>

Hello everyone,

I have a list of cities (934 cities) where I need to get the price per M².

My scenario is the following:

- Go to the url : [Prix m2 immobilier à la location à Nice (06000) en avr. 2023](https://www.seloger.com/prix-de-l-immo/location/provence-alpes-cote-d-azur/alpes-maritimes/nice/60088.htm)
- Type the name of the city in the search bar
- Retrieve the price per m²
- Type the second name of the city in the search bar
- Retrieve the price per m² etc…

Do you have an idea how to do this ?  
My city list is on an excel

Thanks you very much

---

<div class="post-metadata">

**Author:** ![anon46315158](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@anon46315158](https://forum.katalon.com/u/anon46315158)\
**Post date:** [April 3, 2023, 2:50pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/2 "2023-04-03T14:50:13Z")

</div>

start to look here:

> **[Data-driven testing with Katalon Studio | Katalon Docs](https://docs.katalon.com/docs/create-tests/data-driven-testing/data-driven-testing-with-katalon-studio)**
>
> Data-driven testing is a software testing method that stores test data in table or spreadsheet format. Data-driven testing allows testers to input a single test script that can execute tests for all test data from a table and expect the test output...

---

<div class="post-metadata">

**Author:** ![jamfouiny](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/jamfouiny/32/16104_2.png) [@jamfouiny](https://forum.katalon.com/u/jamfouiny)\
**Post date:** [April 3, 2023, 4:51pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/3 "2023-04-03T16:51:09Z")

</div>

This does not meet my needs. I am on the studio version (with the chrome extension) and I only want to scrape the big bold number according to the cities

---

<div class="post-metadata">

**Author:** ![Russ\_Thomas](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/russ_thomas/32/11884_2.png) [@Russ\_Thomas](https://forum.katalon.com/u/Russ_Thomas)\
**Post date:** [April 3, 2023, 6:42pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/4 "2023-04-03T18:42:30Z")

</div>

> [@jamfouiny](#):
>
> I am on the studio version (with the chrome extension)

What Chrome extension? Are you talking about Katalon Recorder?

---

<div class="post-metadata">

**Author:** ![Russ\_Thomas](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/russ_thomas/32/11884_2.png) [@Russ\_Thomas](https://forum.katalon.com/u/Russ_Thomas)\
**Post date:** [April 3, 2023, 6:47pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/5 "2023-04-03T18:47:37Z")

</div>

Going by this: [How to upload photos to an ad site?](http://forum.katalon.com/t/how-to-upload-photos-to-an-ad-site/59164) you are using Katalon Recorder **which is not Katalon Studio**.

If you don’t post to the correct forum category, you will just confuse people. If you don’t formulate your queries correctly, you will confuse people into giving you incorrect/unhelpful answers.

This would be understandable for a new user, but you’ve been around since Oct 2021 so you should know which product you’re using and be able to state it clearly.

---

<div class="post-metadata">

**Author:** ![jamfouiny](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/jamfouiny/32/16104_2.png) [@jamfouiny](https://forum.katalon.com/u/jamfouiny)\
**Post date:** [April 4, 2023, 7:52am UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/6 "2023-04-04T07:52:54Z")

</div>

Yes, sorry that’s right  
It’s an oversight on my part.  
I left tech for a few years and I’m coming back to take over the software.

Do you have an idea for my problem?

---

<div class="post-metadata">

**Author:** ![Russ\_Thomas](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/russ_thomas/32/11884_2.png) [@Russ\_Thomas](https://forum.katalon.com/u/Russ_Thomas)\
**Post date:** [April 4, 2023, 12:29pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/7 "2023-04-04T12:29:05Z")

</div>

> [@jamfouiny](#):
>
> Do you have an idea for my problem?

No, sorry. But I moved your post to the correct forum.

---

<div class="post-metadata">

**Author:** ![guy.mason](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/guy.mason/32/20660_2.png) [@guy.mason](https://forum.katalon.com/u/guy.mason)\
**Post date:** [July 3, 2023, 8:19pm UTC](https://forum.katalon.com/t/get-data-from-different-urls/86613/8 "2023-07-03T20:19:01Z")

</div>

@jamfouiny Not sure if you’re looking still to solve this, but here are some tips if you are:

- Export the Excel document to a CSV document (call it Cities.csv for this example)
- Make sure the column header for your cities list has the label ‘CityName’
- You want to ensure whatever the city name is, it matches the first result shown in the drop down (e.g. as on that site, it can have a lot of options shown in the drop down, but if the search query is specific enough, it should match the one you want)

Then, once this is ready, go to the ‘Test Data’ area on the left-hand side of the Katalon Recorder window and import this CSV file (via the folder icon to the right of this label).

The following script should then work to do what you’ve requested..

 ![image](https://europe1.discourse-cdn.com/katalon/original/3X/3/4/344ebe34b9cd755616d512510873984933b21c58.png)
