CRUD routes
Overview
Where Mockoon routes are independent and stateless, CRUD routes can generate multiple endpoints to perform CRUD operations (Create, Read, Update, Delete) on data buckets. Data buckets are generated when the server start, their state persisting between calls. It makes them the perfect tool to simulate small databases.
A CRUD endpoint will automatically create a series of routes during runtime, allowing you to perform actions on your data bucket. A typical example is an array of resources (users, invoices, etc.) you can update through a PUT request and see the result in a subsequent GET request.
To create a CRUD route, click on the "CRUD route" entry in the add menu:
Then, set its path, usually a resource name:
Your path can be more complex, and contains parameters or multiple sections. Remember that this will be the "prefix" of the different endpoints (see below).
Data bucket link
After creating a CRUD endpoint, you need to link it to a data bucket:
Head over to our data buckets documentation to learn how to create a new data bucket.
Supported content
The CRUD route will work with any content stored in your data bucket: valid JSON in the form of an array of objects, an object, a primitive, etc., or any non-valid JSON. The route behaviors will vary depending on the content stored in the bucket (see table below).
Resetting the data bucket content
The data bucket content is generated when the server starts, and its state persists between calls. However, its state will not be saved in the data file, and you can reset it to its initial state by restarting the mock API.
CRUD route differences
When creating a CRUD route, you may notice some differences in the interface, namely:
- The route HTTP method cannot be set and will be handled automatically.
- The status code cannot be changed and will be set automatically while performing operations.
- A fixed and default route response is automatically created and must be linked to a data bucket in order to perform CRUD operations.
Latency and custom headers can still be added. However, an application/json Content-Type will be forced when appropriate.
Also, CRUD routes are still compatible with creating multiple responses and rules. The major difference is that the default route response cannot be set and will always be the first one linked to the data bucket. This response cannot be deleted nor reordered. Aside from these differences everything else still applies.
List of routes and operations
Mockoon will automatically translate a CRUD endpoint to multiple routes allowing for a wide range of behaviors. The system is very flexible and allows for any content, storing and updating primitives to simulate a flag or environment variable system, updating and sorting an array of objects, etc.
| Array of objects | Array of primitives (id parameter is acting like an index) | Object, primitive or non-valid JSON | ||
|---|---|---|---|---|
| GET | /resources | Returns the entire array * | Returns the entire array * | Returns the content |
| GET | /resources/:id | Returns an object by its id property | Returns an item by its index | Returns the content |
| POST | /resources | Inserts a new object in the array (autogenerate the id (UUID) if not provided) | Inserts a new item in the array | Overwrites the content |
| PUT | /resources | Replaces the whole data bucket content | Replaces the whole data bucket content | Overwrites the content |
| PUT | /resources/:id | Performs a full object update by its id (replace) | Replaces the item at index | Overwrites the content |
| PATCH | /resources | Concatenates the arrays | Concatenates the arrays | Overwrites the content (merge if objects) |
| PATCH | /resources/:id | Performs a partial object update by its id (merge) | Replaces the item at index | Overwrites the content (merge if objects) |
| DELETE | /resources | Deletes the data bucket content | Deletes the data bucket content | Deletes the content |
| DELETE | /resources/:id | Deletes an object by its id | Deletes an item at index | Deletes the content |
* Supports sorting and pagination
⚠️ Note: You can expect the above results assuming that you are sending the same type of content that the one stored in the data bucket (array ↔ array, object ↔ object, etc.). However, the system is very permissive, and you may push any content in an array, ending up with mixted type contents or replacing content with data of a different type.
Overriding a route
You can easily override a CRUD operation route by declaring a regular HTTP route and putting it above the CRUD route (see routes order). This route will intercept the request allowing you to serve custom content for this operation.
Sorting and pagination on the main GET route
The main GET /path route supports sorting and pagination when working with an array.
Sorting
To sort an array, you can use the sort and order query parameters. You can sort by any property in the objects (strings or numbers) and order by either ascending or descending order:
GET /path?sort=name&order=desc
Sorting is also working on arrays of primitives (strings, numbers, etc.), in which case, the presence of the sort parameter is enough:
GET /path?sort&order=asc
Pagination
To paginate an array, you can use the page and limit query parameters. If you omit the limit parameter, it will default to 10 per page. If you omit the page parameter, it will show you the first x items.
Examples:
-
second set of 25 items:
GET /path?page=2&limit=25 -
first 50 items:
GET /path?limit=50 -
second set of 10 items:
GET /path?page=2
Pagination will be applied after sorting, both can be cumulated:
GET /path?sort=name&page=2&limit=25
When using pagination, a X-Total-Count header will be present in the response with the total number of items.