Image URL extraction from Amazon Web Page

[Asm_6658]

Hi Everyone!

I’m trying to extract data from Amazon and the “Extract Table Data” activity works just fine. I would like to extract the URL for the image as well using StudioX.

Thanks!

[ppr (Peter Preuss)]

@Asm_6658
Welcome to the forum

Have a look here:

Hi I am having trouble with the table extraction

@karen.souza do it as following: Click add data and select first cell from first column [grafik] there will be a popup asking if you want to extract entire table. Click on NO Click on finish selection Part results looks like this: [grafik] ensure following button is activated: [grafik] Click Add data Select first cell of second column click finish selection Part Result looks like this: [grafik] Clicking on preview: [grafik] then just post edit the extraction con…

And here:

[HowTo] Data Scraping - Advanced Configuration - Text Field, Image Source, Url, CSS Classname, Hover text

This HowTo introduces on how Data scraping can be configured to retrieve also on non standard information from a web table. After indicating the different data columns with the wizard the extract data definition was post edited and changed to the relevant attributes e.g. value (Text field), src ( Image Source), class (CSS Class Name), tite (Hover Text), href (Url). Introduction Following web table is to use for data scraping and also the non text information should be retrieved. [grafik] We…

As described configure one column for the src attribute of the image (tag=img) element

[Asm_6658]

Thanks, Peter! Appreciate your help.

The URL is getting extracted in this format – /HP-ENVY-6055e-Wireless-Printer/dp/B08XYRVSRT/ref=zg_bs_172646_1?_encoding=UTF8&psc=1&refRID=G61JAVYNPFAST5PT3SG2

Capture|690x248

The https part is missing.

Any other suggestions!!

[manjula_rajendran]

Hi @Asm_6658 ,

In most of the website when you extract URL it won’t give full URLs. You need to modify it. After getting the url you need to append the basic url

For example:

Your extracted url is
x_URL= HP-DeskJet-2335-Advantage-Printer/dp/B08CYRFX24/ref=sr_1_1_sspa?dchild=1&keywords=HP+Printer&qid=1631081020&sr=8-1-spons&psc=1&spLa=ZW5jcnlwdGVkUXVhbGlmaWVyPUFBUFAxNzlHS1VRTFYmZW5jcnlwdGVkSWQ9QTA5OTgxNzUxNDVDSDlPOFpIVTdFJmVuY3J5cHRlZEFkSWQ9QTA2NTE4NTYxMjdWNlFTMUZWSzBSJndpZGdldE5hbWU9c3BfYXRmJmFjdGlvbj1jbGlja1JlZGlyZWN0JmRvTm90TG9nQ2xpY2s9dHJ1ZQ==

Then your basic url is
URL = “https://www.amazon.in/”

Now concatenate the urls.
URL+x_URL

[Asm_6658]

Thanks, Manjula!