Sharepoint metadata

ahmed_dataiku_user
ahmed_dataiku_user Registered Posts: 3

Hello,

Wanted to know how to get the "modified by" column on dataiku using my sharepoint connection? at this point in time i have the size and the modified time

Thanks,

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,352 Dataiker

    Hi,

    "Last modified by" metadata is not available for SharePoint datasets.

    You can submit a feature request via support or Idea https://community.dataiku.com/categories/product-ideas/p1

    Also, can you explain your use case a bit more?
    What would you do with this information?
    Where would you like to see this metadata, in the managed folder view, list folder recipe, enrich with file information, and prepare processors?

    Thanks


  • ahmed_dataiku_user
    ahmed_dataiku_user Registered Posts: 3

    My use case is more to do with getting the user who actually uploaded the dataset on the sharepoint. I would use it to track if that dataset becomes dormant and go back to the appropriate user to see if this dataset is even required anymore or not.

    I would like to see this on the managed folder view.

    Was having a look at the repo, is there a way I could adjust the connector myself and have a go at it?

    Thanks ,

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023, Circle Member Posts: 2,591 Neuron

    This is available in the Microsoft Graph API so you solve this problem using that API:

    https://learn.microsoft.com/en-us/graph/api/driveitem-get?view=graph-rest-1.0&tabs=http#response-1

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,352 Dataiker

    Thanks for submitting the product idea.
    Adjusting the sharepoint plugin code and retrieving this metadata from Sharepoint APIs wouldn't fully address your need, if you want to see in the managed folder view that would require DSS to be aware of this additional metadata and display currently only last modified/size is supported.

    If you want to just create a dataset with this information you could leverage the APIs as suggested already to retrieve this information.

Setup Info
    Tags
      Help me…