DEV Community

Cover image for 🚀 API Maker - Query for get data API [ Find Join ]
API Maker®
API Maker®

Posted on

🚀 API Maker - 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
▸ 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

https://youtu.be/B8T6qhB2iWw

Websites

https://apimaker.dev

API Docs link

https://docs.apimaker.dev/v1/docs/apis-all/generated-apis/auto-generated-query-for-get-data-api.html

Follow on twitter

https://twitter.com/api_maker

Linked In

https://www.linkedin.com/company/api-maker

Top comments (0)