Get Yearly Report

# ดึงรายงาน JSON แบบแบ่งหน้า
curl -X GET "https://openapi.humansoft.co.th/api/v1/open-apis/salary/get-data-filter?path_action=get_all_year_quota_report&quota_year=2026&_page=1&_number_per_page=100" \
  -H "Ocp-Apim-Subscription-Key: YOUR_API_KEY"
 
# Export เป็น Excel
curl -X GET "https://openapi.humansoft.co.th/api/v1/open-apis/salary/get-data-filter?path_action=get_all_year_quota_report&quota_year=2026&type=excel" \
  -H "Ocp-Apim-Subscription-Key: YOUR_API_KEY" \
  --output quota_report_2026.xlsx
 
# Export เป็น PDF เฉพาะแผนก
curl -X GET "https://openapi.humansoft.co.th/api/v1/open-apis/salary/get-data-filter?path_action=get_all_year_quota_report&quota_year=2026&type=pdf&department_id=MjAyNTEwMDYxOTJGRTg4RTk3QTU=" \
  -H "Ocp-Apim-Subscription-Key: YOUR_API_KEY" \
  --output quota_report_dept.pdf

// ดึงรายงาน JSON
const response = await fetch(
  'https://openapi.humansoft.co.th/api/v1/open-apis/salary/get-data-filter?path_action=get_all_year_quota_report&quota_year=2026&_page=1&_number_per_page=100',
  {
    method: 'GET',
    headers: {
      'Ocp-Apim-Subscription-Key': 'YOUR_API_KEY'
    }
  }
)
const data = await response.json()
data.payload.lists.forEach(emp => {
  emp.leave_types.forEach(lt => {
    console.log(`${emp.employee_code} - ${lt.leave_type_name}: ${lt.remaining}/${lt.quota}`)
  })
})

import requests
 
url = "https://openapi.humansoft.co.th/api/v1/open-apis/salary/get-data-filter"
headers = {"Ocp-Apim-Subscription-Key": "YOUR_API_KEY"}
 
# ดึงรายงาน JSON
params = {"path_action": "get_all_year_quota_report", "quota_year": "2026", "_page": "1", "_number_per_page": "100"}
response = requests.get(url, headers=headers, params=params)
data = response.json()
for emp in data["payload"]["lists"]:
    for lt in emp["leave_types"]:
        print(f"{emp['employee_code']} - {lt['leave_type_name']}: {lt['remaining']}/{lt['quota']}")
 
# Export เป็น Excel
params = {"path_action": "get_all_year_quota_report", "quota_year": "2026", "type": "excel"}
response = requests.get(url, headers=headers, params=params)
with open("quota_report_2026.xlsx", "wb") as f:
    f.write(response.content)

<?php
$url = "https://openapi.humansoft.co.th/api/v1/open-apis/salary/get-data-filter?path_action=get_all_year_quota_report&quota_year=2026&_page=1&_number_per_page=100";
 
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_HTTPHEADER, ["Ocp-Apim-Subscription-Key: YOUR_API_KEY"]);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
 
$response = curl_exec($ch);
curl_close($ch);
 
$data = json_decode($response, true);
foreach ($data["payload"]["lists"] as $emp) {
    foreach ($emp["leave_types"] as $lt) {
        echo "{$emp['employee_code']} - {$lt['leave_type_name']}: {$lt['remaining']}/{$lt['quota']}\n";
    }
}
?>