I want to retrieve data from SharePoint lists (office 365) in a client web part created in SharePoint provider hosted app. The majority of tutorials i found were about SP hosted app. Can someone help me please?


You can use below code to read lists that are available in host web. Make sure you app has read permission

var spContext = SharePointContextProvider.Current.GetSharePointContext(Context);

using (var clientContext = spContext.CreateUserClientContextForSPHost())
    clientContext.Load(clientContext.Web, web => web.Title);

    ListCollection lists = clientContext.Web.Lists;
    List list = lists.GetByTitle("ListTitle");

    CamlQuery camlQuery = new CamlQuery();
    camlQuery.ViewXml = "<View><RowLimit>100</RowLimit></View>";
    Microsoft.SharePoint.Client.ListItemCollection items = list.GetItems(camlQuery);

    foreach (Microsoft.SharePoint.Client.ListItem item in items)
        Response.Write("<br />" + item.FieldValues["Title"]);
| improve this answer | |
  • When I publish my app only the first field is retrieved,how can I read all the fields of the SP list please? – N.Sahraoui Apr 16 '15 at 16:33
  • can you more explain for me please it doesn't work :/ – N.Sahraoui Apr 17 '15 at 10:17
  • Take a look at this link.. it shows how to use clientContext.Load... msdn.microsoft.com/en-us/library/office/… – Amal Hashim Apr 17 '15 at 10:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.