How to get the ID that generated in last 15 minutes

Hi ,

i have scraped a web page now what i need to do is one by one i need to open each one

I am able to open each one but what also i need to check is that all the ID i am opening they should have generated in last 15 minutes

for ID i can assign and use it in for each row but how to check time and then open the Id

same data table

Hi @manoj2500,

Try this…!

Sample File - Copy.xlsx (44.6 KB) getId.xaml (6.5 KB)

Thanks!

@kadiravan_kalidoss

Hi i am doing in this way
got to the webpage
data scrape as its table did it as extract complete table
and followed your xaml
i am getting this error

in row 7 its the time available

please print the string value and ensure whether its in correct time format.

@kadiravan_kalidoss

format is

May 15 , 2020 01:48 PM

can u send me the extracted data in excel, i will try to resolve

@kadiravan_kalidoss

sample excel , one thing that i noted is like first row has header and the second row is empty then after all data is there

today.xlsx (8.3 KB)

Here is the solution,

Main.xaml (10.7 KB)

Thanks Regards
Raj

Enjoy Coding!!!

2 Likes