Skip to main content

Hi Guys,


I’m attempting to connect to a Sharepoint Online site. I’ve diligently followed the guide (https://docs.skuid.com/latest/en/data/microsoft/sharepoint.html#sharepoint) a few times, however I can’t make the auth work.



Everything seems like it is working, I log into Sharepoint with my credentials in the oauth popup, and then I get “Authentication Failed” in Skuid.


When I capture the redirect in Fiddler I can see the login prompt is redirecting to https://cpdev1-practifi-dev-ed–skuid.ap1.visual.force.com/apex/skuid__oauthcallback?error=server_er…, most interestingly specifying this in the querystring:


error_description=The remote server returned an error: (401) Unauthorized.&



Seems like I need to grant more access in Sharepoint, however it’s not immediately obvious how one does this. Has anyone made the example in the guide work lately? Any feedback is much appreciated.

-Dan

Hi Dan,


Let me see if I can help you get the Sharepoint data source working. I’ll followup with you tomorrow with some questions. 


Thanks,

Matt

Great. Thanks, Matthew.

Hi Dan,


How did you configure Sharepoint? Can you share specifics on the setup (Team Site or Sub-Site, Permission Request XML).


There will be some back and forth, if that is ok. 


Thanks,

Matt

Hi Matthew,


The Sharepoint site was spun up based on a developer account. I created a single top level team site. The permission request XML was exactly as specified on the tutorial page, reproduced below:


  


-Dan
            

    
                                                    

    
Hey Dan,



Couple of things to update and test. The items below are “in addition” to the Skuid docs.



App Permissions Section



You have already granted permissions for the new “SharePoint App” to access the top level site’s lists and libraries. Now we want to grant permissions for the new “SharePoint App” to access a specific sub-site’s lists and libraries (Team Site). Again, use appregnew.aspx in that site’s path.
Navigate to 
https://.sharepoint.com/sites//_layouts/15/appinv.aspx
Repeat same steps as with the top level site’s lists and libraries.
Note: you may want to change the Permission Request XML. Valid options are Read, Write, Manage and Full Control.

<AppPermissionRequest Scope=“http://sharepoint/content/sitecollection” Right=“Manage”/>



Let’s move to the data source configuration for Sharepoint and edit the one you have already created.



Update the “URL / Endpoint”:



Sub-site - collection:



https://.sharepoint.com/sites//_api



Then click the “Refresh Metadata” button. May take a few minutes.



Let me know your results.



Thanks,


Matt

            

    
                                                    

    
Hi Matt,



All good until I hit the sub-site collection step.



I browse to https://practifidev.sharepoint.com/sites/practifiteam/_api and get 404 Not Found.



-Dan

            

    
                                                    

    
Hey Dan,

Let me consult one of our resident Sharepoint users. Leaning towards a permission issue, but more discussion required on my end.

Thank you for your patience.

–Matt  

            

    
                                                    

    
Dan,

You are actually at a place where you can create a sample page against your Sharepoint data source. Please refer to the Skuid Documentation (https://docs.skuid.com/latest/en/guides/) for assistance.

Let us know how the page building goes.

Thanks,
Matt

            

    
                                            

                    
                                                                

                        

                            
  
Reply










                        

                    

                                                

        

    


            

                                      

                                                                                                
            








View our Community Site Map
Nintex Community Sitemap


        

                        

    
    





    


                                        

                                                        

            
        
    






                        
Terms & ConditionsCookie settings