Search a CodePlex project

Project Description
Camelot JSON API for Microsoft SharePoint enables CRUD operations with SharePoint 2007, 2010 and 2013 by using JSON.


We do offer support, contact us at [email protected] or by using the discussions tab here at codeplex.

A powerful JSON API for SharePoint

Communicate with SharePoint using JSON; get your responses from SharePoint in JSON. The Camelot JSON API can be used in any .NET Web Application including SharePoint (2007, 2010 or 2013).

Example to read the fields ID, Title and PercentComplete from the list 'Tasks'

	List: "Tasks", 
	Fields: "ID, Title, PercentComplete" 

Example to insert a record in a standard Task list

	List: "Tasks", 
	Type: "INSERT", 
	Fields: [
		{ "Title": "Update documentation" }, 
		{ "StartDate": "2013-01-01" }, 
		{ "DueDate": "2013-06-30" }, 
		{ "AssignedTo": "1" }, 
		{ "Priority": "(1) High" }, 
		{ "Status": "In Progress" }, 
		{ "PercentComplete": "0.1" }, 
		{ "Body": "This is a test task added from JSON" }],
	Connection: "Default"

Examples using SQL

Select all items from the list Tasks

	Sql: "SELECT * FROM Tasks" 

Delete all items from the list Tasks that are 100 % done.

	Sql: "DELETE FROM Tasks WHERE PercentComplete = '1'" 

Executing commands

See more snippets at

// Build the command
var command = 	{
		Type: "SELECT",
		List: "Tasks"

// Declare outside of the ajax call to be able to read the data for testing
var result;

// Send the command
	type: "GET",
	contentType: "application/json",
	data: { command: JSON.stringify(command)},
	url: "/_vti_bin/Camelot.JSONAPI/jsonapi.svc/Items",
	success: function (data) {
		// Decode and store the result in a variable
		result = $.parseJSON(data.d);
		console.log("Successfully executed the command, please check the 'result' variable.");
	error: function (xhr, textStatus, errorThrown) {



Please check the documentation for usage guides and installation

Not affiliated with Microsoft and CodePlex
To remove your project or any question, please contact us: [email protected]