Seeking Advice: How to Fetch SharePoint Data into ServiceNow Tables Without Integration Hub

santhoshini2
Tera Contributor

2 hours ago

I have a client requirement where the goal is to fetch data from SharePoint and then store it in a ServiceNow table. Integration Hub is NOT available for this scenario. What are the best possible ways—using REST APIs, Power Automate, custom scripts, or other alternatives—to perform this integration securely and efficiently? Please share proven approaches, sample architectures, or step-by-step methods that work well for either SharePoint Online or On-Premise environments without Integration Hub.

0 Helpfuls
  • 76 Views
1 REPLY 1

M Iftikhar
Mega Sage

an hour ago

@santhoshini2 ,

Option 1: Direct REST API (ServiceNow - SharePoint Online)

  • Register ServiceNow in Azure AD to get client_id, tenant_id, and client_secret.

  • In ServiceNow:

    • Create a REST Message to first fetch an OAuth2 token.

    • Use that token in another REST Message call to get SharePoint data (via Graph API / SharePoint REST).

  • Use a Scheduled Job in ServiceNow to run this regularly and insert/update records into your custom table.

Option 2: Power Automate as Middleware

  • Build a Power Automate flow that fetches data from SharePoint.

  • Flow makes a POST call to ServiceNow Scripted REST API, sending the data.

  • ServiceNow Scripted REST API receives payload and stores it in your table.

https://www.matthewdevaney.com/create-a-connection-to-servicenow-in-power-automate/

Also some best practices for integration are:

 

  • Use OAuth2.0 with least privilege.

  • Use Script Includes in ServiceNow for reusability.

  • Implement error handling & logging in ServiceNow and middleware (when connecting with on premise envs).

  • If dataset is large consider incremental fetches.

 

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.

 

0 Helpfuls