'str' object has no attribute 'get' error with using Sharepoint Output tool

[rfoster7]

We are trying to implement the SharePoint and OneDrive input and output tools for our company and having nothing but problems. After months of work we finally got them partially working. 

I can now connect to and write through a SharePoint Output tool. But now I'm getting the following error. 

When Writing a dataset of about 1.1 M rows to a CSV delimited file, it consistently writes 149311 rows, then stops with this error. Here is the error log:

any ideas what this is? Is there some undocumented limit on how many rows it can write?

Is it choking on something in the data?

I made sure to size all the columns less than 254 in size and looking at the data in row 149311, there is nothing remarkable or different about it.

Just to test, I threw a sort in front of the output and resorted it to put the data in a different order (so it wouldn't be writing the same row of data to that row) and it DID switch to a different row count, so it would seem to be something in that particular row of data. However the row it chokes on after the sort (consistantly) is NOT the same row it chokes on with the prior sort. And there is nothing unique or interesting about either row of data. 

Anybody have any ideas? 

[Justin_B]

I'm having the same error message from the SharePoint output tool. I can write only 40,753 rows of data with 63 columns.

I reran the same dataset limiting it to only 40,000 rows and ran with no error. Is there a file size limitation with the SharePoint output tool?

Running Server & Designer version 24.1 and SharePoint tools version 2.6.0.

[Justin_B]

Follow up to my last post. I generated 3M rows and tried to write to SharePoint. Could only write 1.66M rows before the error.

Any ideas how to prevent this from happening?

[geordie986]

Has anybody figured out a solution to this?
I run in the same error trying to write 350'000 rows (7 columns of mostly short text), but only 240'000 gets written.

Working with SharePoint in Alteryx has been proving to be extremely painful and time-consuming so far...

[rfoster7]

Nope. We have upgraded through all the interim builds of the tool provided, and still not fixed. Not great product support. 

[geordie986]

Thanks @rfoster7  , disappointed to hear that 

[_wlm_horton]

It seems to be related to file size more than row count. I can't get it to write an Excel file larger than 15MB regardless of row or field count.

[_wlm_horton]

@Justin_B It seems to come down to file size.

[Justin_B]

@_wlm_horton What version of the SharePoint Input tool are you using? I moved from 2.6.0 to 2.6.1 and no longer experience the issue.