topic RE: First Microsoft Graph API integrations available on the DX! in Digital Exchange

First Microsoft Graph API integrations available on the DX!

ewilson — Fri, 25 Sep 2020 14:45:00 GMT

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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

kirtish_trivedi — Fri, 25 Sep 2020 16:01:00 GMT

That is great News

I am eagerly waiting for Microsoft Graph Teams API for Blueprism

Thanks

------------------------------
Asia/Kolkata
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

ManuToivanen — Thu, 29 Oct 2020 09:11:00 GMT

Is there any estimation when the Outlook integration will be available?

Thanks in advance!

------------------------------
Europe/Helsinki
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

NileshJadhavBP — Thu, 29 Oct 2020 14:00:00 GMT

Thanks @ewilson for sharing great news.

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

ewilson — Wed, 04 Nov 2020 00:25:00 GMT

@ManuToivanen the Graph API integration for Outlook is in tech review now. Hopefully it will be approved within the next week barring any issues.

Cheers,

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

RE: First Microsoft Graph API integrations available on the DX!

AP.Philippa — Mon, 15 Feb 2021 16:45:00 GMT

Hello Eric,

Would you be able to provide us with an indication on when we can expect the SharePoint Graph API integration to be released on the Blue Prism DX?

Many thanks in advance!

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

ewilson — Mon, 15 Feb 2021 16:57:00 GMT

Hi @AP.Philippa,

It's in our backlog for this quarter, so we should have it published by end of April.

There are a few other Sharepoint integrations on the DX now if you need something immediately. They're just not leveraging Graph to my knowledge.

Cheers,

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

RE: First Microsoft Graph API integrations available on the DX!

AP.Philippa — Tue, 16 Feb 2021 09:28:00 GMT

Hi Eric,

Thanks for your swift response to my query!

I however do have another question. Is it already known what functionalities BP is aiming to include in the first release of the SharePoint Graph API object?

For example, we are currently looking for file management actions on SharePoint sites, such as: check if a file/folder exist, create/delete folder, upload/download file. Are these functionalities that we can expect to be included in the SharePoint Graph API integration?

Thanks in advance!

Arthur Philippa

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

RyanMatuszewski — Tue, 16 Feb 2021 17:35:00 GMT

Hi Arthur,

The SharePoint API in Microsoft Graph supports the following core scenarios:

Access to SharePoint sites, lists, and drives (document libraries)
Read-only support for site resources (no ability to create new sites)
Read-write support for lists, listItems, and driveItems
Address resources by SharePoint ID, URL, or relative path

These are the functionalities expected to be built into the first release. As Eric mentioned above, there are a few other Sharepoint integrations on the DX now if you need something immediately. This is expected to be released before the end of our current Q2.

Thanks,

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

RE: First Microsoft Graph API integrations available on the DX!

AP.Philippa — Mon, 03 May 2021 10:00:00 GMT

Hi @ewilson,

I hope you are doing well.

Would you be able to provide us with an update on the expected DX release date of the SharePoint Graph API object?

Thanks in advance!

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

ewilson — Mon, 03 May 2021 11:25:00 GMT

@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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

JerinJose — Mon, 03 May 2021 12:42:00 GMT

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, .*
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

ewilson — Mon, 03 May 2021 13:22:00 GMT

@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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

RyanMatuszewski — Mon, 03 May 2021 14:45:00 GMT

@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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

BenMcNicol — Sun, 30 May 2021 23:48:00 GMT

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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

RyanMatuszewski — Wed, 02 Jun 2021 19:02:00 GMT

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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

Mat — Thu, 03 Jun 2021 07:08:00 GMT

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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

ewilson — Thu, 03 Jun 2021 11:21:00 GMT

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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

BenMcNicol — Thu, 03 Jun 2021 11:43:00 GMT

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
------------------------------

RE: First Microsoft Graph API integrations available on the DX!

Mat — Thu, 03 Jun 2021 12:41:00 GMT

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
------------------------------