Web API Server

Read all Categories

Parameters
Not required

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Read one Category by id

Parameters
Id [Int]

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Add a new Category

Parameters
Not required

Format:

{
"name": "category_name"
}

Status Code
201 Created
400 Bad request
404 Not found
422 Error execute query

Response

Update Category by id

Parameters
Id [Int]

Format:

{
"name": "category_name"
}

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Delete Category by id

Parameters
Id [Int]

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Read all Products

Parameters
Not required

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Read one Product by id

Parameters
Id [Int]

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Add a new Product

Parameters
Not required

Format:

{
"cat_id": category_id,
"code": "product_code",
"name": "product_name",
"price": 0
}

Status Code
201 Created
400 Bad request
404 Not found
422 Error execute query

Response

Update Product by id

Parameters
Id [Int]

Format:

{
"cat_id": category_id,
"code": "product_code",
"name": "product_name",
"price": 0
}

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Delete Product by id

Parameters
Id [Int]

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Read all Products joined by Category

Parameters
Not required

Status Code
200 Success
400 Bad request
404 Not found
422 Error execute query

Response

Read all Products joined by Category and filter by keywords

Parameters
Not required

Format:

{
"keywords": "keywords"
}

Status Code
201 Created
400 Bad request
404 Not found
422 Error execute query

Response

WEB API SERVER

Categories

Products

Find