Forum Discussion

Copper Contributor

Apr 01, 2023

Solved

Unable to retrieve list items with app-only access token via PnP PowerShell

I created an access token and registered it granting fullcontrol to a site collection. In powershell, I connect via the connect-pnponline cmdlet and everything is fine. I can list items in the site c...

@Windows PowerShell

App-Only

token based

Number_Five
Apr 02, 2023
The step I was missing appears to have been the following:

https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/microsoft-sharepoint-online-connector/introduction-to-microsoft-sharepoint-online-connector/administration-of-microsoft-sharepoint-online-connector/generate-the-authorization-code.html

I did not need the authorization code (for the token refresh) but merely triggering that oauthorize.aspx did the trick. I did this twice, with two different app-only access tokens and I could finally use both to access data within the site collections via PS.

kalpeshvaghela

Iron Contributor

Apr 01, 2023

Number_Five

Make sure that DisableCustomAppAuthentication is set to False. By default in new tenant this setting is set to True,

https://learn.microsoft.com/en-us/powershell/module/sharepoint-online/set-spotenant?view=sharepoint-ps#-defaultsharinglinktype

You can change this setting via SharePoint Online Management Shell

Make sure that once you change this setting at tenant level, it can take up to 24 hours to apply this settings.

Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community

Number_Five

Copper Contributor

Apr 01, 2023

Hi, thanks for that suggestion, but that's not my issue. I actually have another token I had created a while back for the same site collection and it works just fine. I don't recall what I had to do to get it to work but I vaguely remember there being one more step I had to do to get it to work after setting the token permissions via appinv.aspx.