Microsoft 365: The best recipes for developers

Buy book and subscription
US$45.00 (no VAT)
Buy subscription only
US$35.00 (no VAT)
This book is aimed at developers who want to work programmatically with Microsoft 365, Microsoft’s collaboration and information sharing platform. Microsoft 365 offers a range of servers, including Exchange and SharePoint, as well as editing and authoring tools such as Outlook, Word, Excel, PowerPoint, and many other applications that help businesses create, manage, and organize information.
The book is written for developers who are already familiar with the programming tools and technologies used by Microsoft and Microsoft 365, such as Visual Studio, Visual Studio Code, CSharp, PowerShell, and JavaScript. It assumes that readers already know how the Office applications work, so you won’t find functional descriptions or instructions for users. Instead, the book provides countless code routines and programming methods.
The book is constantly expanding and evolving, thanks to monthly updates. It’s a great resource for developers who want to learn how to work with Microsoft 365 programmatically.
At this moment, the book consists of:
- 1753 pages of content in 21 chapters;
- 1800+ code routines, code fragments, and examples;
- 140+ Visual Studio solutions;
- and covers 12 Microsoft 365 components: SharePoint, Exchange, Teams, Word, Excel, PowerPoint, Outlook, Power Automate, Power Apps, Planner, ToDo, and OneNote.
About the book

Book author

