How to deal with special characters in rest filters

-

Special characters in SharePoint Rest filters

You might have noticed while using SharePoint filters with special characters such as '&', '@' or '!' etc. you get error as we need to use encodeURIComponent in the rest api filtering. Below is the working example of filtering data from rest api having special character.

Code - 

function matchDataFromSPList(val){

        $.ajax({

                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbyTitle('ListName')/items?$filter= ColumnName eq '"+encodeURIComponent(val)+"'",

                type: "GET",

                headers: {

                        "Accept": "application/json;odata=verbose"

                },

                async: false, 

                success: function(data) {                                                                       

                     if (data.d.results.length > 0) { 

                         

                       }          

                },               

                error: function (error) {  

                      alert(JSON.stringify(error)); 

                }         

      });

}




Comments

Post a Comment

Popular posts from this blog

How to Customize exported excel's cell background color in Datatables

-
Image
Customize exported excel's cell background color in Datatables In this post i will walk you through how we can customize exported excel's cell background color in datatables. For this we need make changes in the buttons.html5.js file. you may refer below links for more info.  excelHtml5  and  how can i change the background color Follow below steps and make changes in buttons.html5.js file 1. Create your own fills.  '<fills count="11">'+ '<fill>'+ '<patternFill patternType="none" />'+ '</fill>'+ '<fill>'+ // Excel appears to use this as a dotted background regardless of values but '<patternFill patternType="none" />'+ // to be valid to the schema, use a patternFill '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="FFD9D9D9" /...
Read more

Clear DataTable on button click

-
Image
How to clear DataTable on button click In this post we will learn how we can clear a datatable on a jQuery event. By click on "btnReset" we have to call datatable's destroy method to completely clear a datatable. We may need to clear a datatable on an event. Please follow the below code to achieve the same. HTML - <table id="tblResourcesData" class="display" width="100%" cellspacing="0">           <thead>               <tr>                   <th>Title</th>                   <th>Region</th>                 <th>Country</th>                <th>Email</th>             </tr>           </thead>  </table...
Read more

Upload multiple attachments to SharePoint List Item using REST API jQuery, along with People Picker Column

-
Image
How to Upload multiple attachments to SharePoint List Item using REST API jQuery, along with People Picker Column In this post I will show you how we can upload multiple attachments on a SharePoint List item, I am taking a People Picker field here where you can store multiple SharePoint users along with other columns. Please refer the below code, It would be very helpful for you to implement the same in your projects. In the below code you will find how you can clear a input type file and people picker field.  JS Files need to be used -   <!-- SharePoint Specific Javascript Start -->       <!--script type="text/javascript" src="/_layouts/15/sp.runtime.js"></script-->         <script type="text/javascript" src="/_layouts/15/sp.js"></script>         <script type="text/javascript" src="/_layouts/15/1033/strings.js"></script>         <scr...
Read more