Custom queries

SELECT 
  categories.id AS category_id,
  categories.name AS category_name,
  posts.id AS post_id,
  posts.description
FROM categories
JOIN posts ON posts.category_id = categories.id
WHERE categories.name = '{category_name}';

https://api.eazemyapi.com/{project}/{version}/{query-name}

https://api.eazemyapi.com/demo-project/v1/posts-by-category

curl https://api.eazemyapi.com/demo-project/v1/posts-by-category \
  -H "X-API-SIGNATURE: your-secret-key"

{
  "success": true,
  "message": "Data found.",
  "data": [
    {
      "category_id": "c40a4731-a541-4d2b-af77-326af7142aab",
      "category_name": "Foods",
      "post_id": "2529c967-33a3-4f7b-aabd-84e90f861e14",
      "description": "Best restaurant in the world"
    },
    {
      "category_id": "c40a4731-a541-4d2b-af77-326af7142aab",
      "category_name": "Foods",
      "post_id": "5f8b35c8-372c-4ab2-9c01-569085f05a72",
      "description": "Best restaurant in Ahmedabad"
    }
  ]
}

SELECT *
FROM posts
WHERE category_id = '{category_id}';

https://api.eazemyapi.com/demo-project/v1/posts-by-category?category_id=c40a4731-a541-4d2b-af77-326af7142aab