Retrieve a list items from the parent site to the sub site

Question

Hello guys :D i'm trying to retrieve a list items of the parent site using rest api in sharepoint online hosted app workflow, I’ve tried to use : appURL + "_api/site/rootweb/lists/getByTitle(ListCollaborateurs)/items" but it didn’t work and I’ve got this error: result : {"error":{"code":"-2147024891,System.UnauthorizedAccessException","message":{"lang":"fr-FR","value":"Accès refusé. Vous n’êtes pas autorisé à effectuer cette action ou à accéder à cette ressource."}}} => French version Any idea please, and thnx in advance :D

Bouthaina Tlijani · Answer

Hello Raghavendar, I'm still trying to find a solution here and if i find a solution then i'll post it as a blog :D best regards, Bouthaina.

Bouthaina Tlijani · Answer

Hell o Raghavendar, Is there any possibility to achieve this using workflow in visual studio 2017, because actually i'm trying to develop a sharepoint online hosted app here :/ and thnx a lot my friend Best regards. BT.

Bouthaina Tlijani · Answer

Hi Nandeep, Thank you a lot but i already fix the problem :) i'll post an article later

Nanddeep Nachan · Answer

Please check the SharePoint Hosted App - manifest permissions. At minimum have below permission AppPermissionRequest Scope = "http://sharepoint/content/sitecollection" Right = "Read" />

Raghavendar Swaminathan · Answer

Hi Bouthaina, Hope this helps. function { var subsiteurl= "Subsite URL goes here"; var clientcontext = new SP.ClientContext(subsiteurl); var xList = clientcontext.get_web().get_lists().getByTitle("listname"); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml(" give your condition "); this.collListItem = xList.getItems(camlQuery); clientcontext.load(); context.executeQueryAsync(function onQuerySucceeded(sender, args) { alert('Inside OnQuery succeeded'); } } Regarding the WF is VS2017 i haven't explore those options. If your issue is resolved please as blog or article. If the post help please mark this answer as accepted. Thanks Raghav

Raghavendar Swaminathan · Answer

Hi Bouthaina, There is an another approach for achieve this same thing. Please check the below links. Reference Links: https://sharepoint.stackexchange.com/questions/226651/sp-2016-display-list-from-parent-site-in-sub-site Code: web = clientContext.get_web(); var list = web.get_lists().getByTitle(listName); var query = new SP.CamlQuery(); query.set_viewXml(queryString); var listItems = list.getItems(query); query.set_viewXml(queryString); var listItems = list.getItems(query); var fieldList = fields.join(","); clientContext.load(listItems); clientContext.executeQueryAsync(function () { var resultItems = []; var listItemEnumerator = listItems.getEnumerator(); while (listItemEnumerator.moveNext()) { var listItem = listItemEnumerator.get_current(); var fieldValues = listItem.get_fieldValues(); var resultItem = {}; for (var i = 0; i { resultItem[fields[i]] = listItem.get_item(fields[i]); } resultItems.push(resultItem); } return resultItems; Thanks Raghav