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 send email using SharePoint REST API in jQuery/JavaScript?

  Send email using SharePoint REST API in jQuery/JavaScript: We can able to send email to the SharePoint user using below REST API on SharePoint Online. We need to load SP.js file in code. we must need to give valid SharePoint user to send email. We can able to send email to valid SharePoint user of same organization.      var   restAPI  =  _spPageContextInfo . webAbsoluteUrl  +  "/_api/SP.Utilities.Utility.SendEmail" ;      $ . ajax ({          contentType:   'application/json' ,          url:   restAPI ,          type:   "POST" ,          data:   JSON . stringify ({              'properties' :  {             ...

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,    ...