DEV Community

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

Posted on

4 3 3

🚀 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

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read more →

Top comments (0)

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up