SharePoint Plugin: Appending to Lists

[yashpuranik]

The Dataiku plugin for Sharepoint (https://www.dataiku.com/product/plugins/sharepoint-online/) in its documentation clearly states that appending to SharePoint Lists is not supported.

However, it is clear from https://github.com/dataiku/dss-plugin-sharepoint-online/blob/ef3c6423bb15e8030cf301a5ece097bf7c6dbe6... that the append mode for lists was at least considered if not explicitly tested. Changing the visibilityCondition of that option to True and changing https://github.com/dataiku/dss-plugin-sharepoint-online/blob/ef3c6423bb15e8030cf301a5ece097bf7c6dbe6... from being hard coded to being read from the options in theory allows for appends to work. (And in practice for a couple of quick tests).

My question therefore is what are the risks and caveats of using the append option?

[AlexB · Accepted solution]

Hi !

Version v1.0.15-beta.1 features a new "Append to List" recipe. The plugin can be downloaded from the github repository. Feel free to try it and let us know how it performs.

The main recommendation is to append only to lists that were created to be used with DSS. This way there will be no complication linked to data types that exists on SharePoint and no on DSS.