Forum Discussion

Nj-SharePointDeveloper's avatar
Nj-SharePointDeveloper
Copper Contributor
Jan 20, 2023
Solved

Not able to fetch data from SharePoint Online List using Postman tool

Hi, I followed the process to fetch the data from SP online list using Postman tool: - Register a new app. - Generate client id and secret. - Grant permission -  <AppPermissionRequests AllowAp...
  • SvenSieverding's avatar
    SvenSieverding
    Jan 20, 2023

    Hi Nj-SharePointDeveloper 

    When exactly did you get that error?

     

    • After executing the Powershell command?
      • After the login using "Connect-PnPOnline"?
      • After executing the "Set-PnPTenant" command?
    • After acquiring the token? (From https://accounts.accesscontrol.windows.net)
    • After executing a SharePoint REST request?


    If it occurs during the login using "Connect-PnPOnline" try to execute the following command once before

    Register-PnPManagementShellAccess

    That registers the PnP Powershell as an app in your tenant.

    Best Regards,

    Sven

SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Jan 20, 2023

Hi Nj-SharePointDeveloper 

ACS and SharePoint "ClientID" and "Secret" authentication is kind of old.
You need to re-activate it on new tenants using PowerShell as a SharePoint Admin.

It looks like this if you use PnP-Powershell

Connect-PnPOnline https://<yourtenant>-admin.sharepoint.com -Interactive
Set-PnPTenant -DisableCustomAppAuthentication $false

 Then your Postman request will work.

But ACS  is the "old" method...
You should take a look at Azure AD Apps and the "Sites.Selected" permission. 

Best Regards,
Sven


  • Nj-SharePointDeveloper's avatar
    Nj-SharePointDeveloper
    Copper Contributor
    Jan 20, 2023

    Error after running above command  The resource principal named https:// was not found in the tenant named "....". This can happen if the application has not been installed by the administrator of the tenant. etc etc

    • SvenSieverding's avatar
      SvenSieverding
      Bronze Contributor
      Jan 20, 2023

      Hi Nj-SharePointDeveloper 

      When exactly did you get that error?

       

      • After executing the Powershell command?
        • After the login using "Connect-PnPOnline"?
        • After executing the "Set-PnPTenant" command?
      • After acquiring the token? (From https://accounts.accesscontrol.windows.net)
      • After executing a SharePoint REST request?


      If it occurs during the login using "Connect-PnPOnline" try to execute the following command once before

      Register-PnPManagementShellAccess

      That registers the PnP Powershell as an app in your tenant.

      Best Regards,

      Sven

Resources