Question

4
Replies
1961
Views
BhagyashreeC9567 Member since 2018 18 posts
Evoke Technologies
Posted: July 24, 2018
Last activity: September 3, 2019
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 Data Integration
Moderation Team has archived post
Share this page LinkedIn