Using client id and secret to pull SharePoint online data from site

Question

Hi all

Have a SharePoint site with a list, a powershell to pull data from the list and log to shared drive - this works fine when running the script adhoc using;

Connect-PnPOnline -Url $SiteURL -UseWebLogin

If I create an app, add/approve this in SharePoint for the site or list in question and then run the following it produces no output in the location specified;

Connect-PnPOnline -Url $SiteURL -clientid $clientid -clientsecret $secret -warningaction Ignore

Cant see what the issue could be - apps been approved for id/secret to work, no authentication failure, just no results. Anything glaringly obvious that could be the problem? Can post full script if needed however only things being changed is the logon option in connection line

Thanks

Answer 1

Hi @DonnaSmith
Please refer to this document first to see if the problem can be solved.

Then if possible please provide your code for reference:

Here is a link for your reference:

https://www.sharepointdiary.com/2019/03/connect-pnponline-with-appid-and-appsecret.html

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best Regards

Cheng Feng