Business application list published in SharePoint

[Michal_Ziemba]

Can I somehow publish the Business application list on SharePoint Online, so it will reflect the status in ServiceNow?

[Kristen Ankeny]

Taking a look at the SharePoint API documentation, this seems to be possible. Most likely you are looking at building out some combination of REST Messages, scheduled job, and possibly a script include to be able to grab the current business app data, compare to the sharepoint version, and either update or create records.

I would ensure the company is okay with any risk that might be associated with keeping a copy of this information in a secondary location and that duplicating the information rather than exposing it to the right people within the ServiceNow platform is the right solution for the business case. 

[Michal_Ziemba]

This is what I was initially thinking of. 

But when I dig a bit more into the topic I found out that I could prepare the report with the list in SNOW, publish it to anyone Business application, and embed it on the SharePoint site as an iframe. 

This way I could have only one source of truth and publish it in the place where my business stakeholders work.  Here is the article which describes that: ServiceNow, Service Portal & iFrames: A 2021 Update - Dylan Lindgren
However recently I have found this article which worries me a bit: Embedding ServiceNow pages using iFrames on external websites - Support and Troubleshooting 

And now I am a bit confused about which way to go. Have you had similar requests? How did you handle it?

[Punit S]

Hi Kristen, 

Yes, it is possible to publish the business application list from ServiceNow to SharePoint Online, so that it reflects the status of the applications in ServiceNow. One way to accomplish this is by using ServiceNow's REST API to retrieve the list of business applications and their statuses, and then using SharePoint Online's APIs or tools such as Power Automate to create and update a SharePoint list based on that data.

Here are the general steps you would need to follow:

1. Create a REST API endpoint in ServiceNow: Using ServiceNow's REST API, create an endpoint that retrieves the list of business applications and their statuses in a format that can be consumed by SharePoint Online. This may involve querying the "cmdb_ci_business_application" table in ServiceNow and formatting the data in a way that can be easily parsed by SharePoint Online.

2. Create a SharePoint list: In SharePoint Online, create a list to store the business application data. The list should have columns for the application name, status, and any other relevant data.

3. Use a tool or API to populate the SharePoint list: You can use SharePoint Online's built-in APIs, such as the SharePoint REST API, to populate the list with data from ServiceNow. Alternatively, you can use a tool such as Microsoft Power Automate to automate the process of retrieving the data from ServiceNow and updating the SharePoint list.

4. Set up a schedule for refreshing the data: Depending on your needs, you may want to set up a schedule for refreshing the data in the SharePoint list, so that it stays up-to-date with the latest information in ServiceNow. This can be done using Power Automate or other scheduling tools.

Overall, this approach requires integration  expertise in working with ServiceNow's REST API and SharePoint Online's APIs or tools. However, once set up, it can provide an efficient way to keep the business application list in SharePoint Online in sync with the status of the applications in ServiceNow

Thanks,

Punit