Multiple active connections for Microsoft SharePoint Online Spoke (JSON Web Token + Certificate)

[Vincent Lee]

Hi all,

I've been fighting the platform for this business need for weeks and keep running into obstacles every few feet.

Following the ServiceNow documentation for the Microsoft SharePoint Online Spoke, we have it working. However, the key part that is not mentioned in the documentation is having multiple active connections. We are requiring this because we have multiple SharePoint Online geo-locations, and each have their own URL and OAuth token, and we need to have Flow Designer select which SharePoint Online connection and credential to use at the action instance level. 

Currently, we are able to turn on and off (set Active = true OR false) the connection needed manually, but this obviously wouldn't work for production as multiple concurrent executions will be running and the system would need to send the requests to the correct environment via a Decision Table or similar Flow Designer logic.

I have tried the Support Multiple Active Connections feature but ran into issues with token, as well as the "Configure Connections" button being grayed out in Flow Designer whenever SharePoint Online actions are added. I have a ticket open with ServiceNow and they are saying it's a defect and will be fixed in a future release (no ETA).

I am now trying to create separate Connection & Credential aliases entirely (leaving the out of box MicrosoftSharePointOnline one for the default environment), but am running into the encoded_certificate_thumbprint record not being created. I believe this is due to the OAuthUtilSPJWTOnline OAuth API script having hardcoded sys_id values.

Has anyone done this and got it working? If so please share your insights. Similarly if anyone is trying to just set it up for one environment and ran into issues (the JKS generation in particular was tricky), I'd gladly help here as well.