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

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay