Troubleshooting SharePoint Access
I have a SharePoint online site with a subsite and I created a token against my site following the instructions here: http://www.agilepointnxblog.com/create-non-expiring-access-tokens-for-office-365/
I am able to configure a drop down control on my form against my token and I can see the subsite perfectly in the Site URL dropdown:
this all works great. I can select a list within that subsite and test my Query and the data is returned with no problem.
However, we have a couple other SharePoint online sites where we have followed the same procedures to create the AgilePoint access and token and AgilePoint cannot query the lists in those sites. I'm an admin on one of the SharePoint sites but I am still not able to query it. And there are no errors generated (either in the server log or in AgilePoint form)...it just says there are no records to return. We have created the token both at the site and subsite levels and have seen no difference. If we create the token at the site level, it does NOT show the subsites in the drop-down lookup....it only shows "/". If we create the token at the subsite level, it does show all of the lists in the subsite, but the query still fails:
It doesn't make sense that its a privilege problem since I'm an admin. Is there something else that might be an issue with security between AgilePoint and SharePoint? Any recommendations are appreciated! Not sure where to look since there are no errors.
-
Thank you Nithya!
We setup the dummy app in SharePoint by using the instructions in the link I provided above. The user that configured the dummy app is an admin for the site. Once the dummy app was registered, the token was setup with the client Id/secret.
We tried setting the dummy app/token up both at the site level and the subsite level and we still can't get AgilePoint to pull up the list contents from SharePoint.
Does that answer your question?
-
Hi Sylvia,
Thanks for the quick revert, could you please check and reconfirm if you followed step #2 (below from the blog) to assign Permission to the dummy app?
Step 2: Assign Permission to the dummy app: Navigate to the SharePoint Office365 page <<SharePoint site url>>/_layouts/15/appinv.aspx
for ex : https://agilepoint462.sharepoint.com/Sites/qa/_layouts/15/appinv.aspx and in app id field provide the above create client id and click lookup button, it will display your app’s information on the page. In the Permission Request XML field just paste the below xml and click save.
<AppPermissionRequests AllowAppOnlyPolicy=”true”>
<AppPermissionRequest Scope=”http://sharepoint/content/sitecollection/web” Right=”FullControl” />
<AppPermissionRequest Scope=”http://sharepoint/content/sitecollection” Right=”FullControl” />
</AppPermissionRequests>
Note: Please copy this text into a notepad first and replace all double quotes with proper format before copying that over to SharePoint page. WordPress messes up the double quote format which if pasted directly in the SharePoint page will throw an error.
On the next page click on Trust it button and your dummy app will be registered and permissions are assigned and it is ready to use.
Thanks,
Nithya V
-
Yes, we did that Nithya.
This is exactly what we copied/pasted for the permissions
<AppPermissionRequests AllowAppOnlyPolicy="true">
<AppPermissionRequest Scope="http://SharePoint/content/sitecollection/web" Right="FullControl" />
<AppPermissionRequest Scope="http://SharePoint/content/sitecollection" Right="FullControl" />
</AppPermissionRequests>And we clicked Trust It.
Please sign in to leave a comment.
Comments
5 comments