Hey, you can follow this approach to create custom api using strapi. Use the linked example and append it with your custom logic.
Also refer to Query engine API docs for better clarification Query Engine API | Strapi Documentation
1 Like