First Microsoft Graph API integrations available on the DX!

[ewilson]

Hi Folks,

Just a heads-up that we've added our first 3 Microsoft Graph API integrations to the DX:

Microsoft Graph for Excel
Microsoft Graph for OneNote
Microsoft Graph for Users

Next, we'll be working on integrations for SharePoint, Teams, and Outlook.
 
Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[ewilson]

@AP.Philippa,

It's undergoing technical and marketing review now. I hope to see it fully published by the end of this week.

Cheers,
​

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[JerinJose]

great news Eric,
i'm waiting for Outlook,

because of  EWS and its outdated Authentication library, security team is running behind me lol

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
*"If you find this post helpful mark it as best answer, .*
------------------------------

[ewilson]

@JerinJose the Microsoft Graph API for Outlook integration is already available on the DX. You can find it here.

Cheers,
​

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[RyanMatuszewski]

@JerinJose I will be releasing an update to the Outlook API hopefully in the next 2 weeks, allowing for more flexible JSON body payloads and authentication.  Hit a real "Aha" moment ​with Sharepoint that I think will help.

------------------------------
Ryan Matuszewski
Senior Developer Consultant, Digital Exchange Partner Integrations
Blue Prism
------------------------------

[BenMcNicol]

Hi Ryan,

Really enjoy using the Outlook API 🙂

Are there any plans to add some of the following actions?

Move Email Between Folders
Set Flags
Set Tags
Mark As Read
Get Attachments
Send Attachments

Regards,

Ben

------------------------------
Ben McNicol
Developer
Bunnings
Australia/Melbourne
------------------------------

[RyanMatuszewski]

Hi Ben,

I should be able to add most of those actions in as well as the more flexible json payloads.
Will have to look at the Set Flags/Set Tags.

Thanks,
Ryan

------------------------------
Ryan Matuszewski
Senior Developer Consultant, Digital Exchange Partner Integrations
Blue Prism
------------------------------

[Mat]

Hello,

Just some feedback regarding these:

The authentication action/integration doesn't work out of the box. It doesn't put the HTTP response into a data item so when it does the calculation it gives an error that the left value cannot be empty.  I removed this step as it ends if the answer is no anyway so doesn't seem to add much value. 

Regarding documentation it would be sueper handy to include a list of what Office 365 permissions need to be added to the API setup in Azure for each action/module/skill to work. As when our infra team setup the API keys for us they didn't work. We just got authentication issues and now I'm being asked for a specific list of what permissions we required.  Better documentation in this regard would be super helpful.

Otherwise the lists of actions in the three mentioned above and the others (Outlook, SharePoint) look great. Looking forward to getting these up and running.

------------------------------
Mat
------------------------------

[ewilson]

Hi @Mat,

Thanks for the feedback regarding the documentation. We'll work on getting those updated.

As for the authentication step, are you referring to the Outlook integration specifically or one of the others?

Cheers,
​

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[BenMcNicol]

Hi Ryan,

That's excellent,

Another nice feature might be the ability to get emails based on search terms.

Use query parameters to customize responses - Microsoft Graph | Microsoft Docs

$search

Returns results based on search criteria.

/me/messages?$search=pizza

------------------------------
Ben McNicol
Developer
Bunnings
Australia/Melbourne
------------------------------

[Mat]

Hi Eric, 

Please see the screenshot below: 


I've noticed if I set the Status Code to 200 it will give me the requested token.  Otherwise it gives me an error that that data item cannot be blank. It seems  to not log the status code when the request token action runs? 

Also,

Could you give me a list of what permissions are required for the Graph APIs to work? Is this documented anywhere as it's not in the documentation for each skill the screenshot in the document only shows one out of 182.


------------------------------
Mat
------------------------------