Instantly share code, notes, and snippets.
Created
July 24, 2017 11:40
-
Star
0
(0)
You must be signed in to star a gist -
Fork
0
(0)
You must be signed in to fork a gist
-
Save VijayaSankarN/b6f462b1a8d9a38963c1021b9c3360a9 to your computer and use it in GitHub Desktop.
SharePoint - Angular REST API base class for lists
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
(function() { | |
angular.module('myApp').factory('sharepointRESTService', sharepointRESTService) | |
sharepointRESTService.$inject = ['$q', '$http', '$location']; | |
function sharepointRESTService($q, $http, $location) { | |
var factoryUtil = {}; | |
var domain_url = "https://company_name.sharepoint.com/sites/site_name"; | |
// HTTP GET | |
factoryUtil.getListItems = function(list_name, filters) { | |
var url = domain_url + "/_api/web/lists/GetByTitle('" + list_name + "')/Items?"; | |
if (!angular.isUndefined(filters)) { | |
url += factoryUtil.build_filters(filters) | |
} | |
var deferred = $q.defer(); | |
$http({ | |
url: url, | |
method: "GET", | |
headers: { | |
"accept": "application/json;odata=verbose", | |
"content-Type": "application/json;odata=verbose" | |
} | |
}).success(function(result) { | |
deferred.resolve(result.d.results); | |
}).error(function(result, status) { | |
deferred.reject({ | |
error: result, | |
status: status | |
}); | |
}); | |
return deferred.promise; | |
}; | |
// HTTP Create | |
factoryUtil.createListItem = function(list_name, data) { | |
data.__metadata = { | |
"type": factoryUtil.getListName(list_name) | |
}; | |
var url = domain_url + "/_api/web/lists/getbytitle('" + list_name + "')/Items"; | |
var deferred = $q.defer(); | |
$http({ | |
url: url, | |
method: "POST", | |
headers: { | |
"accept": "application/json;odata=verbose", | |
"X-RequestDigest": activeUser.getFormDigestValue(), | |
"content-Type": "application/json;odata=verbose" | |
}, | |
data: JSON.stringify(data) | |
}).success(function(result) { | |
deferred.resolve(result); | |
}).error(function(result, status) { | |
deferred.reject({ | |
error: result, | |
status: status | |
}); | |
}); | |
return deferred.promise; | |
}; | |
// HTTP Update | |
factoryUtil.updateListItem = function(list_name, list_id, data) { | |
data.__metadata = { | |
"type": factoryUtil.getListName(list_name) | |
}; | |
var url = domain_url + "/_api/Web/Lists/getByTitle('" + list_name + "')/Items(" + list_id + ")"; | |
var deferred = $q.defer(); | |
$http({ | |
url: url, | |
method: "POST", | |
headers: { | |
"accept": "application/json;odata=verbose", | |
"X-RequestDigest": activeUser.getFormDigestValue(), | |
"content-Type": "application/json;odata=verbose", | |
"X-HTTP-Method": "MERGE", | |
"If-Match": "*" | |
}, | |
data: data | |
}).success(function(result) { | |
deferred.resolve(result); | |
}).error(function(result, status) { | |
deferred.reject({ | |
error: result, | |
status: status | |
}); | |
}); | |
return deferred.promise; | |
}; | |
// HTTP Delete | |
factoryUtil.deleteListItem = function(list_name, list_id) { | |
var url = domain_url + "/_api/Web/Lists/getByTitle('" + list_name + "')/Items(" + list_id + ")"; | |
var deferred = $q.defer(); | |
$http({ | |
url: url, | |
method: "DELETE", | |
headers: { | |
"accept": "application/json;odata=verbose", | |
"X-RequestDigest": activeUser.getFormDigestValue(), | |
"IF-MATCH": "*" | |
} | |
}).success(function(result) { | |
deferred.resolve(result); | |
}).error(function(result, status) { | |
deferred.reject({ | |
error: result, | |
status: status | |
}); | |
}); | |
return deferred.promise; | |
}; | |
// Generate List Name | |
factoryUtil.getListName = function(name) { | |
return "SP.Data." + name.charAt(0).toUpperCase() + name.replace('_', '_x005f_').replace(' ', '').slice(1) + "ListItem"; | |
}; | |
////////////////// | |
// Build filter // | |
////////////////// | |
// var filter = { | |
// select: ['name', 'id'], | |
// expand: { | |
// 'job_title': ['id', 'name'], | |
// 'job_type': ['id', 'name'], | |
// }, | |
// orderby: 'name desc', | |
// filter: { | |
// 'is_approved': ['eq', 'Approved'], | |
// 'status': ['lt', 'Open'] | |
// }, | |
// top : 5, | |
// skip : 5, | |
// }; | |
factoryUtil.build_filters = function(filters) { | |
var url_filter = []; | |
url_filter[0] = []; // select | |
url_filter[1] = []; // orderby | |
url_filter[2] = []; // top | |
url_filter[3] = []; // skip | |
url_filter[4] = []; // filter And | |
url_filter[5] = []; // expand | |
url_filter[6] = []; // filter Or | |
var url = []; | |
if (!angular.isUndefined(filters.select)) { | |
url_filter[0].push(filters.select.join()); | |
} | |
if (!angular.isUndefined(filters.expand)) { | |
angular.forEach(filters.expand, function(columns, field) { | |
angular.forEach(columns, function(value, key) { | |
url_filter[0].push(field + '/' + value); | |
}); | |
url_filter[5].push(field); | |
}); | |
url_filter[5] = '$expand=' + url_filter[5].join(); | |
} | |
if (!angular.isUndefined(filters.orderby)) { | |
url_filter[1] = '$orderby=' + filters.orderby; | |
} | |
if (!angular.isUndefined(filters.top)) { | |
url_filter[2] = '$top=' + filters.top; | |
} | |
if (!angular.isUndefined(filters.skip)) { | |
url_filter[3] = '$skip=' + filters.skip; | |
} | |
if (!angular.isUndefined(filters.filter)) { | |
angular.forEach(filters.filter, function(value, field) { | |
url_filter[4].push('(' + field + ' ' + value[0] + ' \'' + value[1] + '\')'); | |
}); | |
url_filter[4] = '$filter=(' + url_filter[4].join(' and ') + ')'; | |
} | |
if (!angular.isUndefined(filters.filterOr)) { | |
angular.forEach(filters.filterOr, function(value, field) { | |
url_filter[6].push('(' + field + ' ' + value[0] + ' \'' + value[1] + '\')'); | |
}); | |
url_filter[6] = '$filter=(' + url_filter[6].join(' or ') + ')'; | |
} | |
if (url_filter[0].length) url_filter[0] = '$select=' + url_filter[0].join(); | |
angular.forEach(url_filter, function(value, key) { | |
if (url_filter[key].length) url.push(value); | |
}); | |
return url.join('&'); | |
} | |
return factoryUtil; | |
} | |
})() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment