Skip to main content

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?

 

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.


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


@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 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. :(