dataiku/dss-plugin-sharepoint-online

Dataiku DSS plugin to interact with your lists and documents stored on Microsoft SharePoint Online

SharePoint Online Plugin

This Dataiku DSS plugin provides a read / write connector to interact with documents stored on SharePoint Online.

Documentation: https://www.dataiku.com/product/plugins/sharepoint-online/

Licence

Copyright 2020-2022 Dataiku SAS

This plugin is distributed under the Apache License version 2.0

dss-plugin-sharepoint-online's Issues

granting permission at SiteCollection not Tenant

I am trying to enable this plug-in using a client id established at the SiteCollection level instead of Tenant level; I established this permission using: "http://sharepoint/content/sitecollection" Right="FullControl" instead of what your documentation specified which was http://sharepoint/content/tenant Right="FullControl"

can you please let me know if there is a way to using a site collection client id security instead of the tenant-level security?

Can't select expand lookup or metadata fields.

I'm seeing an issue where the metadata fields and lookup fields are just shown as blank when I run the build. I also don't see any option on the UI to change the expand_lookup value or the metadata fields to bring in. I tried messing with the variable overrides and I may switch to a dev plugin to see if i can mess with the JSON connector file. It seems like those two options aren't being shown through the connect UI.

DSS SharePoint Data Plugin only synching schema but not data

Hello Dataiku team,

Hope everyone is well. Our team is trying to leverage this DSS SharePoint plugin. We can successfully connect to an existing list on SharePoint and bring the data into DSS. However, when we try to write a new list to the SharePoint site we are only able to sync over the schema. The schema is correct, however, none of the rows actually sync to the list on SharePoint.

Can anyone help us resolve this challenge? We're not sure if any additional steps are needed to sync over the actual content and not just the schema. Any additional information on the above is greatly appreciated, thanks!

Best,
Kathy

Create secret not working. Login option 3

Hi,

Option 3 is unfortunately no longer usable due to the deprication of a function by Microsoft.
https://www.dataiku.com/product/plugins/sharepoint-online/
MS info:
https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/retirement-announcement-for-azure-acs

Are there any alternative ways we can use the sharepoint integration or will this be the point at which we can no longer use it?
Options 1 and 2 are not practicable for our company (MFA).

Potential issue with date / time formats in lists

Encountered an issue importing from a Sharepoint List where column is using a 'Date and time' Type, but 'Include Time' setting is set to 'No'.

In this scenario dates are parsed incorrectly with the day appearing as the month and vice versa, for cases where this logic fails it does not parse at all. Once the 'Include Time' setting is changed to 'Yes' the issue is resolved and all dates are parsed correctly. Examples as below:

• 06/09/2023 > 2023-06-09T00:00:00.000000Z
• 19/09/2023 > 19/09/2023

Allow custom base url

My organization is using teamsite.<tenant>.com instead of normal <tenant>.sharepoint.com. Hence, when I tried to connect it returned following error:

Test failed: Failed to initialize kernel : <class 'robust_session.RobustSessionError'> : Error on attempt #5: HTTPSConnectionPool(host='teamsite.<tenant>.sharepoint.com', port=443): Max retries exceeded with url: /sites/<mysite>/_api/contextinfo (Caused by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x7f219f728320>: Failed to establish a new connection: [Errno -2] Name or service not known',))

I suggest to not automatically append .sharepoint.com at the end of the tenant

dss-plugin-sharepoint-online/python-lib/sharepoint_client.py

Line 136 in f7a9ef9

self.sharepoint_url = tenant + ".sharepoint.com"

error: Preset does not exist

I am now having an issue where the plug-in works well enough to read a sharepoint list using a preset 'gsdscplm_buffer_lists'; although, I am now getting this error when trying to use Sync or Prepare recipe: [ERROR] [dku.input.push] - Push failed, cleanup resources
java.lang.IllegalArgumentException: Preset gsdscplm_buffer_lists does not exist any ideas how to resolve this?