Unable to extract Sharepoint Site Content

[wilson_cheng (Wilson)]

Hi everyone,

Just wondering if anyone had any success using the table extraction on a sharepoint site? I tried to extract the Document Library in the Site content but can only see 10 results.

there is over 100 Document Libraries in the Site content page but uipath is only able to extract 10.

Any help is greatly appreciated.

regards
Wilson

[Asanka]

Is there a next page button that needs to be clicked?

In your table extract, do you have a max number of results set?

[wilson_cheng (Wilson)]

Hi Asanka,

There is no next page as the content is dynamically locaded. No limit to result set.

I think there is a limitation to extraction on Sharepoint Site.

[Arvind_Kumar1 (Arvind Kumar)]

Are you extracting with sharepoint view ?

[wilson_cheng (Wilson)]

Hi Arvind,

Yes. I’m trying to extract from a sharepoint View. i am trying to get the document Library’s URL

[grkiran2]

Sharepoint loads content when the page is scrolled so you’ll have to keep scrolling to the bottom of the page until all items are loaded.

check this post:

Getting issues with Data Scrapping from Salesforce report - Not able to fetch all rows

I used the same strategy as @Nithinkrishna for a similar website where more rows are displayed when you scroll down. You keep scrolling down and extracting data in a loop until previous extraction rowcount matches the current extraction rowcount. Here is a more detailed explanation: Initialize ExtractDataTable variable using Assign activity. (you need to use the same variable name here and in ‘Extract Table Data’ activity) ExtractDataTable = New DataTable In a Do While Loop: a. Use Assign ac…

With SharePoint, performance takes a hit if you are trying to scroll and there are a large number of documents. check out Office 365 library or SharePoint Custom activities package also published by UiPath

[Arvind_Kumar1 (Arvind Kumar)]

@wilson_cheng ,

I would recommend to use Rest API. So you can get all the details.

Thanks,
AK

[wilson_cheng (Wilson)]

Hi grkiran2,

I understand with Delegation, sharepoint list content is loaded as the page is scrolled. I tried to implement the scroll down mouse activity but it still only captures 10 rows.

I was trying to avoid the Office 365 library activities as I’m told that there is API restriction at the client site and the API cant be used to call the site. Hence I’m stuck with Web Scraping.

[wilson_cheng (Wilson)]

Hi Arvid,

I would love to use the Rest API but was told that It is blocked.