SKU Produk — Scuro Asset Management

#	Group	Subgroup	Category	Subcategory	Total SKU
Belum ada data. Tekan tombol Retrieve untuk mengambil data.

Endpoint URL

GET https://www.wsap.scurogroup.com/api/index.php?api=1&token=c8ca705c-d3df-403c-be24-0bbd95fd7d5a

Authentication

Query Parameter: token=c8ca705c-d3df-403c-be24-0bbd95fd7d5a

Required: Yes

SQL Query

SELECT group_name, subgroup_name, category_name, subcategory_name, COUNT(1) AS total_sku
FROM master_sku
WHERE status='approved'
GROUP BY group_name, subgroup_name, category_name, subcategory_name

Success Response (200 OK)

{
  "status": "ok",
  "count": 42,
  "data": [
    {
      "group_name": "...",
      "subgroup_name": "...",
      "category_name": "...",
      "subcategory_name": "...",
      "total_sku": "10"
    }
  ]
}

Error Responses

401 Unauthorized: Invalid or missing API token.

500 Database connection failed atau Query error.