Excel Receiving Import

curl -X POST "https://openapi.humansoft.co.th/api/v1/open-apis/salary/add-data-filter?path_action=excel_receiving_import" \
  -H "Ocp-Apim-Subscription-Key: YOUR_API_KEY" \
  -F "_fileUpd=@/path/to/receiving_quota.xlsx" \
  -F "select_year=2027"

const formData = new FormData()
formData.append('_fileUpd', fileInput.files[0])
formData.append('select_year', '2027')
 
const response = await fetch(
  'https://openapi.humansoft.co.th/api/v1/open-apis/salary/add-data-filter?path_action=excel_receiving_import',
  {
    method: 'POST',
    headers: {
      'Ocp-Apim-Subscription-Key': 'YOUR_API_KEY'
    },
    body: formData
  }
)
const data = await response.json()
console.log(`Imported: ${data.payload.insert_record} new, ${data.payload.update_record} updated, ${data.payload.error_record} errors`)

import requests
 
url = "https://openapi.humansoft.co.th/api/v1/open-apis/salary/add-data-filter?path_action=excel_receiving_import"
headers = {"Ocp-Apim-Subscription-Key": "YOUR_API_KEY"}
files = {"_fileUpd": open("/path/to/receiving_quota.xlsx", "rb")}
data = {"select_year": "2027"}
 
response = requests.post(url, headers=headers, files=files, data=data)
result = response.json()
p = result["payload"]
print(f"Imported: {p['insert_record']} new, {p['update_record']} updated, {p['error_record']} errors")

<?php
$url = "https://openapi.humansoft.co.th/api/v1/open-apis/salary/add-data-filter?path_action=excel_receiving_import";
 
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, ["Ocp-Apim-Subscription-Key: YOUR_API_KEY"]);
curl_setopt($ch, CURLOPT_POSTFIELDS, [
    "_fileUpd" => new CURLFile("/path/to/receiving_quota.xlsx"),
    "select_year" => "2027"
]);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
 
$response = curl_exec($ch);
curl_close($ch);
 
$data = json_decode($response, true);
$p = $data["payload"];
echo "Imported: {$p['insert_record']} new, {$p['update_record']} updated, {$p['error_record']} errors\n";
?>