MS Outlook & Teams Integration

Show and Tell
1

Hey everyone,

Just wanted to share a quick API integration with the community. For some reason I always find it exciting when I see how fast and easy it is to connect Tulip with some of the other tools we like to use. Here is an example of Tulip connecting with Outlook for a resource scheduling application.

outlook integration 2
outlook integration 22706×1472 1.79 MB

Happy building!
Mark

8 Likes
2

Hi, how can we use this API?

3

This is using the microsoft graph API to pass information back and forth between Tulip and Outlook

1 Like
4

Thanks for the information @freedman, I am new at using APIs, I am able to connect to my own tulip tables but not sure how to link to my outlook calendar.

Is it possible to connect to outlook.office.com ?

5

Connecting to graph is a little more involved (but not much!) because we need to figure out how Microsoft recognizes who you are (authentication) and how they want you to communicate with them.

Luckily, they’ve built a tool to simplify this a bit and help people play around.

It is called the “graph explorer” and it lets you use a web browser to tinker around with the API before adding it to your projects.

First, sign in with your microsoft account:

image
image1520×539 44 KB

Then scroll down and look at the endpoint options and click on one:

image
image376×732 18 KB

It will automatically populate the endpoint information at the top of the screen and display results at the bottom.

image
image1133×935 39.8 KB

This should be able to get you started. Once you are confident you know how to get the information you want out of the API, the next step is to set it up with Tulip by allowing the Tulip connectors to run the API calls.

2 Likes
6

Hello Mark,

Your post is very inspiring and I can see unlimited use cases by linking Tulip and Microsoft.

I played a bit with the Graph Explorer you presented in your post (my admin consented to the relevant permissions to run the queries). I’m now trying to set my connectors/function within Tulip.

I thought I was successful but the access token I copied from graph explorer expired . Could you give me some clues on how to manage the authentication ? (Gio mentioned to me to request a token with another connector)

Thanks by advance for you help !

7

Thanks for the kind words! I’m glad that you found this helpful. I may not be the best person to answer this since I’m admittedly pretty bad at authentication and things like that, however, the basic gist of it is:

  • Set up one connector that will connect to microsoft’s generic API as shown in the image below. That may or may not be the correct endpoint for your specific network / infrastructure but it should be something like the image.
    image
    image1147×559 17.6 KB
  • When you send in the client id, scope, secret, and grant type you will have the token that you can use in your ‘real’ connector.

Then you just set up some app logic so that it can check if the token is expired and grab a new one.

Does that help?
Thanks
Mark

8

Hello Mark,

I continue to work on this topic, fresh start in 2021 :smiley: I will show you my progress below:

First connector:

image

So far I found information as following:

tenant ID : found in https://portal.azure.com/, in overview of application

Request Body:

I also gave (with the consent of my Microsoft admin) the API permissions:
image

I got some ideas of permission from the graph explorer (Graph Explorer - Microsoft Graph) :

image

This first connector is running without error and I get a token :smiley:

Second connector:

If I copy manually the token from my first connector in my second connector I still get an error.
image

I’m wondering if you use a different OAuth ? I see in support admin/operator/bearer token. I will ask for this feature if it’s necessary.

All the best !

9

Sorry for the delay - please take a look at this article and let me know if it helps

Also, please send me a PM of your instance name and I’ll enable a feature flag for you. Thanks!

10

I would like to connect Tulip to MS Team
Use Case: Chat with a person

I did the above mentioned steps and received the Access Token.
Used this Access Token as a authentication-bearer token to POST the message using Tulip Connector.
In order to send a chat message, I tried the URL in Graph API and received 200ok and the message is sent to the destination, but failed when tried with Tulip connector.- got 412 error while trying to post message to that specific ID

API failed
API failed1909×748 52 KB

Could you please help me out on this!!