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 | This table is dynamic and maps to the corresponding field in the API. |
Contacts | The Office365 table Contacts. |
Conversations | The Office365 table Conversations. |
Events | This field is dynamic and maps to the corresponding field in the API. |
Files | The Office365 table Files. |
Groups | The Office365 table Groups. |
Messages | The Office365 table Messages. |
Tasks | The Office365 table Tasks. |
Users | Read, Insert, Update and Delete a User. |