ServiceNow bi-directional integration

[Saurav Bhardwa2]

Hello,

I'm wondering if it's feasible to establish a bi-directional integration between SharePoint and the SharePoint Online Spoke. I can create a custom action as well, given that the connection is already established with both SharePoint Online and Graph. I've been researching this topic, but unfortunately, I haven't come across any information on setting up bi-directional integration with ServiceNow.

Currently, we're pushing HR documents to SharePoint. However, we're looking for a solution that would allow any edits made to these documents in SharePoint to also reflect in SNOW. Is there any guidance or approach I can get to achieve this synchronization?

Thanks

[SwarnadeepNandy]

Hello @Saurav Bhardwa2,

Unfortunately, I don't see any webhook to establish a bi-directional connectivity.

To achieve this, I think you may need to perform polling from ServiceNow side.

Here are some general steps for one possible approach:

1. Create a custom action in ServiceNow that can update a document in SharePoint using the Update item action from the SharePoint Online Spoke. You will need to provide the inputs, such as the site URL, list name, item ID, and field values, for the action.
2. Create a script in ServiceNow that can call the custom action whenever a document is updated in ServiceNow. You can use the GlideRecord API to access and modify the records in ServiceNow, such as the HR documents. You can also use the GlideAction API to execute the custom action from the script. You can attach the script to a business rule or a workflow that runs on the update event of the document table.
3. Create a custom action in ServiceNow that can update a document in ServiceNow using the Get item and Update record actions from the SharePoint Online Spoke and the ServiceNow Core Spoke respectively. You will need to provide the inputs, such as the site URL, list name, item ID, table name, record ID, and field values, for the actions.
4. Create a script in ServiceNow that can call the custom action whenever a document is updated in SharePoint. You can use the GlideRecord API to access and modify the records in ServiceNow, such as the HR documents. You can also use the GlideAction API to execute the custom action from the script. You can attach the script to an event or a scheduled job that runs periodically or on demand to check for changes in SharePoint.

Hope this helps.

Kind Regards,

Swarnadeep Nandy

[Saurav Bhardwa2]

Thank you @SwarnadeepNandy 
Is there a parent table in SharePoint where we store all these documents? otherwise we have around 100 sites, I will have to do the polling with 100 endpoints and that's impossible

[ersureshbe]

Hi,

I feel, instead of bi-directional integration you write schedule job to pull the record every 5 mins (Define your business use case) and update it to ServiceNow target tables. You define your conditions when you are doing the parse activity