Full CRUD API

Author: Allan Jardine 28th October 2021

With today's update to CloudTables, we introduce a full Create, Read, Update, and Delete (CRUD) API to compliment the read and editing abilities of CloudTables when embedded into pages. This can be particularly important for monitoring and reporting applications where you want to automate the data creation in CloudTables, but have a clean and easy to use UI to view and understand the data.

RESTful API

Our REST API offers full support for creating rows, editing and deleting, in addition to the read methods we already had available. For example to create a new row with an HTTP request you might use:

curl \
	-X POST \
	-d key=:apiKey \
	-d dp-1="My new row" \
	-d dp-2=3 \
	https://mySubdomain.cloudtables.io/api/1/dataset/:id

The exact parameters are URL will depend upon your CloudTables configuration. We know how important documentation is for something like an API - it has to be comprehensive, understandable and correct, so we've put a lot of work into getting it right. For example, this is the documentation for the above row creation API. We'd love to get your feedback on this.

NodeJS

Our NodeJS API libraries for CloudTables have been updated to make full use of this new CRUD API, along with their documentation. To continue the example from above of inserting new data, the same call in NodeJS would be:

const api = new CloudTablesApi('mySubdomain', ':apiKey');

await api.dataset(':id').insert({
	'dp-1': 'My new row',
	'dp-2': 3
});

Other server-side libraries

Our other server-side libraries (currently Java, .NET and PHP) will be updated to make full use of the new CRUD API in due course. If you have requirements for a specific one of these languages, please get in touch so we can expedite the updates.