Query for get data API [ Find Join ]
✅ 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
- 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]