create/insert new records to a sharepoint list using REST API

 Create/insert new records to a sharepoint list:


To create/add new records in a SharePoint list using REST API, we need these thngs.
1) List Name (Company Details) and its Entity Type Full Name
2) Data that we need to add in list and internal name of Field (Contact Name) and id if it is a lookupfield (Company)

var postData = {

__metadata: {type: "SP.Data.Company_x0020_DetailsListItem"},// List Item Entity TypeFullName

CompanyId: 3, //lookup field id

Contact_x0020_Name: "Himanshu Shekhar",//Text Field

Package_x0020_Status: "Open", // Choice field

Plan_x0020_Holder: true

};


      var listEndPoint = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('Company%20Details')/items"

        $.ajax({

          url: listEndPoint,

          method: "POST",

           async:false, 

            headers: {  

                "accept": "application/json;odata=verbose",  

                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  

                "content-Type": "application/json;odata=verbose"  

            },  

            data: JSON.stringify(postData), 

          success: function (data) {

           console.log(data);

            console.log('Data added successfully');

          },

          error: function (error) {

            // error handler code goes here

            console.log(error)

          }

        });


Output:

Data (CompanyId, Contact Name, Package Status and Plan Holder has updated to server/list)


Console:


Data added successfully;



Was this helpful?



Comments

Post a Comment

Popular posts from this blog

Get list item entity type full name of a SharePoint list using REST API

Image
Get list item entity type full name of a SharePoint list using REST API : Follow the below steps to get ListItemEntityTypeFullName which must required for adding/updating items/records to the server or the SharePoint list. 1) First user/developer need logged in to the SharePoint site and then copy any of below URL/API. 2) Replace the _spPageContextInfo.webAbsoluteURL or siteurl (absolute URL) with the URL of you site for example. siteurl = https://testcompany.sharepoint.com/sites/testsite1 3) and replace SharePoint ListName = Payments or you original list name 4) Finally hit or place the complete URL/API API = https://testcompany.sharepoint.com/sites/testsite1/_api/Web/Lists/getbytitle('Students')/ListItemEntityTypeFullName into the browser search bar/box and click on enter button from keyboard then you will able to see output as shown in Output below   _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/getbytitle('ListName')/items?select=EntityTypeFullName OR s...
Read more

Get SharePoint list name by GUID

Image
 Get SharePoint list name by GUID in jQuery: Use the below snippet code to get the name of list by using listGuid . To do so replace the below list guid with your SP list GUID. var listGuid = "aa4774cf-oa71-83e4-6a67-01b53d5a7y6i2";//use your own SP site list guid getlistNameByGUID(listGuid); function getlistNameByGUID(guid) { $.ajax({         url: _spPageContextInfo.siteAbsoluteUrl + "/_api/Web/Lists(guid'"+listGuid+"')",         method: "GET",         headers: { "Accept": "application/json; odata=verbose" },         success: function (data) {              console.log(data.d.Title);         },         error: function (e) {             console.log(e)         }   }); } Output: Company//list name of my sp site  Was this helpful? Comment you suggestions and share it with yo...
Read more

Get Current Web Logged In User of SharePoint Site in jQuery

Get Current web logged in User of a SharePoint site in jQuery: Use the below snippet and just replace the jQuery library URL and run on you SharePoint page. <script src="../Assets/Jquery/jquery-1.9.1.min.js"></script> <script > function getCurrentLogInUser(){ $.ajax({     url: _spPageContextInfo.webServerRelativeUrl + "/_api/web/currentuser",     type: "GET",     async:false,     headers: { "Accept": "application/json;odata=verbose" } }).success(function( data ){     console.log( data );     console.log( data.d.Title ); }).error(function(e){     console.log( e ); }); } getCurrentLogInUser(); </script> Output:
Read more