We recently migrated from SharePoint 2013 to SharePoint Online.
We have a existing job in SQL Server which run with proxy service account and which call power shell script (PnP cmdlet) to connect Share Point and get the List Item data. This process is working as expected.
The existing code have : ConnectPnPOnline -url "xxxx" -currentcredentials
The currentcredentials is taking up the proxy service account details and the same account have permission on share point.
Share Point Online acceps on SSO , so i provided ConnectPnPOnline -url "xxxx" -useweblogin but it popup window and asking for credentials. I should not have any user interaction as i am calling this script from scheduled sql job.
How to provide bound SSO (single sign on) credentials in the power shell script.
Or, any other approach to fullfill my requirement.