✅ Find Join [Query for get data API]
▸ to retrieve data from multiple tables across multiple databases at any level of depth.
✅ To perform Find join operation, you need two main things,
▸ The criteria specified in the body section.
▸ A well-defined table schema.
✅ N-number of Nested level deep possible
▸ Retrieving data from any number of nested levels, without any limit.
✅ Multiple database support
▸ Allowing data retrieval from multiple databases within the same payload.
▸ like, Sellers product listed on MongoDB > product collection and Buyers order transaction maintain on oracle > order_transaction table, that is possible using this API.
✅ Records can be retrieved with validation and conversion.
▸ having some inbuilt validation and conversion functionality in schema.
✅ Generate a complete payload with predefined conditions.
▸ Based on schema, user can generate payload with a single click by using Generated Data option in body section.
✅ Modify response
▸ find, skip, limit, sort, select, deep inbuilt support.
⭐ Validation ⭐
👉 API Maker validate the payload using below validator.
▸ required
▸ email
▸ max
▸ maxLength
▸ min
▸ minLength
▸ unique
▸ validatorFun [Custom validator function]
⭐ Conversion ⭐
👉 API Maker can convert the payload using below conversion.
▸ encryption
▸ hashing
▸ toLowerCase
▸ toUpperCase
▸ trim
▸ trimStart
▸ trimEnd
▸ conversionFun [Custom conversion function]
⭐ Supported Operator ⭐
⚡️ $in
⚡️ $nin
⚡️ $and
⚡️ $or
⚡️ $eq
⚡️ $ne
⚡️ $gt
⚡️ $gte
⚡️ $lt
⚡️ $lte
⚡️ $like
Youtube video link
Websites
API Docs link
https://docs.apimaker.dev/v1/docs/apis-all/generated-apis/auto-generated-query-for-get-data-api.html
Top comments (0)