Skip to content

Instantly share code, notes, and snippets.

@tristian2
Created August 24, 2018 14:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tristian2/0d29d5331227ca1f84371c2d023cd112 to your computer and use it in GitHub Desktop.
Save tristian2/0d29d5331227ca1f84371c2d023cd112 to your computer and use it in GitHub Desktop.
How to get data from a SharePoint online list using REST
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<title></title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
<script src="js/JSON-to-Table.min.1.0.0.js"></script>
<script>
var siteurl = "https://trisdev.sharepoint.com";
$.ajax({
url: siteurl + "/_api/web/lists/getbytitle('Events')/items",
method: "GET",
headers: {
"Accept": "application/json; odata=verbose",
"authorization": "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IjdfWnVmMXR2a3dMeFlhSFMzcTZsVWpVWUlHdyIsImtpZCI6IjdfWnVmMXR2a3dMeFlhSFMzcTZsVWpVWUlHdyJ9.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvdHJpc2Rldi5zaGFyZXBvaW50LmNvbUA1YzIwMDFiZC0yMGFmLTQ5NmUtYjlkNi04ZTM3ODc0NmZkYzYiLCJpc3MiOiIwMDAwMDAwMS0wMDAwLTAwMDAtYzAwMC0wMDAwMDAwMDAwMDBANWMyMDAxYmQtMjBhZi00OTZlLWI5ZDYtOGUzNzg3NDZmZGM2IiwiaWF0IjoxNTM1MTExNDE1LCJuYmYiOjE1MzUxMTE0MTUsImV4cCI6MTUzNTE0MDUxNSwiaWRlbnRpdHlwcm92aWRlciI6IjAwMDAwMDAxLTAwMDAtMDAwMC1jMDAwLTAwMDAwMDAwMDAwMEA1YzIwMDFiZC0yMGFmLTQ5NmUtYjlkNi04ZTM3ODc0NmZkYzYiLCJuYW1laWQiOiI3ZjlmOTNlYS1lNzUwLTRlY2EtOTNiNy0yZWQ0YzY1ODQzODlANWMyMDAxYmQtMjBhZi00OTZlLWI5ZDYtOGUzNzg3NDZmZGM2Iiwib2lkIjoiODQ5YjcxNmMtNWIxOS00Mzg5LWE4YmQtNmMzNTRmNDdiN2RkIiwic3ViIjoiODQ5YjcxNmMtNWIxOS00Mzg5LWE4YmQtNmMzNTRmNDdiN2RkIiwidHJ1c3RlZGZvcmRlbGVnYXRpb24iOiJmYWxzZSJ9.Io8z9DHDBLBz5VwCIyFQDkJcHwOTtoqXtA2MyShkMtca59cQyzXxCX2bIb9QwH2_aTyuUTt8UpQkN4dRXhhRucjh4oj42PMCvuRswlY4JBi1-IE_yehbBq4GhaDjz3XySwjmdqu0ZryRlZB6CkpzdtPSKRK5o4ujuud_S6wn0XMCFgCAOEK0yiE92aq2i7xlvmI-LGCEjKeMGnBrYY3AxM4c4gw_lNlpOuj624M_XJwytRGTW7Kfgokj5NdPnLapTUTt1RS-yq9XXa1VRTvvx_6fNt65IK-6Kv5CvUkZQJWF9OCyw5edSNCdS4dHavnnbR66yHz8CdPG_0tSHWYCMw"
},
success: function (data) {
if (data.d.results.length > 0) {
console.log('in doSuccess');
console.log(data.d.results.length);
for (var i = 0; i < data.d.results.length; i++) {
var item = data.d.results[i];
debugger
//console.log(item.Title + item.Detail + item.Date_x0020_From + item.Date_x0020_To);
console.log(item.Title + item.Detail + item.br6c + item.m4eh);
$('#demo').createTable(data.d.results);
}
}
},
error: function (data) {
alert("Error: " + data);
}
});
</script>
</head>
<body>
<div id="demo"></div>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment