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

Support

We do offer support, contact us at support@bendsoft.com 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 https://camelotjson.codeplex.com/wikipage?title=Testing

// 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
$.ajax({
	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) {
		console.log(errorThrown);
	}
});

 


Documentation

Please check the documentation for usage guides and installation

Last edited Jan 24, 2013 at 4:07 PM by Bendsoft, version 11