✓ Get all data from a table.

✓ Get data based on conditions by passing them in query parameters.

✓ Skip rows to get next-page data.

✓ Limitthe number of rows to be returned by a given query.

✓ Sort data based on given fields in ascending or descending order.

✓ Get a count of total number of data available for a given query alongside data.

✓ Get only the required field by passing the selectedquery parameter in it.

✓ Supports getting nested table data by providing deep parameter, across any database type.

✓ Get a huge amount of data. API Maker backend will return data by the streaming method.

✓ This method is very memory efficient to get a huge amount of data.

✓ Get all data from a table.

✓ Get data based on conditions by passing them in query parameters.

✓ Skip rows to get next-page data.

✓ Limit the number of rows to be returned by a given query.

✓ Sort data based on given fields in ascending or descending order.

✓ Get count of total number of data available for a given query alongside data.

✓ Get only required field by passing the selected query parameter in it.

✓ Supports getting nested table data by providing deep parameter, across any database type.

✓ Get only a single database item by id.

✓ Supports primary key override in request.

✓ Get only the required field by passing the selected query parameter in it.

✓ Supports getting nested table data by providing deep parameters, across any database types.

✓ Insert single Or multiple records using this API. Best API for bulk insert data.

✓ Advanced level validations for every field before insert.

✓ Get only the required field by passing the selected query parameter in it.

✓ Supports getting nested table data by providing deep parameter, across any database type.

✓ Automatic generation of dummy data in form of a single object or array of objects.

✓ Multiple save/update operations supported in one API across different types of databases.

• It is a very powerful API for data persistence across database types.

✓ Nested level save/update possible.

✓ Having a capability of insert/update in a single payload.

✓ Manage like Transaction,

• if any operation fails then roll back the whole operation in diff. database like:- Mongo, MySQL, Oracle, etc...

✓ All array operation covered in API Maker :- push, pull, pullAll, pop, set, addToSet

✓ Additional fields are also supported in the payload as shown below, for convenient array operations.

• path, data to push, query to remove, data to pull, direction, position, slice, sort, data to set, array filters, upsert

✓Query params in array operation give us good strength.

✓ Update single database item by id.

✓ Supports primary key override in request.

✓ Get only the required field by passing the selected query parameter in it.

✓ Supports updating nested table data by providing deep parameters, across any database type.

✓ upsert operaiton supported.

• Perform insert if data is not present and perform update operation if row/document is present in the database.

✓ return document option supported to get row/document before update or after the update.

✓ Update multiple records in the database in a single API call.

✓ Replace single database row/document by id.

✓ Supports primary key override in request.

✓ Get only the required field by passing the selected query parameter in it.

✓ Supports updating nested table data by providing deep parameters, across any database type.

✓ upsert operation supported.

• Perform insert if data is not present and perform update operation if row/document is present in the database.

✓ return document option supported to get row/document before update or after the update.

✓ Delete a single database row/document by id.

✓ Supports primary key override in request.

✓ Get only the required field by passing the selected query parameter in it.

✓ Supports updating nested table data by providing deep parameters.

✓ Get all data from a table.

✓ Get data based on conditions by passing them in query parameters.

✓ Skip rows to get next-page data.

✓ Limit the number of rows to be returned by a given query.

✓ Sort data based on given fields in ascending or descending order.

✓ Get a count of total number of data available for a given query alongside with data.

✓ Get only the required field by passing selected query parameter in it.

✓ Supports getting nested table data by providing deep parameters, across any database type.

✓ Get a huge amount of data. API Maker backend will return data by streaming method.

✓ This method is very memory efficient to get a huge amount of data.

✓ Get all data from a table.

✓ Get data based on conditions by passing them in query parameters.

✓ Skip rows to get next-page data.

✓ Limit the number of rows to be returned by a given query.

✓ Sort data based on given fields in ascending or descending order.

✓ Get a count of total number of data available for a given query alongside data.

✓ Get only the required field by passing the selected query parameter in it.

✓ Supports getting nested table data by providing deep parameter, across any database type.

✓ Delete single/multiple e-records.

✓ Below all operator support added in the request body.

• find, sort, skip, limit

✓ Get only the required field by passing the selected query parameter in it.

✓ Supports updating nested table data by providing deep parameters, across any database types

✓ All operators support very well like.. group, sum, concat, match, etc...

✓ With the help of aggregate API, we can perform complex calculations on data easily.

✓ We can count several records .

✓ You have also applied condition in count API.

✓ Get distinct data from the table for a given field.

✓ N number of combinations should be supported in distinct.

✓ find object support in query params.

✓ Get distinct data from the table for a given field.

✓ N number of combinations should be supported in distinct.

✓ find object support in query params.