Thursday, February 5, 2015

JSON in sharepoint 2010


<script type="text/javascript" src="/sites/Training/SiteAssets/js/jquery-1.3.2.min.js"></script>

<script type="text/javascript">
function getLs(){
var currentdate = new Date();
var dateT=currentdate.getMinutes() +"::"+currentdate.getSeconds();
$("#IDInContentEditorWP").append(dateT);
var myurl="http://server/sites/training/_vti_bin/listdata.svc/Curriculum";
$.ajax({
    url : myurl,
    headers: { "Accept": "application/json; odata=verbose"},
    type: 'GET',
    dataType: 'json',
        success : function(data){
             for (i=0; i<data.d.results.length; i++ ){
                 dateT=currentdate.getMinutes() +"::"+currentdate.getSeconds();
                 $("#IDInContentEditorWP").append("<table><tr><td>"+data.d.results[i].Title+"</td></tr></table>");
$("#IDInContentEditorWP").append(dateT);
           }
    },
    error : function(xhr, status){
        console.log(status);
    }
});
}


//  additme is addining item to a sharepoint list
function additme(){
var myurl="http://server/sites/training/_vti_bin/listdata.svc/Curriculum";
var contact = {
CurriculumName: "Dell"
};
var body = JSON.stringify(contact);
$.ajax({
          url : myurl,
          contentType: 'application/json',
          type: 'POST',
         dataType: 'json',
         data: body,
         processData: false,
        success : function(data){
             alert("save");
    },
    error : function(xhr, status){
        console.log(status);
    }
});
}

You can also put filter
var myurl="http://server/sites/training/_vti_bin/listdata.svc/Curriculum?$filter=fieldName eq 'Operations'