Skip to main content

How to fetch data from SharePoint list into a table?

We can use different technique to fetch data from SharePoint List.

Here, I am using jQuery to fetch data from a share point list.
HTML file-
<table id="tblData"> <thead> <tr> <th>EmployeeName </th>
 <th>Designation</th>
<th onClick="sortTable(1)">Email</th>
 <th>Salary</th>
<th>GrossSalary</th>
<th>Contact Number</th>
<th>Company</th> </tr>
 </thead>
 <tbody> </tbody> </table>

JSfile-

<script>
$.ajax({
url:SITE URL+"/_api/Web/Lists/getbytitle('LISTNAME')/items",
method:"GET",
headers: { "accept": "application/json;odata=verbose", //It defines the Data format 
"content-type": "application/json;odata=verbose" //It defines the content type as JSON
 },
success:function(response){
console.log(response);
response.d.results.forEach(function(d,key){
console.log(d);
var html = "<tr><td>" + d.EmployeeName + "</td><td>" + d.Designation + "</td><td>" + d.Email + "</td> <td>" + d.Salary+ "</td><td>" + d.GrossSalary+ "</td> <td>" + d.contactNumber+ "</td><td>" + d.Company+ "</td> </tr>"
$(table tbody).append(html);
)}
},
error:function(error){
console.log(JSON.stringify(error));
}

});
</script>

Comments

Popular posts from this blog

How to update values in a custom multi lookup field Field (table) of MS Project using JavaScript/jQuery?

  Updating values in the custom multi lookup field Field of MS Project using JavaScript/jQuery: First of all we need to know the steps to update/add details in a Project of Project Server  Step 1: CheckOut a Project Step 2: Update detals in same as in Step 1 Project Step 3: Publish a Project Step 4: CheckIn a Project We always in need to follow the above steps to update any Project to MS Project/Project Server. Same we need to follow in code too.    //Step 1: First, we need to define all the required functions, the below Functions are callback functions             window.checkOutPWAProject = function (projectId, callBack) {                 var checkOutURL = _spPageContextInfo.webAbsoluteUrl + "/_api/ProjectServer/Projects('" + projectId + "')/checkOut()";                 $.ajax({                     url: chec...

How to get all site users of SharePoint using REST API?

Get all users of SharePoint site using REST API: These users and its data are required to update people field of a SharePoint list. By using below snippet code we can able to get details of a user of SharePoint site.     var webURL = _spPageContextInfo.webAbsoluteUrl+"/_api/Web/SiteUsers";         $.ajax({           url: customFieldURL,           method: "GET",           headers: {             "Accept": "application/json; odata=verbose"           },           success: function (data) {            console.log(data);             data.d.results.forEach(function(cm){                     console.log(cm.Title+" - "+cm.Email+" - "+cm.Id);             });      ...

How to trigger a MS Flow Using Jquery/JavaScript?

Trigger a  MS Flow Using jQueryuery/JavaScript: To trigger an MS Flow first we need to create an workflow. Next we need to obtain its URL for triggering it. In below example, we are starting a workflow which is taking email address, email subject and email body as parameter and sending mail to email of related user. //This function triggers the microsoft flow  function beginMSFlow() {          var httpPostUrl = "obtain URL from MS flow";          var postData = {              emailadress:'raju@testdev.com', // Object keys must be similar as you used in the MS flow             emailSubject:'Testing Raju',              emailBody:'Hello User\n Welcome, You just trigger a MS Flow'             };           $.ajax({           url: httpPostUrl,    ...