DEV Community

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

Posted on

4 3 3

🚀 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

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