급여대장과 급여명세서 엑셀 만들기

curl --request POST \
  --url 'https://api.xdata.kr/v1/jobs' \
  --header 'Authorization: Basic {base64(client_id:client_secret)}' \
  --header 'X-Env-Scope: real_test' \
  --header 'Idempotency-Key: demo-register_xlsx-001' \
  --header 'Content-Type: application/json' \
  --data '{
  "provider": "payroll_artifact",
  "action": "register_xlsx",
  "params": {
    "attribution_ym": "202608",
    "workplace_name": "예시상사",
    "business_registration_no": "000-00-00000",
    "workplace_address": "서울특별시 예시구 예시로 1",
    "employees": [
      {
        "employee_key": "E001",
        "employee_name": "홍길동",
        "birth_date": "1990-01-15",
        "dependent_count": 1,
        "children_count_8_to_20": 0,
        "monthly_pay_won": 3000000,
        "base_salary_won": 3000000,
        "national_pension_won": 135000,
        "health_insurance_won": 106350,
        "long_term_care_won": 13770,
        "employment_insurance_won": 27000,
        "income_tax_won": 74350,
        "local_income_tax_won": 7430,
        "total_deduction_won": 363900,
        "net_pay_won": 2636100
      },
      {
        "employee_key": "E002",
        "employee_name": "김가나",
        "birth_date": "1985-06-30",
        "dependent_count": 3,
        "children_count_8_to_20": 1,
        "monthly_pay_won": 3500000,
        "base_salary_won": 3500000,
        "national_pension_won": 157500,
        "health_insurance_won": 124075,
        "long_term_care_won": 16065,
        "employment_insurance_won": 31500,
        "income_tax_won": 38960,
        "local_income_tax_won": 3890,
        "total_deduction_won": 371990,
        "net_pay_won": 3128010
      }
    ]
  }
}'

curl --request POST \
  --url 'https://api.xdata.kr/v1/jobs' \
  --header 'Authorization: Basic {base64(client_id:client_secret)}' \
  --header 'X-Env-Scope: real_test' \
  --header 'Idempotency-Key: demo-payslip_xlsx-001' \
  --header 'Content-Type: application/json' \
  --data '{
  "provider": "payroll_artifact",
  "action": "payslip_xlsx",
  "params": {
    "attribution_ym": "202608",
    "workplace_name": "예시상사",
    "business_registration_no": "000-00-00000",
    "workplace_address": "서울특별시 예시구 예시로 1",
    "employees": [
      {
        "employee_key": "E001",
        "employee_name": "홍길동",
        "birth_date": "1990-01-15",
        "dependent_count": 1,
        "children_count_8_to_20": 0,
        "monthly_pay_won": 3000000,
        "base_salary_won": 3000000,
        "national_pension_won": 135000,
        "health_insurance_won": 106350,
        "long_term_care_won": 13770,
        "employment_insurance_won": 27000,
        "income_tax_won": 74350,
        "local_income_tax_won": 7430,
        "total_deduction_won": 363900,
        "net_pay_won": 2636100
      },
      {
        "employee_key": "E002",
        "employee_name": "김가나",
        "birth_date": "1985-06-30",
        "dependent_count": 3,
        "children_count_8_to_20": 1,
        "monthly_pay_won": 3500000,
        "base_salary_won": 3500000,
        "national_pension_won": 157500,
        "health_insurance_won": 124075,
        "long_term_care_won": 16065,
        "employment_insurance_won": 31500,
        "income_tax_won": 38960,
        "local_income_tax_won": 3890,
        "total_deduction_won": 371990,
        "net_pay_won": 3128010
      }
    ],
    "payment_date": "2026-08-25"
  }
}'

import { writeFile } from 'node:fs/promises';

const api = process.env.XBOSS_API_URL ?? 'https://api.xdata.kr';
const auth = 'Basic ' + Buffer.from(`${process.env.XBOSS_CLIENT_ID}:${process.env.XBOSS_CLIENT_SECRET}`).toString('base64');
const headers = { Authorization: auth, 'X-Env-Scope': 'real_test' };

const params = {
  "attribution_ym": "202608",
  "workplace_name": "예시상사",
  "business_registration_no": "000-00-00000",
  "workplace_address": "서울특별시 예시구 예시로 1",
  "employees": [
    {
      "employee_key": "E001",
      "employee_name": "홍길동",
      "birth_date": "1990-01-15",
      "dependent_count": 1,
      "children_count_8_to_20": 0,
      "monthly_pay_won": 3000000,
      "base_salary_won": 3000000,
      "national_pension_won": 135000,
      "health_insurance_won": 106350,
      "long_term_care_won": 13770,
      "employment_insurance_won": 27000,
      "income_tax_won": 74350,
      "local_income_tax_won": 7430,
      "total_deduction_won": 363900,
      "net_pay_won": 2636100
    },
    {
      "employee_key": "E002",
      "employee_name": "김가나",
      "birth_date": "1985-06-30",
      "dependent_count": 3,
      "children_count_8_to_20": 1,
      "monthly_pay_won": 3500000,
      "base_salary_won": 3500000,
      "national_pension_won": 157500,
      "health_insurance_won": 124075,
      "long_term_care_won": 16065,
      "employment_insurance_won": 31500,
      "income_tax_won": 38960,
      "local_income_tax_won": 3890,
      "total_deduction_won": 371990,
      "net_pay_won": 3128010
    }
  ]
};

// 1. 작업을 제출합니다. 같은 요청을 다시 보낼 때는 같은 Idempotency-Key 를 씁니다.
const submitted = await fetch(`${api}/v1/jobs`, {
  method: 'POST',
  headers: { ...headers, 'Content-Type': 'application/json', 'Idempotency-Key': 'payroll-register-202608-001' },
  body: JSON.stringify({ provider: 'payroll_artifact', action: 'register_xlsx', params }),
});
if (!submitted.ok) throw new Error(`제출 실패 ${submitted.status}`);
const { job_id: jobId } = await submitted.json();

// 2. 끝날 때까지 상태를 확인합니다.
let job;
do {
  await new Promise((resolve) => setTimeout(resolve, (job?.retry_after_seconds ?? 1) * 1000));
  job = await (await fetch(`${api}/v1/jobs/${jobId}`, { headers })).json();
} while (job.status === 'QUEUED' || job.status === 'RUNNING');

if (job.status !== 'SUCCEEDED') {
  // 입력값 문제는 provider_error_ref 로 가립니다(예: payroll_artifact.missing_birth_date). 값을 고친 뒤 새 Idempotency-Key 로 다시 제출합니다.
  throw new Error(`${job.error.code} ${job.error.provider_error_ref}: ${job.error.message}`);
}

// 3. 결과의 파일 목록에서 주소를 받아 내려받습니다. 주소 자체가 서명돼 있어 인증 헤더를 붙이지 않습니다.
const result = await (await fetch(`${api}/v1/jobs/${jobId}/result`, { headers })).json();
const [artifact] = result.result.artifacts;
const file = await fetch(artifact.download_url);
await writeFile(artifact.name, Buffer.from(await file.arrayBuffer()));

import base64
import os
import time

import requests

api = os.environ.get("XBOSS_API_URL", "https://api.xdata.kr")
auth = base64.b64encode(
    f"{os.environ['XBOSS_CLIENT_ID']}:{os.environ['XBOSS_CLIENT_SECRET']}".encode()
).decode()
headers = {"Authorization": f"Basic {auth}", "X-Env-Scope": "real_test"}

params = {
    "attribution_ym": "202608",
    "workplace_name": "예시상사",
    "business_registration_no": "000-00-00000",
    "workplace_address": "서울특별시 예시구 예시로 1",
    "employees": [
        {
            "employee_key": "E001",
            "employee_name": "홍길동",
            "birth_date": "1990-01-15",
            "dependent_count": 1,
            "children_count_8_to_20": 0,
            "monthly_pay_won": 3000000,
            "base_salary_won": 3000000,
            "national_pension_won": 135000,
            "health_insurance_won": 106350,
            "long_term_care_won": 13770,
            "employment_insurance_won": 27000,
            "income_tax_won": 74350,
            "local_income_tax_won": 7430,
            "total_deduction_won": 363900,
            "net_pay_won": 2636100
        },
        {
            "employee_key": "E002",
            "employee_name": "김가나",
            "birth_date": "1985-06-30",
            "dependent_count": 3,
            "children_count_8_to_20": 1,
            "monthly_pay_won": 3500000,
            "base_salary_won": 3500000,
            "national_pension_won": 157500,
            "health_insurance_won": 124075,
            "long_term_care_won": 16065,
            "employment_insurance_won": 31500,
            "income_tax_won": 38960,
            "local_income_tax_won": 3890,
            "total_deduction_won": 371990,
            "net_pay_won": 3128010
        }
    ]
}

# 1. 작업을 제출합니다. 같은 요청을 다시 보낼 때는 같은 Idempotency-Key 를 씁니다.
submitted = requests.post(
    f"{api}/v1/jobs",
    headers={**headers, "Idempotency-Key": "payroll-register-202608-001"},
    json={"provider": "payroll_artifact", "action": "register_xlsx", "params": params},
    timeout=30,
)
submitted.raise_for_status()
job_id = submitted.json()["job_id"]

# 2. 끝날 때까지 상태를 확인합니다.
while True:
    job = requests.get(f"{api}/v1/jobs/{job_id}", headers=headers, timeout=30).json()
    if job["status"] not in ("QUEUED", "RUNNING"):
        break
    time.sleep(job.get("retry_after_seconds") or 1)

if job["status"] != "SUCCEEDED":
    # 입력값 문제는 provider_error_ref 로 가립니다(예: payroll_artifact.missing_birth_date). 값을 고친 뒤 새 Idempotency-Key 로 다시 제출합니다.
    error = job["error"]
    raise RuntimeError(f"{error['code']} {error['provider_error_ref']}: {error['message']}")

# 3. 결과의 파일 목록에서 주소를 받아 내려받습니다. 주소 자체가 서명돼 있어 인증 헤더를 붙이지 않습니다.
result = requests.get(f"{api}/v1/jobs/{job_id}/result", headers=headers, timeout=30).json()
artifact = result["result"]["artifacts"][0]
file = requests.get(artifact["download_url"], timeout=60)
file.raise_for_status()
with open(artifact["name"], "wb") as handle:
    handle.write(file.content)