RESTful APIs

To allow programmatic access to the functionality provided by DataSpread we introduce RESTful APIs for DataSpread. These APIs abstract the backend functionality of DataSpread and be used to build an interface for DataSpread. We currently support the following set of API.

Cells

• GET Get Cells
• PUT Put Cells
• PUT Insert Rows
• DELETE Delete Rows
• PUT Insert Columns
• DELETE Delete Columns

Books

• GET Get Books
• POST Add Book
• DELETE Delete Book
• PUT Change Book Name

Sheets

• GET Get Sheets
• POST Add Sheet
• POST Copy Sheet
• DELETE Delete Sheet
• PUT Change Sheet Name
• PUT Move Sheet
• PUT Clear Sheet

Tables

• POST Create Table
• POST Link Table
• POST Reference Table
• POST Unlink Table
• DELETE Drop Table
• PUT Reorder Table
• PUT Filter Table
• GET Get Tables
• DELETE Delete Table Row
• DELETE Delete Table Column
• POST Insert Table Row
• POST Insert Table Column
• PUT Change Table Column Name
• PUT Change Table Column Type
• PUT Update Table Cells

Format

• PUT Change Format

Authorization

• POST Add User
• POST Add Share Book

Two Way Communication

TODOs

• Push formula updates from the back-end using event.
• Overall Error Handling.
• Camal Case.