Microsoft Office is a powerful productivity suite that provides users with very capable, yet generic tools. With the Office JS API, you can build Office Add-ins that automate and integrate Office with your applications.
John Brown is a Software Craftsman continually looking for intuitive
designs, agile architectures, and streamlined processes. With degrees in
Computer Science from Johns Hopkins and Aerospace Engineering from Purdue,
John is always up for a challenge, especially in his areas of interest in
Artificial Intelligence and Machine Learning.
External Communications Hello, this is John Brown. In this module we are going to learn about how to communicate with an external resource. Some aspects are very straightforward with communicating with external resources, while others require a more thorough understanding of the hosting model. In the previous module, we took a look at building a PowerPoint add-in that communicated with Trello, however, instead of using a connection to Trello we used a sample data service so we could focus on working with PowerPoint and the documents. In this module, we are going to look at how to take that sample and have it communicate with Trello. As a reminder, let's walk through the process. Trello provided the Kanban boards with agile cards that are used to track and manage the work for a team. You have a presentation you'd like to give on your progress, and you just need the list of cards for your project added to your PowerPoint deck. The add-in we create will do the work. To accomplish this work, you'll want to connect to Trello and request some data from the API. I will use Google as my OAuth provider to Trello so Trello will redirect to Google and request credentials. Google will than pass my authentication token to Trello, as well as a few other claims. Eventually, Trello will return back the list of cards to the add-in, and then after we have the data we'll use the reference to the document to write the list of cards into the PowerPoint deck. Let's start by understanding what we mean by external communication.