Product Catalog API

Custom Query

SELECT p.id, p.name, p.price, p.stock, c.name as category FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.is_active = 1

Response Fields

id name price stock category

Default Filters

{
    "is_active": 1
}

Allowed Filters

category price_min price_max in_stock

Test Endpoint