Other Related Post

SharePoint 2013 Hosting – HostForLIFE.eu :: Add custom Content to Page Layouts in SharePoint

Jul 25th

This blog explains a common requirement where users need to add custom content editor web parts into all pages across the site in SharePoint.

Adding custom components to SharePoint Page layouts so that they are visible on each page created is a common requirement for SharePoint developers. To Achieve this we will follow the below steps.

Open SharePoint designer and create a page layout with custom zones and design as required –> save page layout
Create a new page with the page layout created and add a content editor web part in the zone required. Now add your custom client side code into the content editor web part and test for code functionality.
Export the content editor web part with custom code to your local.
Upload the web part to site settings –> web part
Open Page layout in designer and Place your cursor within the zone template of required web part zone. Now Insert the custom added web part into the zone ( save page if insert web part is disabled)AddCustomWp
Save page. Now all pages created with the page layout will have the custom component added by default.

Even though this is a simple process it will come handy when we have to add custom content on all pages across the site along with utilization of web part properties like audience targeting etc.

SharePoint 2013 Hosting – HostForLIFE.eu :: Add And Remove Custom Action Using PnP PowerShell

Jul 18th

Posted by Peter in Other Related Post

No comments

In this blog article, I am going to add and remove custom action using PnP PowerShell.

Adding a custom action to the SharePoint site

The Add-PnPCustomAction command is used to add a user custom action to a web or site collection.

Example

This example adds a new custom action to the Site Settings and sets the Title, Name and other fields with the specified values.

Add-PnPCustomAction -Name ‘Item Search’ -Title ‘Item Search’ -Description ‘Adds custom action to SiteSettings’ -Group ‘SiteAdministration’ -Location ‘Microsoft.SharePoint.SiteSettings’ -Sequence 1000 -Url ‘https://www.google.com’

Output

Getting the custom action information

The Get-PnPCustomAction command is used to return user custom action(s) of the web or current site collection.

Example 1

This example returns all custom actions of the current site.

Get-PnPCustomAction

Add And Remove Custom Action Using PnP PowerShell

Output

Example 2

This example returns the custom action with the id “47eaee71-7aa2-458a-8ca8-cbd48f5e68c3”.

Get-PnPCustomAction -Identity 47eaee71-7aa2-458a-8ca8-cbd48f5e68c3

Removing a custom action from the SharePoint site

The Remove-PnPCustomAction command is used to remove user custom action(s) from the current web or site collection.

Example

This example removes the custom action with the id “47eaee71-7aa2-458a-8ca8-cbd48f5e68c3”.

Remove-PnPCustomAction -Identity 47eaee71-7aa2-458a-8ca8-cbd48f5e68c3

Output

Sharepoint 2013 Hosting – HostForLIFE.eu :: Sharepoint 2013 Hosting – HostForLIFE.eu ::

Jan 10th

Posted by Peter in Other Related Post

No comments

In this blog, I am going to perform two actions –

Identify if a page is a modern page or not.
Migrate or copy that modern page (including its content) to another site collection or site (destination location)

I am going to accomplish these tasks by using CSOM (Client Object Model). After identifying the modern page, I will copy the modern page into another site collection (destination location) and then, will migrate all the page contents of this modern page (including web parts and other properties of source modern page) to a destination web using CSOM.

We are using a console application to achieve the above functionality using CSOM. In the below-mentioned code logic, we will get all pages from ‘Site Pages’ page library which is present in the source web and looping each page to check if that is a modern page or not.

If the page is found to be a modern page, then we are migrating that page to the destination web ‘Site Pages’ library.

Please have a look at the below code. The code is self-explanatory because of the comments.

    using System;  
    using System.Net;  
    using System.Security;  
    using System.Text.RegularExpressions;  
    using Microsoft.SharePoint.Client;  
    namespace ConsoleApp1 {  
        class Program {  
            static void Main(string[] args) {  
                ClientContext sourceContext = null;  
                List sourceList = null;  
                ListItemCollection srcItemCollection = null;  
                ListItem sourceItem = null;  
                string userName = string.Empty;  
                string password = string.Empty;  
                SecureString srcSiteSecurePassword = new SecureString();  
                SharePointOnlineCredentials sourceOnlineCredentials = null;  
                try {  
                    using(sourceContext = new ClientContext("http://sourcesiteurl")) {  
                        userName = "TestUser";  
                        password = "Password";  
                        if (!string.IsNullOrEmpty(password)) {  
                            foreach(char c in password.ToCharArray())  
                            srcSiteSecurePassword.AppendChar(c);  
                        }  
                        // Setting credential for the above site  
                        sourceOnlineCredentials = new SharePointOnlineCredentials(userName, srcSiteSecurePassword);  
                        sourceContext.Credentials = sourceOnlineCredentials;  
                        sourceContext.Load(sourceContext.Web);  
                        sourceContext.ExecuteQuery();  
                        // Getting source list by Title  
                        sourceList = sourceContext.Web.Lists.GetByTitle("Site Pages");  
                        // Getting all items from source list using caml query  
                        srcItemCollection = sourceList.GetItems(CamlQuery.CreateAllItemsQuery());  
                        //Loading source items  
                        sourceContext.Load(srcItemCollection, IC => IC.Include(I => I.Id, I => I.DisplayName));  
                        sourceContext.ExecuteQuery();  
                        if (srcItemCollection != null && srcItemCollection.Count > 0) {  
                            for (int iCount = 0; iCount < srcItemCollection.Count; iCount++) {  
                                try {  
                                    sourceItem = srcItemCollection[iCount];  
                                    //Checking if current page is modern page or not  
                                    if (IsModernPage(sourceContext, sourceItem)) {  
                                        // Migrate modern page to anothen site  
                                        MigrateModernPageToAnotherWeb(sourceContext, sourceItem);  
                                    }  
                                } catch (Exception ex) {}  
                            }  
                        }  
                    }  
                } catch (Exception ex) {}  
            }  
            // Checking if the selected page is a modern page or not  
            private static bool IsModernPage(ClientContext sourceContext, ListItem sourceItem) {  
                bool isModernPage = false;  
                try {  
                    sourceContext.Load(sourceItem, srcItm => srcItm["CanvasContent1"], srcItm => srcItm["LayoutWebpartsContent"]);  
                    sourceContext.ExecuteQuery();  
                    // Check if modern page  
                    if (!string.IsNullOrEmpty(sourceItem["CanvasContent1"].ToString()) || !string.IsNullOrEmpty(sourceItem["LayoutWebpartsContent"].ToString())) isModernPage = true;  
                } catch {  
                    isModernPage = false;  
                }  
                return isModernPage;  
            }  
            // Migrating the modern page from source site to destination site  
            private static void MigrateModernPageToAnotherWeb(ClientContext sourceContext, ListItem sourceItem) {  
                ClientContext destSiteContext = null;  
                List destList = null;  
                ListItem destItem = null;  
                string userName = string.Empty;  
                string password = string.Empty;  
                SecureString destSiteSecurePassword = new SecureString();  
                SharePointOnlineCredentials destOnlineCredentials = null;  
                string canvasContent = string.Empty;  
                string metaInfo = string.Empty;  
                string layoutWebpartsContent = string.Empty;  
                try {  
                    using(destSiteContext = new ClientContext("http://destinationsiteurl")) {  
                        userName = "TestUser";  
                        password = "Password";  
                        if (!string.IsNullOrEmpty(password)) {  
                            foreach(char c in password.ToCharArray())  
                            destSiteSecurePassword.AppendChar(c);  
                        }  
                        // Setting credential for the above site  
                        destOnlineCredentials = new SharePointOnlineCredentials(userName, destSiteSecurePassword);  
                        destSiteContext.Credentials = destOnlineCredentials;  
                        destSiteContext.Load(destSiteContext.Web);  
                        destSiteContext.ExecuteQuery();  
                        // Getting destination list by Title  
                        destList = destSiteContext.Web.Lists.GetByTitle("Site Pages");  
                        // Loading destination list  
                        destSiteContext.Load(destList, L => L.RootFolder.ServerRelativeUrl);  
                        destSiteContext.ExecuteQuery();  
                        // Creating modern page in destination site  
                        destItem = destList.RootFolder.Files.AddTemplateFile(destList.RootFolder.ServerRelativeUrl.TrimEnd('/') + "/" + sourceItem.DisplayName + ".aspx", TemplateFileType.ClientSidePage).ListItemAllFields;  
                        destSiteContext.Load(destItem);  
                        destSiteContext.ExecuteQuery();  
                        // Loading source item properties  
                        sourceContext.Load(sourceItem, i => i.ContentType.Id, i => i["CanvasContent1"], i => i["MetaInfo"], i => i["LayoutWebpartsContent"]);  
                        sourceContext.ExecuteQuery();  
                        try {  
                            destItem["ContentTypeId"] = sourceItem.ContentType.Id.ToString();  
                            canvasContent = sourceItem["CanvasContent1"].ToString();  
                            // Replacing source Web ID with destination Web ID  
                            if (!string.IsNullOrEmpty(canvasContent) && canvasContent.Length > 0 && canvasContent.ToLower().Contains(sourceContext.Web.Id.ToString().ToLower())) canvasContent = Regex.Replace(canvasContent, sourceContext.Web.Id.ToString(), destSiteContext.Web.Id.ToString(), RegexOptions.IgnoreCase);  
                        } catch (Exception ex) {}  
                        try {  
                            metaInfo = sourceItem["MetaInfo"].ToString();  
                            // Replacing source Web ID with destination Web ID  
                            if (!string.IsNullOrEmpty(metaInfo) && metaInfo.Length > 0 && metaInfo.ToLower().Contains(sourceContext.Web.Id.ToString().ToLower())) metaInfo = Regex.Replace(metaInfo, sourceContext.Web.Id.ToString(), destSiteContext.Web.Id.ToString(), RegexOptions.IgnoreCase);  
                        } catch (Exception ex) {}  
                        try {  
                            layoutWebpartsContent = sourceItem["LayoutWebpartsContent"].ToString();  
                            // Replacing source Web ID with destination Web ID  
                            if (!string.IsNullOrEmpty(layoutWebpartsContent) && layoutWebpartsContent.Length > 0 && layoutWebpartsContent.ToLower().Contains(sourceContext.Web.Id.ToString().ToLower())) layoutWebpartsContent = Regex.Replace(layoutWebpartsContent, sourceContext.Web.Id.ToString(), destSiteContext.Web.Id.ToString(), RegexOptions.IgnoreCase);  
                        } catch (Exception ex) {}  
                        // Setting source page canvas content to destination page  
                        if (!string.IsNullOrEmpty(canvasContent) && canvasContent.Length > 0) destItem["CanvasContent1"] = canvasContent;  
                        // Setting source page metaInfo content to destination page  
                        if (!string.IsNullOrEmpty(metaInfo) && metaInfo.Length > 0) destItem["MetaInfo"] = metaInfo;  
                        // Setting source page layout webparts content to destination page  
                        if (!string.IsNullOrEmpty(layoutWebpartsContent) && layoutWebpartsContent.Length > 0) destItem["LayoutWebpartsContent"] = layoutWebpartsContent;  
                        // Updating the destination page  
                        destItem.Update();  
                        destSiteContext.ExecuteQuery();  
                    }  
                } catch (Exception ex) {}  
            }  
        }  
    }

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

using System;

using System.Net;

using System.Security;

using System.Text.RegularExpressions;

using Microsoft.SharePoint.Client;

namespace ConsoleApp1 {

class Program {

static void Main(string[] args) {

ClientContext sourceContext = null;

List sourceList = null;

ListItemCollection srcItemCollection = null;

ListItem sourceItem = null;

string userName = string.Empty;

string password = string.Empty;

SecureString srcSiteSecurePassword = new SecureString();

SharePointOnlineCredentials sourceOnlineCredentials = null;

try {

using(sourceContext = new ClientContext("http://sourcesiteurl")) {

userName = "TestUser";

password = "Password";

if (!string.IsNullOrEmpty(password)) {

foreach(char c in password.ToCharArray())

srcSiteSecurePassword.AppendChar(c);

}

// Setting credential for the above site

sourceOnlineCredentials = new SharePointOnlineCredentials(userName, srcSiteSecurePassword);

sourceContext.Credentials = sourceOnlineCredentials;

sourceContext.Load(sourceContext.Web);

sourceContext.ExecuteQuery();

// Getting source list by Title

sourceList = sourceContext.Web.Lists.GetByTitle("Site Pages");

// Getting all items from source list using caml query

srcItemCollection = sourceList.GetItems(CamlQuery.CreateAllItemsQuery());

//Loading source items

sourceContext.Load(srcItemCollection, IC => IC.Include(I => I.Id, I => I.DisplayName));

sourceContext.ExecuteQuery();

if (srcItemCollection != null && srcItemCollection.Count > 0) {

for (int iCount = 0; iCount < srcItemCollection.Count; iCount++) {

try {

sourceItem = srcItemCollection[iCount];

//Checking if current page is modern page or not

if (IsModernPage(sourceContext, sourceItem)) {

// Migrate modern page to anothen site

MigrateModernPageToAnotherWeb(sourceContext, sourceItem);

}

} catch (Exception ex) {}

}

} catch (Exception ex) {}

}

// Checking if the selected page is a modern page or not

private static bool IsModernPage(ClientContext sourceContext, ListItem sourceItem) {

bool isModernPage = false;

try {

sourceContext.Load(sourceItem, srcItm => srcItm["CanvasContent1"], srcItm => srcItm["LayoutWebpartsContent"]);

sourceContext.ExecuteQuery();

// Check if modern page

if (!string.IsNullOrEmpty(sourceItem["CanvasContent1"].ToString()) || !string.IsNullOrEmpty(sourceItem["LayoutWebpartsContent"].ToString())) isModernPage = true;

} catch {

isModernPage = false;

}

return isModernPage;

}

// Migrating the modern page from source site to destination site

private static void MigrateModernPageToAnotherWeb(ClientContext sourceContext, ListItem sourceItem) {

ClientContext destSiteContext = null;

List destList = null;

ListItem destItem = null;

string userName = string.Empty;

string password = string.Empty;

SecureString destSiteSecurePassword = new SecureString();

SharePointOnlineCredentials destOnlineCredentials = null;

string canvasContent = string.Empty;

string metaInfo = string.Empty;

string layoutWebpartsContent = string.Empty;

try {

using(destSiteContext = new ClientContext("http://destinationsiteurl")) {

userName = "TestUser";

password = "Password";

if (!string.IsNullOrEmpty(password)) {

foreach(char c in password.ToCharArray())

destSiteSecurePassword.AppendChar(c);

}

// Setting credential for the above site

destOnlineCredentials = new SharePointOnlineCredentials(userName, destSiteSecurePassword);

destSiteContext.Credentials = destOnlineCredentials;

destSiteContext.Load(destSiteContext.Web);

destSiteContext.ExecuteQuery();

// Getting destination list by Title

destList = destSiteContext.Web.Lists.GetByTitle("Site Pages");

// Loading destination list

destSiteContext.Load(destList, L => L.RootFolder.ServerRelativeUrl);

destSiteContext.ExecuteQuery();

// Creating modern page in destination site

destItem = destList.RootFolder.Files.AddTemplateFile(destList.RootFolder.ServerRelativeUrl.TrimEnd('/') + "/" + sourceItem.DisplayName + ".aspx", TemplateFileType.ClientSidePage).ListItemAllFields;

destSiteContext.Load(destItem);

destSiteContext.ExecuteQuery();

// Loading source item properties

sourceContext.Load(sourceItem, i => i.ContentType.Id, i => i["CanvasContent1"], i => i["MetaInfo"], i => i["LayoutWebpartsContent"]);

sourceContext.ExecuteQuery();

try {

destItem["ContentTypeId"] = sourceItem.ContentType.Id.ToString();

canvasContent = sourceItem["CanvasContent1"].ToString();

// Replacing source Web ID with destination Web ID

if (!string.IsNullOrEmpty(canvasContent) && canvasContent.Length > 0 && canvasContent.ToLower().Contains(sourceContext.Web.Id.ToString().ToLower())) canvasContent = Regex.Replace(canvasContent, sourceContext.Web.Id.ToString(), destSiteContext.Web.Id.ToString(), RegexOptions.IgnoreCase);

} catch (Exception ex) {}

try {

metaInfo = sourceItem["MetaInfo"].ToString();

// Replacing source Web ID with destination Web ID

if (!string.IsNullOrEmpty(metaInfo) && metaInfo.Length > 0 && metaInfo.ToLower().Contains(sourceContext.Web.Id.ToString().ToLower())) metaInfo = Regex.Replace(metaInfo, sourceContext.Web.Id.ToString(), destSiteContext.Web.Id.ToString(), RegexOptions.IgnoreCase);

} catch (Exception ex) {}

try {

layoutWebpartsContent = sourceItem["LayoutWebpartsContent"].ToString();

// Replacing source Web ID with destination Web ID

if (!string.IsNullOrEmpty(layoutWebpartsContent) && layoutWebpartsContent.Length > 0 && layoutWebpartsContent.ToLower().Contains(sourceContext.Web.Id.ToString().ToLower())) layoutWebpartsContent = Regex.Replace(layoutWebpartsContent, sourceContext.Web.Id.ToString(), destSiteContext.Web.Id.ToString(), RegexOptions.IgnoreCase);

} catch (Exception ex) {}

// Setting source page canvas content to destination page

if (!string.IsNullOrEmpty(canvasContent) && canvasContent.Length > 0) destItem["CanvasContent1"] = canvasContent;

// Setting source page metaInfo content to destination page

if (!string.IsNullOrEmpty(metaInfo) && metaInfo.Length > 0) destItem["MetaInfo"] = metaInfo;

// Setting source page layout webparts content to destination page

if (!string.IsNullOrEmpty(layoutWebpartsContent) && layoutWebpartsContent.Length > 0) destItem["LayoutWebpartsContent"] = layoutWebpartsContent;

// Updating the destination page

destItem.Update();

destSiteContext.ExecuteQuery();

}

} catch (Exception ex) {}

}

Destination Page Library Before Migration,

Destination Page Library after Migration

After executing the above code behind, you can find the newly created modern page in the destination web ‘Site Pages’ library with the same page contents and “web parts” as they were in the source page.

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 :: Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed Code

Apr 12th

Posted by Peter in Other Related Post

No comments

SharePoint 2013 has many restful APIs to fetch the data from lists. However, sometimes, we need to use a CAML query to filter out the data. SharePoint Rest API has an option to pass a CAML query as data to an API call. The below steps will help you to call a Rest API with CAML query filtering. In addition, this article will help you to understand how to call REST API POST methods in console applications using C# managed code. The below example calls a REST API to retrieve the data from Department SharePoint list. Department list has a Title column, which refers to the department name. CAML query will be used to filter the Department list data by Title (Department name).

REST endpoint /_api/web/lists/getbytitle(‘Department’)/GetItems CAML Query Structure CAML query structure should be strictly followed as below: <View><Query> <CAML_Query> </Query></View> Assembly References

Net: To make a request to a Uniform Resource Identifier (URI).
Web.Script.Serialization: For serialization and deserialization functionality
IO: For reading and writing streams.

Request Header for POST Request The API endpoint is of type POST. Hence, the REST header should be same as other post requests,

oWebRequest.Accept = “application/json;odata=verbose”;
oWebRequest.ContentType = “application/json;odata=verbose”;
oWebRequest.Headers.Add(“X-RequestDigest”, GetFormDigest());
oWebRequest.ContentLength = stringData.Length;

Steps Please follow the below steps to create a console application:

Open Visual Studio.

Select Console Application template and provide a suitable name.

Add required assemblies.

Add the below code in Program.cs file.

Run the code.

    using System;  
    using System.Collections.Generic;  
    using System.IO;  
    using System.Net;  
    using System.Web.Script.Serialization;  
      
    namespace ConsoleApp1  
    {  
        class Program  
        {  
           
            static void Main(string[] args)  
            {  
                string sConnStr = "<web_url>";  
                Uri oUri = null;  
                oUri = new Uri(sConnStr + "/_api/web/lists/getbytitle('Department')/GetItems");  
      
                string sResult = string.Empty;  
      
                string stringData = "{'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, 'ViewXml':'<View><Query><Where><Eq><FieldRef Name =\"Title\"/><Value Type=\"Text\">HR</Value></Eq></Where></Query></View>'}}";  
      
                HttpWebRequest oWebRequest = (HttpWebRequest)WebRequest.Create(oUri);  
                oWebRequest.Credentials = CredentialCache.DefaultNetworkCredentials;  
                oWebRequest.Method = "POST";  
                oWebRequest.Accept = "application/json;odata=verbose";  
                oWebRequest.ContentType = "application/json;odata=verbose";  
                oWebRequest.Headers.Add("X-RequestDigest", GetFormDigest());  
                oWebRequest.ContentLength = stringData.Length;  
      
                StreamWriter writer = new StreamWriter(oWebRequest.GetRequestStream());  
                writer.Write(stringData);  
                writer.Flush();  
      
                WebResponse wresp = oWebRequest.GetResponse();  
                using (StreamReader sr = new StreamReader(wresp.GetResponseStream()))  
                {  
                    sResult = sr.ReadToEnd();  
                }  
            }  
            public static string GetFormDigest()  
            {  
                string sFormDigest = null;  
                string sConnStr = "<web_url>";  
                Uri oUri = null;  
                oUri = new Uri(sConnStr + "/_api/contextinfo");  
                  
                HttpWebRequest oWebRequest = HttpWebRequest.Create(oUri) as HttpWebRequest;  
                oWebRequest.UseDefaultCredentials = true;  
                oWebRequest.Method = "POST";  
                oWebRequest.Accept = "application/json;odata=verbose";  
                oWebRequest.ContentLength = 0;  
                oWebRequest.ContentType = "application/json";  
                string sResult;  
                WebResponse sWebReponse = oWebRequest.GetResponse();  
      
                using (StreamReader sr = new StreamReader(sWebReponse.GetResponseStream()))  
                {  
                    sResult = sr.ReadToEnd();  
                }  
      
                var jss = new JavaScriptSerializer();  
                var val = jss.Deserialize<Dictionary<string, object>>(sResult);  
                var d = val["d"] as Dictionary<string, object>;  
                var wi = d["GetContextWebInformation"] as Dictionary<string, object>;  
                sFormDigest = wi["FormDigestValue"].ToString();  
      
                return sFormDigest;  
      
            }  
        }  
    }

using System;

using System.Collections.Generic;

using System.IO;

using System.Net;

using System.Web.Script.Serialization;

namespace ConsoleApp1

{

class Program

{

static void Main(string[] args)

{

string sConnStr = "<web_url>";

Uri oUri = null;

oUri = new Uri(sConnStr + "/_api/web/lists/getbytitle('Department')/GetItems");

string sResult = string.Empty;

string stringData = "{'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, 'ViewXml':'<View><Query><Where><Eq><FieldRef Name =\"Title\"/><Value Type=\"Text\">HR</Value></Eq></Where></Query></View>'}}";

HttpWebRequest oWebRequest = (HttpWebRequest)WebRequest.Create(oUri);

oWebRequest.Credentials = CredentialCache.DefaultNetworkCredentials;

oWebRequest.Method = "POST";

oWebRequest.Accept = "application/json;odata=verbose";

oWebRequest.ContentType = "application/json;odata=verbose";

oWebRequest.Headers.Add("X-RequestDigest", GetFormDigest());

oWebRequest.ContentLength = stringData.Length;

StreamWriter writer = new StreamWriter(oWebRequest.GetRequestStream());

writer.Write(stringData);

writer.Flush();

WebResponse wresp = oWebRequest.GetResponse();

using (StreamReader sr = new StreamReader(wresp.GetResponseStream()))

{

sResult = sr.ReadToEnd();

}

public static string GetFormDigest()

{

string sFormDigest = null;

string sConnStr = "<web_url>";

Uri oUri = null;

oUri = new Uri(sConnStr + "/_api/contextinfo");

HttpWebRequest oWebRequest = HttpWebRequest.Create(oUri) as HttpWebRequest;

oWebRequest.UseDefaultCredentials = true;

oWebRequest.Method = "POST";

oWebRequest.Accept = "application/json;odata=verbose";

oWebRequest.ContentLength = 0;

oWebRequest.ContentType = "application/json";

string sResult;

WebResponse sWebReponse = oWebRequest.GetResponse();

using (StreamReader sr = new StreamReader(sWebReponse.GetResponseStream()))

{

sResult = sr.ReadToEnd();

}

var jss = new JavaScriptSerializer();

var val = jss.Deserialize<Dictionary<string, object>>(sResult);

var d = val["d"] as Dictionary<string, object>;

var wi = d["GetContextWebInformation"] as Dictionary<string, object>;

sFormDigest = wi["FormDigestValue"].ToString();

return sFormDigest;

}

Code Explanation

The complete data to be passed in the request will be:
1. “{‘query’ : {‘__metadata’: { ‘type’: ‘SP.CamlQuery’ }, ‘ViewXml’:'<View><Query><Where><Eq><FieldRef Name =\”Title\”/><Value Type=\”Text\”>HR</Value></Eq></Where></Query></View>’}}”;

Form Digest need to be passed while calling post method. GetFormDigest() returns the required request digest.

Summary In this article, we have explored how to call SharePoint REST API with CAML query in C# console application. The CAML query can also be passed through the URL itself. However, this makes the API URL complicated and sometimes, restricts the length of the URL. The same code can be used in implementing custom APIs as well.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

Mar 1st

Posted by Peter in Other Related Post

No comments

In this blog, we are going to learn how to copy the attachments from a single list item to SharePoint library using PnP PowerShell. The following snippet helps, you to get the attachments from a list item and uploads to the shared Documents library in a current context site.

$cred = Get-Credential
Connect-PnPOnline -Url https://ktskumartenant.sharepoint.com/sites/dev -Credential $cred

$listitem = Get-PnPListItem -List Employee -Id 2
$attachments = ForEach-Object{Get-PnPProperty -ClientObject $listitem -Property "AttachmentFiles"}

$attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl –TargetUrl “Shared Documents/$($_.FileName)”

$cred = Get-Credential

Connect-PnPOnline -Url https://ktskumartenant.sharepoint.com/sites/dev -Credential $cred

$listitem = Get-PnPListItem -List Employee -Id 2

$attachments = ForEach-Object{Get-PnPProperty -ClientObject $listitem -Property "AttachmentFiles"}

$attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl –TargetUrl “Shared Documents/$($_.FileName)”

After running the powershell command, it asks us to confirm the sourceurl and target url. If the file already exists in the targeturl, we have to add -OverwriteIfAlreadyExists $true to avoid the file already exists error.

Below is the example copies the two attachments from the single list item to the folder within a SharePoint library.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create Result Source In SharePoint 2013 Search Using PowerShell?

Jul 27th

Posted by Peter in Other Related Post

No comments

This blog post describes how to create a search result source using PowerShell in SharePoint 2013. I have a requirement to add additional search rules which will be used with the keywords entered by the user in the search box, then you will need to create custom search result source. The query will be,

{searchTerms} Author={User.Name} FileType=pdf FileType=docx

1	{searchTerms} Author={User.Name} FileType=pdf FileType=docx

Source Code

    Add-PSSnapin Microsoft.SharePoint.PowerShell  
        
    $SearchServiceApp = Get-SPEnterpriseSearchServiceApplication  
    $fedmanager = New-Object Microsoft.Office.Server.Search.Administration.Query.FederationManager($SearchServiceApp)  
        
    $searchOwner = Get-SPEnterpriseSearchOwner -Level Ssa    
        
    $resultSourceName = "Search"  
    $urlTemplate = "http://yoursharepointsitename/search?q={searchTerms}&format=rss&Market=en-Us"  
    $qT = "{searchTerms}"  
    $ResultSource = $fedmanager.GetSourceByName($resultSourceName, $searchOwner)  
    if(!$ResultSource){  
        Write-Host "Result source does not exist. Creating."  
        $ResultSource = $fedmanager.CreateSource($searchOwner)  
    }  
    else { Write-Host "Using existing result source." }  
        
    $ResultSource.Name =$resultSourceName  
    $ResultSource.ProviderId = $fedmanager.ListProviders()['OpenSearch Provider'].Id  
    $ResultSource.ConnectionUrlTemplate = $urlTemplate  
    $ResultSource.CreateQueryTransform($queryProperties,$qT)  
    $ResultSource.Commit()

Add-PSSnapin Microsoft.SharePoint.PowerShell

$SearchServiceApp = Get-SPEnterpriseSearchServiceApplication

$fedmanager = New-Object Microsoft.Office.Server.Search.Administration.Query.FederationManager($SearchServiceApp)

$searchOwner = Get-SPEnterpriseSearchOwner -Level Ssa

$resultSourceName = "Search"

$urlTemplate = "http://yoursharepointsitename/search?q={searchTerms}&format=rss&Market=en-Us"

$qT = "{searchTerms}"

$ResultSource = $fedmanager.GetSourceByName($resultSourceName, $searchOwner)

if(!$ResultSource){

Write-Host "Result source does not exist. Creating."

$ResultSource = $fedmanager.CreateSource($searchOwner)

}

else { Write-Host "Using existing result source." }

$ResultSource.Name =$resultSourceName

$ResultSource.ProviderId = $fedmanager.ListProviders()['OpenSearch Provider'].Id

$ResultSource.ConnectionUrlTemplate = $urlTemplate

$ResultSource.CreateQueryTransform($queryProperties,$qT)

$ResultSource.Commit()

Other Related Post

SharePoint 2013 Hosting – HostForLIFE.eu :: Add custom Content to Page Layouts in SharePoint

SharePoint 2013 Hosting – HostForLIFE.eu :: Add And Remove Custom Action Using PnP PowerShell

Adding a custom action to the SharePoint site

Getting the custom action information

Removing a custom action from the SharePoint site

Sharepoint 2013 Hosting – HostForLIFE.eu :: Sharepoint 2013 Hosting – HostForLIFE.eu ::

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed Code

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create Result Source In SharePoint 2013 Search Using PowerShell?

BLOGROLL

Featured On

Other Related Post

SharePoint 2013 Hosting – HostForLIFE.eu :: Add custom Content to Page Layouts in SharePoint

SharePoint 2013 Hosting – HostForLIFE.eu :: Add And Remove Custom Action Using PnP PowerShell

Adding a custom action to the SharePoint site

Getting the custom action information

Removing a custom action from the SharePoint site

Sharepoint 2013 Hosting – HostForLIFE.eu :: Sharepoint 2013 Hosting – HostForLIFE.eu ::

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed Code

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create Result Source In SharePoint 2013 Search Using PowerShell?

BLOGROLL

Featured On

Tags