search

dataiku / dss-plugin-sharepoint-server

A connector to Microsoft SharePoint server
Apache License 2.0
0 stars 0 forks source link

Unable to view calculated fields or modified date fields from SharePoint List #8

Open gradebg96 opened 3 years ago

gradebg96 commented 3 years ago

Hello, is this plugin pulling data from the Default view in Sharepoint or somewhere else? I am unable to see system generated fields (like Modified Date) or Calculated fields in Dataiku upon connecting. Selection fields, text, and number fields work fine. Would this be a configuration error?

alexbourret commented 3 years ago

Hi, Sorry for the wait... The v1.0.3-beta.1 should let you access fields such as Creation Date, Modified Date, Created by and Modified by. The calculated fields should be visible when Expand lookup fields is ticked. lookup_fields Please let us know if you are still experiencing any issue.

gradebg96 commented 3 years ago

Fantastic, we'll install the beta and see if any issues

alexbourret commented 3 years ago

Hi @gradebg96 ! Did this beta fix your calculated field issue in the end ? Did you experience any issue with this version of the plugin ?

gradebg96 commented 3 years ago

Hello Alex, thank you for coming back. Finally got this setup in prod just recently. So far I'm able to see the calculated fields now and the date metadata fields. I'm not able to see data in any fields that indicate a person, such as "modified by". I'll check again shortly as I'm not sure if this is a configuration issue on our side or not yet

gradebg96 commented 2 years ago

Hello @alexbourret I've had my team now verify they are unable to see "People". We can now see calculated fields and dates correctly, but company users aren't showing up. This means if we create a sharepoint field for an Approver, as an example, that name shows up Blank in DSS. Similar to the metadata for Created By or Modified By, we can we when it was modified (date), but not who it was modified by (user).

alexbourret commented 2 years ago

Hi @gradebg96 ! Can you confirm that you are using the 1.0.3 beta version, and the settings for the dataset are similar to what's on the screenshot ? sharepoint_server (expand lookup fields activated, and Modified by selected)

gradebg96 commented 2 years ago

Yes correct. The fix has worked for the dates and calculated fields, but not for people (or lookup values)