DEV Community

Cover image for 🚀 API Maker - Count, Distinct & Distinct with query
API Maker®
API Maker®

Posted on

🚀 API Maker - Count, Distinct & Distinct with query

Count

👉 Get count of rows in database which satisfy our query.

✅ List of Feature
⚡️ Body payload structure is same for all database.
⚡️ Find join feature supported in count API.
⚡️ User applied condition in count API.
⚡️ Number of operator support.

⭐ Supported Operator ⭐

⚡️ $in
⚡️ $nin
⚡️ $and
⚡️ $or
⚡️ $eq
⚡️ $ne
⚡️ $gt
⚡️ $gte
⚡️ $lt
⚡️ $lte
⚡️ $like


Distinct [GET API]

👉 Get distinct data from the table for a given field on ascending or descending order.

⭐ Params ⭐
👉 field ▸ Retrieve the fields based on the user's needs.
👉 order ▸ Sort data in ascending or descending order.

⭐ Query Params ⭐
👉 find ▸ User can retrieve data using find object value.

✅ List of Feature
⚡️ Body payload structure is same for all database.
⚡️ Find object supported in distinct API.
⚡️ N number of combinations should be supported in distinct.

⭐ Supported Operator ⭐

⚡️ $in
⚡️ $nin
⚡️ $and
⚡️ $or
⚡️ $eq
⚡️ $ne
⚡️ $ne
⚡️ $gt
⚡️ $gte
⚡️ $lt
⚡️ $lte
⚡️ $like


Distinct with query [POST API]

👉 Get distinct data from the table for a given field on ascending or descending order.

⭐ Params ⭐
👉 field ▸ Retrieve the fields based on the user's needs.
👉 order ▸ Sort data in ascending or descending order.

⭐ Body ⭐
👉 User can retrieve data using find object value.

✅ List of Feature
⚡️ Body payload structure is same for all database.
⚡️ Find object supported in distinct API.
⚡️ N number of combinations should be supported in distinct.

⭐ Supported Operator ⭐

⚡️ $in
⚡️ $nin
⚡️ $and
⚡️ $or
⚡️ $eq
⚡️ $ne
⚡️ $ne
⚡️ $gt
⚡️ $gte
⚡️ $lt
⚡️ $lte
⚡️ $like


Youtube video link

https://youtu.be/OWCEHr_KWQc

Websites

https://apimaker.dev

API Docs link

https://docs.apimaker.dev/v1/docs/apis-all/generated-apis/auto-generated-count-api.html
https://docs.apimaker.dev/v1/docs/apis-all/generated-apis/auto-generated-distinct-api.html
https://docs.apimaker.dev/v1/docs/apis-all/generated-apis/auto-generated-distinct-with-query-api.html

Follow on twitter

https://twitter.com/api_maker

Linked In

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

More YouTube Videos

https://www.youtube.com/@api_maker/playlists

Top comments (0)