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

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?

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

We’re seeing the same error with a large list and managed to narrow the limit down to 2170-2173 characters (a request of 2169 characters worked, while 2173 did not).

Did you manage to find a workaround?

Interesting, maybe the character limit isn't exactly 2048, or maybe thats just a red herring. I spoke to the sharepoint admin at my company and did not get an answer, nor could find any solution myself.

I ended up using a 3rd party SSIS package which would connect to SharePoint instead. I would not recommend it, as since then I’ve used powershell PNP to extract data from sharepoint lists, which works much better and is much quicker to set up.