Question

4
Replies
2117
Views
 Bhagyashree Choudhary (BhagyashreeC9567)
Evoke Technologies

Evoke Technologies
IN
BhagyashreeC9567 Member since 2018 18 posts
Evoke Technologies
Posted: July 24, 2018
Last activity: September 3, 2019
Posted: 24 Jul 2018 0:23 EDT
Last activity: 3 Sep 2019 11:24 EDT
Closed

SharePoint Integration in Pega

Hi Folks,

Our requirement is to integrate with the SharePoint Knowledge Base to read and write data.
I see that there is a component available for this where the basic structure for reading, writing, deleting folders, files and list items in SharePoint is present.
However, we are facing an issue. There is a THRESHOLD LIMIT enforced for the system administrator for 5000 records.
The list we are trying to retrieve has more than 15000 records. We aren't able to fetch all the records or query them. It gives us the following error:

Microsoft.SharePoint.SPQueryThrottledException

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.
How can we fetch all these records? Indexing doesn't help. There is no way we can have the threshold limit changed.
Is there a way to dump all the SharePoint Data in Pega at once? Is there a way where we can iterate through the list and get all records?
Please suggest.
Bhagyashree
Low-Code App Development Data Integration Java and Activities
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 6 Dec 2018 3:15 EST
Sasivengatesh Mohanasundaram (SasivengateshM)
Bank of America

Bank of America
IN

Hi Team,


I have a SharePoint On-premises site and wanted to integrate with Pega. The above attachment by name shows that it is for SharePoint Online. Could anyone please tell me if I can use the same for integrating SharePoint On-Premise site also with Pega. Quick response would be appreciated. 


Thanks,


Sasi