How to extract the status of URLs in Excel and get the out put excel with status codes


#1

Im Trying to extract URLs Status from Excel and print it in to excel files with two columns (“Urls, Status”) . But unable to pass variable to Endpoint in Http Activity. Http.zip (82.7 KB)

If possible pls provide us the sample.


#2

Hi @vickyms57,

i have modified you code, please check it.
Sample.xaml (13.6 KB)

Regards,
Arivu


#3

@arivu96 thanks,

But i’m unable to pass each URL in to Http Activity, i need to get the status of URLs in the excel. Please help.

.


#4

Hi @vickyms57,

Use this xaml file.
Sample.xaml (13.5 KB)

Regards,
Arivu :slight_smile:


#5

@arivu96,

Thank So much


#6

Hi @arivu96,
Can you please help me in solving the below issue.
I’m trying to scrape unstructured data from list of URLs and extract to excel with separate columns, but im able scrape only one block of data. Please help attached code.sample.zip (295.1 KB)