API Maker Features

Auto Generated APIs

Powerful Auto Generated APIs

Connect the Database and enjoy autogenerated APIs. Below is the Schema APIs and Generated APIs list.

Get All Auto Generated APIGET
  • 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.
  • Limit the number of rows to be returned by a given query.
  • 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.
Get All By Stream Auto Generated APIGET
  • 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 All By Stream Auto Generated APIGET
  • 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.
Distinct Auto Generated APIGET
  • 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.
Distinct With Query Auto Generated APIGETPOST
  • 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.
Distinct With Query Auto Generated APIPUT
  • 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 Many Auto Generated APIPUT
  • Update multiple records in the database in a single API call.
Replace By Id Auto-Generated APIPUT
  • 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.
Array Operations Auto-Generated Api [Mongo Database Only]PUT
  • 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.
Save Single/Multiple Auto Generated APIPOST
  • 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.
Master [Save/Update] [Single/Multiple] Auto Generated APIPOST
  • 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...
Query For Get Data Auto-Generated APIPOST
  • 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.
Remove By Query Auto Generated APIPOST
  • 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
Aggregate Auto Generated Api [Mongo Database Only]POST
  • 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.
Aggregate Auto Generated Api [Mongo Database Only]POST
  • We can count several records.
  • You have also applied condition in count API.
Remove By Id Auto-Generated APIDelete
  • 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.