Forum Discussion

leandrosg's avatar
leandrosg
Copper Contributor
May 30, 2020

Configure connection to external data in Sharepoint

Hello! I want to create a list on my Sharepoint Online 365 by connecting to an API of a system where I will get all the registration information of my employees, then I will use this list as a data ...
Lists
SharePoint Online
leandrosg's avatar
leandrosg
Copper Contributor
Jun 06, 2020

Ashish_Kohale 

First of all congratulations on the blog, but I couldn't get past the xml permission part

Failing to create.

 

 

Ashish_Kohale's avatar
Ashish_Kohale
Iron Contributor
Jun 06, 2020

leandrosg : It seems you need tenant level permission to trust this app. This granting can only be done via the appinv.aspx page on the tenant administration site. You can reach this site via https://tenantname-admin.sharepoint.com/_layouts/appinv.aspx. Once the page is loaded add your client id and look up the created principal.

 

Use below XML to get the full control permission for the APP.

Spoiler
<AppPermissionRequests AllowAppOnlyPolicy="true"> <AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="FullControl" /> </AppPermissionRequests>

 

When you click on Create you'll be presented with a permission consent dialog. Press Trust It to grant the permissions

 

 

  • leandrosg's avatar
    leandrosg
    Copper Contributor
    Jun 06, 2020

    Ashish_Kohale 

    I did all the steps, but it didn't work.
    When I am going to generate the Sharepoint api website it presents the following error:
    "error_description": "Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."

     

Resources