How to have a bot read from url

Help Studio
1

Hi, I have a url share point that i need the bot to read to add to queues . How do i get the bot to read from an url instead of an excel sheet. Please help thanks

2

Hi,
Do you have excel files in sharepoint? are you trying to read excel directly in sharepoint?

3

@Sira,

That’s not feasible at least as of now. You should have excel file to read from.

Thanks,
Ashok :slight_smile:

4

No i dont have an excel its just data from the share point

5

I have an url site that needs the documents but those documents are in the queue.

6

You don’t “read from a URL.” You would use UI Automation to browse to the URL and then do the steps (ie clicking and typing, reading the text of screen elements, etc) to do what you need.

I suggest doing the free training at academy.uipath.com as it will teach you these things.

Also, if you’re working with Sharepoint there are activities specific to that for reading/updating data:

7

Yes but if the site is always changing adding information that has to be in added to the queue each time. Are you saying do this way? I am unable to use the sharepoint activites its blocked

8

I created an automation that will read from a sharepoint list and create queue items. Here is how we manage it:

The list has a true/false (checkbox) field named ProcessedByBot, and we have a list view named BotView that filters out records where ProcessedByBot is true. The automation will go to the list (make sure the URL is to the BotView view), select the first item, click edit, scrape the data from the form, check the ProcessedByBot checkbox, save the item, then go back to the list and start over. This way, each time it goes back to the list the last item has disappeared because ProcessedByBot is now true.

9

Thank you sharepoint list did you use get list info ?or get list items

10

You said you can’t use the Sharepoint activities. Those are Sharepoint activities. I didn’t use Sharepoint activities, I used regular UI automation activities to browse to the list, select the first item, get its data, and mark it processed.

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.