SharePoint Plugin: Appending to Lists
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/ef3c6423bb15e8030cf301a5ece097bf7c6dbe6a/python-connectors/sharepoint-online_lists/connector.json#L132 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/ef3c6423bb15e8030cf301a5ece097bf7c6dbe6a/python-connectors/sharepoint-online_lists/connector.py#L32 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?
Best Answer
-
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.
