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.
Please sign in to leave a comment.