Articles about European Sharepoint Hosting Service
Posts tagged trick SharePoint 2013 Hosting
SharePoint 2013 Hosting – HostForLIFE.eu : SharePoint REST API – CAML Query
Jul 13th
Last week I was working with SharePoint rest API. In some terms, I needed to do some complicated query in a SP list. To do these queries I prefer CAML. But to use CAML with SharePoint rest API, I have been banging my head against the wall for a couple of days as I was stacked with errors. At last I got the solution I wanted.
Using the code
So, what I missed, is the first condition of using CAML with rest request. That is, it always has to be a POST request. The request header is as same as the other normal post request for SharePoint Rest API.
|
1 2 3 4 5 |
headers: { "X-RequestDigest": $("#__REQUESTDIGEST").val(), 'content-type': 'application/json;odata=verbose', 'accept': 'application/json;odata=verbose' } |
The REST endpoint for using caml query is
|
1 |
/_api/web/lists/GetByTitle('<List Name>')/GetItems |
The complete code with the rest call is given bellow:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
// Include JQuery reference // ... script continues ... /// List Name and CAML Query as Parameter function restCallwithCaml(listName, caml) { /// get the site url var siteUrl = _spPageContextInfo.siteAbsoluteUrl; /// set request data var data = { "query" :{"__metadata": { "type": "SP.CamlQuery" }, "ViewXml": caml}}; /// make an ajax call $.ajax({ url: siteUrl+"/_api/web/lists/GetByTitle('"+ listName +"')/GetItems", method: "POST", data: data, headers: { "X-RequestDigest": $("#__REQUESTDIGEST").val(), 'content-type': 'application/json;odata=verbose', 'accept': 'application/json;odata=verbose' } success: function (response) { ///do your code }, error: function (data) { ///do your code } }); } |
The CAML Query has to be used in between this <View><Query>…CAML Query…</Query></View> tag. The query with the way to call the function is given below:
|
1 2 |
var caml = “<View><Query><Where><Eq><FieldRef Name='EndDate'/><Value Type='DateTime'><Today /></Value></Eq></Where></View></Query>”; restCallwithCaml(<listName>, caml); |
Points of Interest
The CAML query can also be used in query string of the rest request. But it makes the URL unnecessarily complicated. If anyone knows of any better approach, please let me know in the comments below and I will update my article.
SharePoint 2013 Hosting – HostForLIFE.eu :: The Generic REST Library CRUD Operation in SharePoint
Jul 6th
For one of my clients, I was working on developing custom forms to interact with SharePoint lists and document libraries.
In that project, there were so many forms to be developed. So, I decided to develop one generic library that can be reused to perform operations using REST API.
The aim of this library is to create a generic set of methods as well, keeping one thing in mind that it should be enhanced easily to include more features.
In this library, there are a total 4of four files.
ListManager.js
This file is used to specify list columns we are working with.
ListUtility.js
This file contains all generic methods.
Main.js
Use this file to write application logic. This will be the main file referenced in our page, the rest of the files are loaded from Main.js itself.
Utility.js
It can be used to specify constants as well as utility methods.
I have also provided detailed information and instructions in attached zip file.
Getting Current Logged In User Using Rest API In SharePoint Online And Get User Details Using User ID
Jun 21st
There are two important REST API Services available to get the current logged in user or get full account details using the userId.
|
1 |
https://<<site details>>/sites/_api/web/currentuser |
This will return complete details of the current logged user in your data in XML. If it is run in the browser itself, we can create an AJAX call and get particular value (or) filter it.
|
1 |
https://<<site details>>/sites/_api/web/currentuser/_api/web/currentuser?$select=Title,Email,Id |
Another way of getting value using User Id value is to consume “_layouts/15/userdisp.aspx” and pass userId as query string value and get complete myblog site as response.
|
1 |
https://<<site details>>/sites/_api/web/currentuser/_layouts/15/userdisp.aspx??ID=<User ID value> |
Complete function
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
function GetUserDetails() { var url = "https://XXXXX.sharepoint.com/sites/testsite" + "/_api/web/currentuser"; $.ajax({ url: url, headers: { Accept: "application/json;odata=verbose" }, async: false, success: function (data) { var items = data.d.results; // Data will have user object }, eror: function (data) { alert("An error occurred. Please try again."); } }); } |
Debugger Console screenshot.
The Data object contains all user profile properties.
SharePoint 2013 Hosting – HostForLIFE.eu :: Configure People Picker For A Domain With One Way Trust
Jun 15th
This post will help you Configure People Picker for a domain with One way trust. If SharePoint is installed on a domain that has a one-way trust with other domains and you want the People Picker on SharePoint 2013/2010 to show users and groups from those other domains, you have to use the STSADM command to configure the People Picker.
This is tested on SharePoint 2010 and 2013.
So let’s get started 🙂
How to use stsadm commands in SharePoint.
- In SharePoint Server, Click Start and type CMD.
- Right click on Command prompt and select run as administrator.
- We have change the path in order to excute STSADM commands.
- To change the path run below command.
Step 1
You have to set an encryption key on all web front end servers in your farm so that the stored credentials can be encrypted:
STSADM.exe -o setapppassword -password Key
where “Key” is any value.
Example
STSADM.exe -o setapppassword -password Password11
Note
For two way trust there’s no need to set an encryption key, it means you can skip step 1 for a domain with two-way trust.
Step 2
You have to give SharePoint the credentials to authenticate against the remote domain and tell it which domain you would like to authenticate against. You only have to run this on one of your SharePoint web servers
STSADM.exe -o setproperty -propertyname peoplepicker-searchadforests -propertyvalue <Valid list of domains> -url <URL of the Web application>
where <Valid list of domains> is in the following format,
domain:DnsName,LoginName,Password
For example, a sample command might look like this:
STSADM.exe -o setproperty -propertyname peoplepicker-searchadforests -propertyvalue “domain:Test.com,test\user,[email protected]” -url https://sharepoint.com
You can add more than one domain. Just delimit them with a semicolon and a space.
For example
SSTSADM.exe -o setproperty -propertyname peoplepicker-searchadforests -propertyvalue “domain:Test.com,test\user,[email protected];domain:Test2.com,test2\user,[email protected]” -url https://sharepoint.com
Step 3
Run below cmd to test if value has been set for people picker or not.
STSADM.exe -o getproperty -pn peoplepicker-searchadforests -url http://Sharepoint.com
Hope it helps. Happy Sharepointing 🙂
SharePoint 2013 Hosting – HostForLIFE.eu :: How to Check/Retrieve Folder Operations On/From SharePoint Online Libraries Using PnP Core CSOM Library?
Jun 8th
In this article, I will tell you about how to check/retrieve the folders on/from SharePoint Online libraries, using PnP Core CSOM library. The main advantage of using PnP Core library is the reduced code to get the required information. The required object can be retrieved with a very small piece of code, once the client context is set.
The code, given below, is being tested, using Visual Studio console Application. Once the console Application is created, the packages can be installed, using Install-Package SharePointPnPCoreOnline command on Package Manager console of Visual Studio. Once installed, the references and packages will be imported to the solution.
The references used in the sample are given below.
- Microsoft.SharePoint.Client
- OfficeDevPnP.Core
Connect to SharePoint online site
The Authentication Manager is used to retrieve the client context of the site. To connect to SharePoint Online site, the method, given below is used.
|
1 |
GetSharePointOnlineAuthenticatedContextToken |
The parameters required are,
- SharePoint Online site URL.
- Tenant UserId.
- Tenant Password (or secured string).
Check If Folder Exists
Using PnP Core CSOM library, we can check if the folder already exists on the site library. The steps involved are:
- Input the site detail, the user details for the authentication, library and folder information.
- Authenticate and get the client context of the site.
- Retrieve the target list, using PnP Core library with the help of GetListByTitle method.
- Using the list object, access the root folder and then the required folder with FolderExists method.
- Display the results.
The code snippet, given below shows the example of checking the folder availability.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
// Input Parameters string siteUrl = "https://nakkeerann.sharepoint.com/"; string password = "***"; // PnP component to set context AuthenticationManager authManager = new AuthenticationManager(); try { // Get and set the client context // Connects to SharePoint online site using inputs provided using (var clientContext = authManager.GetSharePointOnlineAuthenticatedContextTenant(siteUrl, userName, password)) { // Input Parameter string listName = "Documents"; string folderName = "TestFolder"; // Get Library List list = clientContext.Site.RootWeb.GetListByTitle(listName); // Create Folder bool folderExists = list.RootFolder.FolderExists(folderName); // Output if (folderExists) { Console.WriteLine("Folder exists"); } else { Console.WriteLine("Folder doesn't exists"); } Console.ReadKey(); } } catch (Exception ex) { Console.WriteLine("Error Message: " + ex.Message); Console.ReadKey(); } |
Retrieve Folder
The available folders can be retrieved from SharePoint libraries, using PnP Core CSOM library. The steps involved are:
- Input the site detail, the user details for the authentication, library and folder information.
- Authenticate and get the client context of the site.
- Retrieve the target list, using PnP Core library with the help of GetListByTitle method.
- Using the list object, get the required folder, using ResolveSubFolder method.
- Display the results.
The code snippet, given below shows the example of retrieving the folder/subfolder from the library.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
// Input Parameters string siteUrl = "https://nakkeerann.sharepoint.com/"; string password = "***"; // PnP component to set context AuthenticationManager authManager = new AuthenticationManager(); try { // Get and set the client context // Connects to SharePoint online site using inputs provided using (var clientContext = authManager.GetSharePointOnlineAuthenticatedContextTenant(siteUrl, userName, password)) { // Input Parameter string listName = "Documents"; string folderName = "TestFolder"; // Get Library List list = clientContext.Site.RootWeb.GetListByTitle(listName); // Create Folder Folder folder = list.RootFolder.ResolveSubFolder(folderName); // Output Console.WriteLine("Server Relative Path : " + folder.ServerRelativeUrl); Console.ReadKey(); } } catch (Exception ex) { Console.WriteLine("Error Message: " + ex.Message); Console.ReadKey(); } |
I hope it works for you! Thank you.
SharePoint 2013 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.
SharePoint 2013 Hosting – HostForLIFE.eu :: Rest API Get Method Using jQuery Template In SharePoint 2013
May 31st
Welcome to a blog on getting the data from a list and putting the data in a template. Here, we will discuss a step by step procedure to get the data from a list and place it in a template.
Here, the main code to get the data from a list in detail is given below.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
var requestUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/lists/GetByTitle ('list name')/Items"; // Getting our list items $.ajax({ url: requestUrl, type: "GET", async: false, headers: { "Accept": "application/json; odata=verbose" }, success: function (data) { // Returning the results $.each(data.d.results, function (index, item) { //Append data to the template $("#empTemplate").tmpl(item).appendto("#tbDetails"); }); }, error: function (data) { console.log (data); alert("error " + data) } }) |
In the code given above, we are using a data template with an id “empTemplate” and a table template with an id “tbDetails”. Now, we will create the Data template and table Template, which are given below.
Here is the main code to create the Data template.
|
1 2 3 4 5 6 7 |
<script id="empTemplate" type="text/x-jQuery-tmpl"> <tr> <td>${EmployeeId}</td> <td>${EmployeeName}</td> <td>${EmployeeDepartment}</td> </tr> </script> |
Here is the main code to create the Table template
|
1 2 3 4 5 6 7 8 9 10 11 |
<table id="tbDetails" cellpadding="0" cellspacing="0" > <thead style="background-color:#DC5807; color:White; font-weight:bold"> <th>Employee Id</th> <th>Employee Name</th> <th>Employee Department</th> <tr style="border:solid 1px #000000"> </tr> </thead> <tbody> </tbody> </table> |
Now, we will create a container(div) to bind the Data template and Table template
|
1 |
<div id="empContainer"></div> |
Now, we are applying styles for the table element with the code given below.
|
1 2 3 4 5 6 7 |
<style type="text/css"> table,th,td { border:1px solid black; border-collapse:collapse; } </style> |
SharePoint 2013 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.
