Please consider adding defender data to the 365 plugin. https://learn.microsoft.com/en-us/microsoft-365/security/defender-endpoint/exposed-apis-list?view=o365-worldwide

It would be extermely useful to Steampipe to query and produce a list of all our laptops vulneraiblity status.

Rename the plugin and tables from Office 365 to Microsoft 365 - it’s consistent with Microsoft’s announcement + new branding

Describe the bug
Some of the tables (i.e. drive, calendar, contact) are failing if the queried resource is not present.

Steampipe version (steampipe -v)
Example: v0.17.4

Plugin version (steampipe plugin list)
Example: v0.0.1

To reproduce
Query any resources which is not present.

Expected behavior
Query should return empty row, if the resource is not present.

Additional context
Add any other context about the problem here.

For my microsoft365_via_sp_secret: I want to my application to access only the data of the signed-in user and not allow access to the data of other users, I need to use delegated permissions instead of application permissions. Application permissions typically grant access to all users in the organization, while delegated permissions are tied to the signed-in user's content.
when I use deligated permission it's not working, when I use application permissions, it's worked for me. Is there any other solution for this? deligated permission is supported or not?????

Is your feature request related to a problem? Please describe.
While using tenant/client_secret authentication mechanism, if you give a wrong client_secret in the config file and then try to run queries, you get a vague error message that does not describe what the error is.

Eg:

> select
  name,
  id,
  drive_type,
  created_date_time,
  web_url
from
  microsoft365_drive
where
  user_id = '[email protected]';

Error: null (SQLSTATE HV000)

+------+----+------------+-------------------+---------+
| name | id | drive_type | created_date_time | web_url |
+------+----+------------+-------------------+---------+
+------+----+------------+-------------------+---------+

Describe the solution you'd like
If authentication fails, I'd like to see that error message show up when I run the queries.

Describe alternatives you've considered
None.

Additional context
Versions:

Plugin version: v0.0.1
Steampipe CLI: v0.17.4

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.

Is your feature request related to a problem? Please describe.
Tables should handle limit and adjust page size as an optimization. All tables should also set the largest page size by default to reduce the number of requests.

Describe the solution you'd like
See above.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.