Background: https://www.reddit.com/r/Office365/comments/y3vfx7/use_sql_to_query_microsoft_365_drive_files_mail/
Id like to see permissions lists and their contents Libraries and their contents (file names,size,id,created and modified by and dates) List of Sites
Graph API Docs;
https://learn.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0
https://github.com/microsoftgraph/msgraph-sdk-go supports Sites and Lists, and additional Drive information that could be considered below.
For Sites
https://learn.microsoft.com/en-us/graph/api/resources/site?view=graph-rest-1.0
Also for the request to look are permission lists -- these are for the DriveItem but in the Sites resource: https://learn.microsoft.com/en-us/graph/api/resources/permission?view=graph-rest-1.0#:~:text=permission%20resource%20type Not clear on the best way to represent it on the site table, drive resource, or its own table.
For Lists
https://learn.microsoft.com/en-us/graph/api/resources/list?view=graph-rest-1.0
For Drives:
Believe https://hub.steampipe.io/plugins/turbot/microsoft365/tables/microsoft365_drive captures Drives information but can be extended for more relationship data:
The table already supports the documentType column would provide whether its a documentLibrary value. Maybe helpful to add the column SharepointIds for additional relationship information: https://learn.microsoft.com/en-us/graph/api/resources/drive?view=graph-rest-1.0#:~:text=%20%22sharepointids%22%3A%20%7B%22%40odata.type%22%3A%20%22microsoft.graph.sharepointids%22%7D%2C%20
Note: On the Site table there will be relationships for the Drive used as well so you can get both angles of the relationship.
Background: https://www.reddit.com/r/Office365/comments/y3vfx7/use_sql_to_query_microsoft_365_drive_files_mail/
Id like to see permissions lists and their contents Libraries and their contents (file names,size,id,created and modified by and dates) List of SitesGraph API Docs;
https://learn.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0
https://github.com/microsoftgraph/msgraph-sdk-go supports Sites and Lists, and additional Drive information that could be considered below.
For Sites
https://learn.microsoft.com/en-us/graph/api/resources/site?view=graph-rest-1.0
Also for the request to look are permission lists -- these are for the DriveItem but in the Sites resource: https://learn.microsoft.com/en-us/graph/api/resources/permission?view=graph-rest-1.0#:~:text=permission%20resource%20type Not clear on the best way to represent it on the site table, drive resource, or its own table.
For Lists
https://learn.microsoft.com/en-us/graph/api/resources/list?view=graph-rest-1.0
For Drives:
Believe https://hub.steampipe.io/plugins/turbot/microsoft365/tables/microsoft365_drive captures Drives information but can be extended for more relationship data:
The table already supports the documentType column would provide whether its a documentLibrary value. Maybe helpful to add the column SharepointIds for additional relationship information: https://learn.microsoft.com/en-us/graph/api/resources/drive?view=graph-rest-1.0#:~:text=%20%22sharepointids%22%3A%20%7B%22%40odata.type%22%3A%20%22microsoft.graph.sharepointids%22%7D%2C%20
Note: On the Site table there will be relationships for the Drive used as well so you can get both angles of the relationship.