Tables
The add-in models the data in Microsoft Office 365 as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Microsoft Office 365 Tables
| Name | Description |
| Calendars | Provides details about calendars associated with users, including names, time zones, and ownership metadata. Maps dynamically to the API fields. |
| Contacts | Contains user contact records, including names, email addresses, job titles, and business phone numbers synced from Office365. |
| Conversations | Stores threaded conversations from Microsoft 365 Groups, including messages and participants. |
| Events | Captures core details of calendar events, such as start and end times, locations, organizers, and recurrence rules. Maps dynamically to API fields. |
| Files | Lists files stored in OneDrive or SharePoint, with metadata including file names, locations, last modified times, and sharing status. |
| Groups | Includes metadata about Microsoft 365 Groups, such as group names, descriptions, email aliases, and visibility settings. |
| Messages | Contains email messages from user mailboxes, including subjects, senders, timestamps, and read status. |
| Tasks | Lists individual tasks from Microsoft To Do or Planner, with details like titles, due dates, and completion status. |
| Users | Supports reading, creating, updating, and deleting Office365 user accounts. Includes profile and licensing details. |