Search source table for sharepoint connector "sn_sp_con_sharepoint_external_search" shows no records

[Vineet Yadav1]

Hi  All,

Need your help for below issue.

We are working on bringing external content from SharePoint using "SharePoint Online Search Connector".

We are able to get content of site, drive, permissions and indexing also completed.
In index file flow its showing records are being created in "sn_sp_con_sharepoint_external_search” by ingest API but when we go table its empty.

Account is admin at both SharePoint and ServiceNow.

Is there any permission issue with this table even tried to create manually records in this table after submission it shows "Records not found".

[Shamus Mulhall]

Hi @Vineet Yadav1 an external content schema table doesn't store external document content in the database. Instead, its columns serve as a map of AI Search index fields to populate when you index content from external data sources.

Further documentation on External Content: https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/ai-search/concept/ex...

[Vineet Yadav]

Hi Shamus,

Thanks for sharing information.

Got the information we cannot view any records in SharePoint connector schema table but it will work as per user permission from SharePoint site in Portal

One more information need like as of now SharePoint connectors are configured per site like site/company but if need to configure at SharePoint root level is it possible ?

  

[Shamus Mulhall]

Here is some additional information on creating a SharePoint Graph Root Site subscription connection

https://docs.servicenow.com/bundle/utah-integrate-applications/page/administer/integrationhub-store-...

[Shailesh15]

@Vineet Yadav  @Vineet Yadav1  does the sn_sp_con_sharepoint_external_search table get populated ? if so at what stage ?