Question Re: Data extraction from web in Technology Q&A

Data extraction from web

rkumar — Fri, 18 Jun 2021 12:00:06 GMT

Hello Team,

I have to get the input data from excel and have to put that in search box on web and then after clicking details will pop up after that i need to extract data from there for multiple input data one by one.. In SAP iRPA Cloud Platform .Please help

Re: Data extraction from web

lucie16 — Fri, 18 Jun 2021 12:18:23 GMT

Hi Ritesh,

It is very complex question. Can you share, what did you already tried? Maybe also some printscreens? And whrere are you stucked?

I have an idea, how to do this automation, but I am sure, you also did something.

Regards.

Lucie

Re: Data extraction from web

rkumar — Fri, 18 Jun 2021 13:06:19 GMT

input file

Re: Data extraction from web

rkumar — Fri, 18 Jun 2021 13:07:17 GMT

screen where i need to put delivery no and extract data for each delivery no in 1st screen

Re: Data extraction from web

rkumar — Fri, 18 Jun 2021 13:08:29 GMT

i have created work flow ..in this loop is going for all delivery no but data is getting extracted for 1st delivery no ..

Re: Data extraction from web

rkumar — Fri, 18 Jun 2021 13:10:42 GMT

Hello Lucie,

Please look into screenshot and help me..

Re: Data extraction from web

lucie16 — Mon, 21 Jun 2021 07:52:23 GMT

Hi Ritesh,

what about doing it one by one? I did a simple automation, which shows how I mean it (it does not actually work, it needs more steps, it just shows my idea of the workflow). You run "repeat" as many times as you have the number of rows in your excel. And to your automation "purchase order" you input current column. Then you increase index by one and continue until you reach end.

But I think working with "Get values" should also work.
Was this helpful, or you have a problem elsewhere?
Isn't this some sort of exercise or homework? I see another similar question here.

Regards

Lucie

Re: Data extraction from web

rkumar — Mon, 21 Jun 2021 10:08:20 GMT

Hello Lucie

Thanks a lot for your help. It worked for me..

Re: Data extraction from web

rkumar — Mon, 21 Jun 2021 10:19:18 GMT

You can add properties(Input parameter) panel part too. So it will help others too easily