This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I am trying to upload an excel file with 2086 rows and 118 columns using a SharePoint List Output tool with "Delete List and Append". It is definitely connecting to the SharePoint because all of the data is being deleted. However, it is not uploading a single cell, and this error occurs: "Error: SharePoint List Output (3): An error occurred while writing record. Record was partially written. Check List in SharePoint." Any thoughts on what could be causing this?
We made sure the data types all matched up using a Select tool. We also tried doing the same uploading with only 1 column and 100 rows and the same error occurred. It only didn't occur when we had 1 column and 2 rows of data.
Please let me know if you need any more information, and have a great day!
I troubleshot with Alteryx Support and here is where we left off (see below). In sum, a batch macro might help because if the data set is too large, it won't work. Hopefully this helps!
Thanks for the trace. This definitely includes what we're looking for!
I believe I see the issue here, and it's possible that it might be something in the tool itself. We're seeing a POST to the SharePoint SOAP API at around ~20MB in size. From my research on your Fiddler trace, it seems that the SharePoint SOAP API is only allowing a maximum of ~2MB to be POST'ed at once.
I'll need to escalate this issue up with our development team to see if this is an issue with how the tool is handling data or if this is some sort of environmental setting in SharePoint that may be limited in your specific environment.
The only thought I have at the moment for a workaround would be to place the SharePoint Output tool inside of a batch macro and set it to batch a certain number of records at once (so we stay below this limit). Do we know if a small number of records has allowed this to function? The downside to this configuration is that the insert will likely take longer, but it should at least allow us to push the data.
Yes POST-ing to SP is super annoying and 2MB sounds about right from my prior research into SP update issues.
However, my current workflow fails on the 1st of only 11 records that have only 3 fields. That's no where near the 2MB limit. I am using the delete and load functionality, but it seems to write the first 3 records fine, but then fails after writing the 3rd field. So weird!