SharePoint Plugin: Appending to Lists

Options
yashpuranik
yashpuranik Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2022, Neuron 2023 Posts: 69 Neuron

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?

Tagged:

Best Answer

  • AlexB
    AlexB Dataiker Posts: 67 Dataiker
    Answer ✓
    Options

    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.

Setup Info
    Tags
      Help me…