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
Ashish_Kohale's avatar
Ashish_Kohale
Iron Contributor
May 31, 2020

leandrosg To set up connection so that SharePoint data can be accessible from external connection, I have written a blog, please check below link:

https://www.c-sharpcorner.com/blogs/setting-for-sharepoint-online-to-accessible-from-external-environment

 

 

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