Gustavo Velez pic is a mechanical and electronics engineer who has been working as a software developer and senior solutions architect for more than thirty years. He specializes in the integration of Microsoft software and started working with SharePoint before the server got its current name. In 1998, Gustavo finalized his first enterprise collaboration project using Site Server, the precursor of SharePoint and Microsoft’s first effort at providing a solution to the growing business of Internet-based Document Management and Content Management.
In his many years of experience developing and working with Windows and Office applications, Gustavo has given seminars and training in SharePoint and has also done consultancy work for several of the biggest SharePoint implementations in Europe, Africa, and South America. His articles can be found in many of the leading trade magazines in English, Dutch, German, and Spanish.
Gustavo is the author and co-author of ten books about SharePoint and the founder and editor of CompartiMOSS (, a highly read magazine about Microsoft technologies for the Spanish-speaking community.

Book content

Chapters included in the latest update:

Chapter 01 - Exchange
Chapter 02 - Word
Chapter 03 - Excel
Chapter 04 - PowerPoint
Chapter 05 - Outlook
Chapter 06 - Microsoft 365 APIs and authentication
Chapter 07 - SharePoint APIs and authentication
Chapter 08 - SharePoint Tenant
Chapter 09 - SharePoint Site Collections and Webs
Chapter 10 - SharePoint Lists and Libraries
Chapter 11 - SharePoint Items and Documents
Chapter 12 - SharePoint other components
Chapter 13 - SharePoint Add-Ins
Chapter 14 - SharePoint SPFx
Chapter 15 - Microsoft Teams
Chapter 16 - Power Automate
Chapter 17 - Power Apps
Chapter 18 - Planner
Chapter 19 - To Do
Chapter 20 - OneNote
Chapter 21 - M365 other services

Book updates

Updates for this book version:

Update 02-2024
- Chapter 06 - M365 APIs (part 1)
Update 01-2024
- Chapter 21 - Reporting (part 2)
Update 12-2023
- Chapter 21 - Reporting (part 1)
Update 11-2023
- Chapter 21 - Licensing
Update 10-2023
- Chapter 21 - New Chapter: Microsoft 365 other services
Update 09-2023
- Chapter 06 - Managed Identities
Update 08-2023
- Chapter 01 Full update
Update 07-2023
- Chapters 04 and 05 Full update
Update 06-2023
- Chapter 03 Full update
Update 05-2023
- Chapter 02 Full update
Update 04-2023
- Chapters 19 and 20 Full update
Update 03-2023
- Chapter 18 Full update
Update 02-2023
- Chapter 17 Full update
Update 01-2023
- Third Edition and Chapters 16 Full update
Update 12-2022
- Chapter 11 - Full update (part 2) Modern pages, Provisioning
Update 11-2022
- Chapter 11 - Full update (part 1) Term Store, Search, User Profile
Update 10-2022
- Chapter 10 - Full update (part 2) PowerShell
Update 09-2022
- Chapter 10 - Full update (part 1) CSharp
Update 08-2022
- Chapter 09 - Full update (part 2) PowerShell
Update 07-2022
- Chapter 09 - Full update (part 1) CSharp
Update 06-2022
- Chapter 08 - Full update
Update 05-2022
- Chapter 07 - Full update
Update 04-2022
- Chapter 17 - Full update
Update 03-2022
- Chapter 01 - Full update
- Chapter 06 - Full update
- Chapter 15 - Power Automate and the CLI for Microsoft 365
- Chapter 16 - Power Apps and the CLI for Microsoft 365
Update 02-2022
- Chapter 14 - Managing the Teams Toolkit with the TeamsFx CLI
- Chapter 18 - Planner using the PowerShell PnP
Update 01-2022
- Chapter 20 - New Chapter: OneNote
Update 12-2021
- Chapters 14/18/19 - Using the CLI for Microsoft 365
Update 11-2021
- Chapter 14 - Managing Teams with PnP PowerShell and Microsoft Graph
Update 10-2021
- Chapter 06 - Using the new PnP Framework and PowerShell
Update 09-2021
- Chapter 03 - The Excel Office Scripts
Update 08-2021
- Chapters 12/14/17/18/19 - The Graph Toolkit
Update 07-2021
- Chapter 19 - New Chapter: To Do
Update 06-2021
- Chapter 12 - SharePoint SPFx, Full update
Update 05-2021
- Chapter 14 - Microsoft Teams, Full update
- Chapter 17 - PnP to access Graph
Update 04-2021
- Chapter 11 - PnP Provisioning
Update 03-2021
- Chapter 11 - SharePoint Site Scripts and Designs
Update 02-2021
- Chapter 06 - Working with the CLI for Microsoft 365
Update 01-2021
- Chapter 18 - New Chapter: Planner
Update 12-2020
- Chapters 08/09/10 - Working with Microsoft Graph in SharePoint
- Chapter 17 - Microsoft Graph PowerShell cmdlets
Update 11-2020
- Chapter 06 - Using the .NET Standard framework (.NET Core)
- Chapter 06 - Login (PowerShell) with PnP to use REST
- Chapter 11 - Working with SharePoint modern pages
Update 10-2020
- Chapter 03 - Working with Microsoft Graph in Excel
Update 09-2020
- Chapter 01 - Using Microsoft Graph for Messaging
- Chapter 17 - Querying Graph with MSAL and CSharp
Update 08-2020
- Chapter 17 - New Chapter: Microsoft Graph
Update 07-2020
- Chapter 10 - Working with attachments (CSOM, REST, PowerShell)
- Chapter 14 - Skype for Business cmdlets to work with Teams
- Chapter 16 - Power Apps tools
Update 06-2020
- Chapter 01 - Using EXO V2 PowerShell cmdlets for Exchange
- Chapter 09 - Working with Columns (CSOM, PnPCore, REST, PowerShell)
- Chapter 15 - Connector Browser Tool and connectors for PowerShell
- Chapter 16 - Connector Browser Tool and connectors for PowerShell
Update 05-2020
- Chapter 06 - Login in SharePoint using Multi Factor Authentication
- Chapter 06 - Using RestSharp to execute REST commands
- Chapter 10 - Working with Folders (CSOM, PnPCore, REST, PowerShell)
First edition (04-2020)
- First release

Book roadmap

This is the content enhancement that you can expect with the next updates:

Monthly updates - (Each update) Updates released by Microsoft
OneDrive chapter - Developing with OneDrive
Delve chapter - Developing with Delve
Visio chapter - Developing with Visio
Power BI chapter - Developing with Power BI
Office Administration chapter - The Office Administration APIs
SharePoint external communication - External Event Handlers and WebHooks
Azure related to M365 chapter - Azure Active Directory, Azure Functions

Download the sample chapter

You can download one sample chapter for free. The example is taken from the first version of the book (April 2020).

See the sample chapter OnLine

You can see also the sample chapter OnLine as HTML. The example is taken from the first version of the book (April 2020).

See the sample book OnLine
icon This book is one of the many published by Güitaca under the mantra ‘Books by Subscription’. The book is designed to keep readers updated with modern technologies, especially cloud software, which evolve at a very fast pace. Güitaca achieves this by publishing books that progress at the same speed as the technology.

Book and Subscription, Book Only and Subscription
You can purchase the Book and Subscription or enhance your book with the Subscription at any time. When you buy the Book and Subscription, you get the latest updated book and a subscription for 12 updates. When your subscription expires, you can renew it using your book registration, purchasing only the subscription part. Every four to five weeks, you will receive the updated book, which includes:

Changes, modifications, and additions
made by Microsoft to the technologies explained in the book.

New content.
We are aware that the book will probably never comprise every aspect of Microsoft 365. Also, we do not have the arrogance to say that the author knows everything about the suite. But we can ensure that we are constantly aiming at making the content as complete as we can.

Access to the source code repositories.
Although the source code is published in the book, when you are programming, it is very handy to be able to test and copy the code directly from the Visual Studio solution.

Support from the author.
If you have any questions about the book or the published code, just let us know ( and we will try to help you as soon as possible.

This book is an excellent resource for developers who want to stay up-to-date with the latest technologies and learn how to work with Microsoft 365 programmatically.