Skip to main content
Question

Sharepoint list reader returning 401 error "request exceeds the configured maxQueryStringLength"


ecx
Contributor
Forum|alt.badge.img+4
  • Contributor

Hello,

I am using a Sharepoint List reader to expose all hidden fields and show all fields. This usually works for me but not for this specific list. This list is very large, has views and hidden fields. 


 

The errors:
1) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <…..>' returned from SharePoint. Error message was: '' 

2) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <.….> returned from SharePoint. Error message was: '' 


The query (url) generated by FME (which I’ve removed from the errors above), is 2300 characters long. When I click this URL it takes me to a blank page with the message:



I have found this:
https://learn.microsoft.com/en-us/dotnet/api/system.web.configuration.httpruntimesection.maxquerystringlength?view=netframework-4.8.1

which I believe is not relevant to sharepoint online, but sharepoint when on-prem (I believe am using sharepoint online) - but it seems to match the error message I am getting. I have tried creating other sharepoint list readers with the same parameters (show all hidden fields and show all fields) to other lists which are smaller, and those work. 


Does anyone have any ideas how to resolve this?

 

4 replies

crutledge
Enthusiast
Forum|alt.badge.img+32
  • Enthusiast
  • April 17, 2025

Hi ​@ecx 
Can you break the table up? Ask sharepoint for fields 1-20 and then ask for fields 21-40….etc. Can you get a list of all the fields? Or am I missunderstanding?

If you can pull the table in parts then put back together that might work for you.


ecx
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • April 21, 2025
crutledge wrote:

Hi ​@ecx 
Can you break the table up? Ask sharepoint for fields 1-20 and then ask for fields 21-40….etc. Can you get a list of all the fields? Or am I missunderstanding?

If you can pull the table in parts then put back together that might work for you.

Hello,

 

I've had a look at the settings in the SharePoint list reader but I can't seem to find any setting where i can specify which specific fields i want to extract, it's either all visible fields or visiable fields and hidden fields (unless I'm missing something)

 

Thanks


crutledge
Enthusiast
Forum|alt.badge.img+32
  • Enthusiast
  • April 21, 2025

@ecx Ah. I get it now. You are getting an error on the SharePoint reader. It won’t even read the SharePoint list without an error. I was thinking split of the table but you have to read it first right?


ecx
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • April 23, 2025
crutledge wrote:

@ecx Ah. I get it now. You are getting an error on the SharePoint reader. It won’t even read the SharePoint list without an error. I was thinking split of the table but you have to read it first right?

Yeah, when I run it - I’m getting the error above, and no data at all. :(


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings