Other Related Post

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

Apr 12th

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()

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Arrange Choice Field’s CheckBoxes On SharePoint Forms?

Apr 11th

Posted by Peter in Other Related Post

No comments

If a choice field in SharePoint is set to Check Box and the choice field values are in a large number, then the field values are arranged vertically. So, I have made an effort to arrange the checkboxes (choice values) horizontally. I am sharing this with a motif to save your time.

In the below code, I have put everything into a function where I first find out the total number of choice values by picking the selector and crawling through the hierarchy of HTML tags to get “.ms-RadioText”.

And then, get the total by using length.

e.g. var len = $(“#trainTopic table tbody tr td .ms-RadioText”).length;

Then, decide on how many values you need in one row. The loops used in code are as shown below.

e.g. Outer Loop: for (i = 0; i < len; i = i + 4)

Inner Loop: for (j = i + 1; j <= i + 3; j++)

The numbers 4 and 3 in outer and inner loops respectively state that 4 columns will be created or we can say 4 choice values will be put in each row created.

You, then, loop through the full length of choice values and the iterations of this loop will take a jump of 4 counts as the number of columns I need is just 4.

And in every iteration of the outer loop, I find the row in which the 4th + 1 choice value resides in by picking the choice value in the list and find the <tr></tr> in which it stands.

The inner loop arranges the next 3 choice values i.e. the <td></td> in which it resides in the same row as the first choice value.

And, here we go.

    function ArrangeCheckBoxes()  
    {  
        var len = $("#choiceField table tbody tr td .ms-RadioText").length;  
        temp = len - 1;  
        count = 0;  
        var startingElement;  
        for (i = 0; i < len; i = i + 4) {  
            if (count == temp) break;  
            startingElement = $("#choiceField table tbody tr td .ms-RadioText:eq(" + i + ")").closest('tr')  
            count++;  
            for (j = i + 1; j <= i + 3; j++) {  
                if (count == temp) break;  
                $("#choiceField table tbody tr td .ms-RadioText:eq(" + (j) + ")").closest('td').appendTo(startingElement);  
                count++;  
            }  
        }  
    }

function ArrangeCheckBoxes()

{

var len = $("#choiceField table tbody tr td .ms-RadioText").length;

temp = len - 1;

count = 0;

var startingElement;

for (i = 0; i < len; i = i + 4) {

if (count == temp) break;

startingElement = $("#choiceField table tbody tr td .ms-RadioText:eq(" + i + ")").closest('tr')

count++;

for (j = i + 1; j <= i + 3; j++) {

if (count == temp) break;

$("#choiceField table tbody tr td .ms-RadioText:eq(" + (j) + ")").closest('td').appendTo(startingElement);

count++;

}

HostForLIFE.eu Proudly Launches Umbraco 7.5.7 Hosting

Jan 27th

Posted by Peter in Other Related Post

No comments

HostForLIFE.eu, a leading Windows web hosting provider with innovative technology solutions and a dedicated professional services team, today announced the support for Umbraco 7.5.7 hosting plan due to high demand of Umbraco users in Europe. The company has managed to build a strong client base in a very short period of time. It is known for offering ultra-fast, fully-managed and secured services in the competitive market.

HostForLIFE.eu hosts its servers in top class data centers that is located in Amsterdam, (NL), London, (UK), Washington, D.C. (US), Paris, (France), Frankfurt, (Germany), Chennai, (India), Milan, (Italy), Toronto, (Canada) and São Paulo, (Brazil) to guarantee 99.9% network uptime. All data centers feature redundancies in network connectivity, power, HVAC, security and fire suppression. All hosting plans from HostForLIFE.eu include 24×7 support and 30 days money back guarantee. HostForLIFE Umbraco hosting plan starts from just as low as €3.49/month only and this plan has supported ASP.NET Core 1.1, ASP.NET MVC 5/6 and SQL Server 2012/2014/2016.

Umbraco is a fully-featured open source content management system with the flexibility to run anything from small campaign or brochure sites right through to complex applications for Fortune 500’s and some of the largest media sites in the world. Umbraco is strongly supported by both an active and welcoming community of users around the world, and backed up by a rock-solid commercial organization providing professional support and tools. Umbraco can be used in its free, open-source format with the additional option of professional tools and support if required.

Umbraco release that exemplifies our mission to continue to make Umbraco a bit simpler every day. The other change is that there’s now a “ValidatingRequest” event you can hook into. This event allows you to “massage” any of the requests to ImageProcessor to your own liking. So if you’d want to never allow any requests to change BackgroundColor, you can cancel that from the event. Similarly if you have a predefined set of crops that are allowed, you could make sure that no other crop sizes will be processed than those ones you have defined ahead of time.

Further information and the full range of features Umbraco 7.5.7 Hosting can be viewed here: http://hostforlife.eu/European-Umbraco-757-Hosting

best umbraco 7.5.7 hosting, cheap umbraco 7.5.7 hosting, recommended umbraco 7.5.7 hosting, top umbraco 7.5.7 hosting, umbraco 7.5.7 hosting

HostForLIFE.eu Proudly Launches Visual Studio 2017 Hosting

Dec 2nd

Posted by Peter in Other Related Post

No comments

European leading web hosting provider, HostForLIFE.eu announces the launch of Visual Studio 2017 Hosting

HostForLIFE.eu was established to cater to an underserved market in the hosting industry; web hosting for customers who want excellent service. HostForLIFE.eu – a cheap, constant uptime, excellent customer service, quality, and also reliable hosting provider in advanced Windows and ASP.NET technology. HostForLIFE.eu proudly announces the availability of the Visual Studio 2017 hosting in their entire servers environment.

The smallest install is just a few hundred megabytes, yet still contains basic code editing support for more than twenty languages along with source code control. Most users will want to install more, and so customer can add one or more ‘workloads’ that represent common frameworks, languages and platforms – covering everything from .NET desktop development to data science with R, Python and F#.

System administrators can now create an offline layout of Visual Studio that contains all of the content needed to install the product without requiring Internet access. To do so, run the bootstrapper executable associated with the product customer want to make available offline using the –layout [path] switch (e.g. vs_enterprise.exe –layout c:\mylayout). This will download the packages required to install offline. Optionally, customer can specify a locale code for the product languages customer want included (e.g. –lang en-us). If not specified, support for all localized languages will be downloaded.

HostForLIFE.eu hosts its servers in top class data centers that is located in Amsterdam (NL), London (UK), Paris (FR), Frankfurt(DE) and Seattle (US) to guarantee 99.9% network uptime. All data center feature redundancies in network connectivity, power, HVAC, security, and fire suppression. All hosting plans from HostForLIFE.eu include 24×7 support and 30 days money back guarantee. The customers can start hosting their Visual Studio 2017 site on their environment from as just low €3.00/month only.

HostForLIFE.eu is a popular online ASP.NET based hosting service provider catering to those people who face such issues. The company has managed to build a strong client base in a very short period of time. It is known for offering ultra-fast, fully-managed and secured services in the competitive market.

HostForLIFE.eu offers the latest European Visual Studio 2017 hosting installation to all their new and existing customers. The customers can simply deploy their Visual Studio 2017 website via their world-class Control Panel or conventional FTP tool. HostForLIFE.eu is happy to be offering the most up to date Microsoft services and always had a great appreciation for the products that Microsoft offers.

Further information and the full range of features Visual Studio 2017 Hosting can be viewed here http://hostforlife.eu/European-Visual-Studio-2017-Hosting

Best Visual Studio 2013 Hosting, Cheap Visual Studio 2017 Hosting, Recommended Visual Studio 2017 hosting, Visual Studio 2017 Hosting

Other Related Post

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?

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Arrange Choice Field’s CheckBoxes On SharePoint Forms?

HostForLIFE.eu Proudly Launches Umbraco 7.5.7 Hosting

HostForLIFE.eu Proudly Launches Visual Studio 2017 Hosting

BLOGROLL

Featured On

Other Related Post

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?

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Arrange Choice Field’s CheckBoxes On SharePoint Forms?

HostForLIFE.eu Proudly Launches Umbraco 7.5.7 Hosting

HostForLIFE.eu Proudly Launches Visual Studio 2017 Hosting

BLOGROLL

Featured On

Tags