question

ImLenny-9857 avatar image
0 Votes"
ImLenny-9857 asked ImLenny-9857 commented

Reading external data from Sharepoint

Hello,

I'm looking to implement improvements in my clunky-to-manage watchlists by storing my lists in external sources.

The below blog shows me how to do it via a Storage Account, but curious to know whether it's possible to do it from SPO? And if so if it's possible to do it without completely opening access to my SPO site. I've looked at the sharing settings for my site and they don't seem great; they look either all or nothing.

The reason I'm keen to do it from SPO is because I have full control over that now, whereas getting a resource to properly set up a Storage Account could take anywhere from 5 minutes to 5 years

Any idea if this is possible to do in a secure manner?

https://techcommunity.microsoft.com/t5/azure-sentinel/implementing-lookups-in-azure-sentinel/ba-p/1091306

microsoft-sentinel
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

stan avatar image
0 Votes"
stan answered ImLenny-9857 commented

Hi,
I do not think this is possible. The option in the blog post is provided by Kusto function externaldata . Such functionality (gettting external data) either requires a function or plugin (example). Also in order to work with these functions or plugins it requires that they are available for Azure Monitor as on the backend Sentinel uses Log Analytics workspace which is part of Azure Monitor. In the docs for externaldata it clearly mentions that this function works with Azure Storage or Data Lake.

As workaround you can probably create some automation that when SharePoint list/file is updated the data is moved to blob on storage account and the watchlist is using that blob.

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That would make sense - I didn't think there would be a way (and accept its probably not the best solution either) but thought it was worth asking. Thanks for your help

0 Votes 0 ·