Get person

คำอธิบาย เป็น Api สำหรับดึง

Request URL

https://sk-api.khonsongkhla.com/hdc/get?table=person?{param}

Path Parameters

Name	Type	Required	Description
param	String	-	sort=ASC|DESC sortBy=[Field name] offset=(int)[Row start] limit=(int)[Row limit] [Field name]=[value]

Response Body

Name	Type	Description
HOSPCODE	varchar(5)
CID	varchar(13)
PID	varchar(15)
HID	varchar(14)
PRENAME	varchar(3)
NAME	varchar(50)
LNAME	varchar(50)
HN	varchar(15)
SEX	varchar(1)
BIRTH	date
MSTATUS	char(1)
OCCUPATION_OLD	varchar(3)
OCCUPATION_NEW	varchar(4)
RACE	varchar(3)
NATION	varchar(3)
RELIGION	varchar(2)
EDUCATION	varchar(2)
FSTATUS	varchar(1)
FATHER	varchar(13)
MOTHER	varchar(13)
COUPLE	varchar(13)
VSTATUS	varchar(1)
MOVEIN	date
DISCHARGE	varchar(1)
DDISCHARGE	date
ABOGROUP	varchar(1)
RHGROUP	varchar(1)
LABOR	varchar(2)
PASSPORT	varchar(20)
TYPEAREA	varchar(1)
D_UPDATE	datetime
TELEPHONE	varchar(15)
MOBILE	varchar(15)

Request URL Example

https://sk-api.khonsongkhla.com/hdc/get?table=person&limit=2

Response Example

{
    "data": [
        {
            "HOSPCODE": "09437",
            "CID": "5900100005031",
            "PID": "1",
            "HID": "1204",
            "PRENAME": "005",
            "NAME": "ลิ่ม",
            "LNAME": "อุนตรีจันทร์",
            "HN": "1",
            "SEX": "2",
            "BIRTH": "1943-01-01",
            "MSTATUS": "3",
            "OCCUPATION_OLD": "014",
            "OCCUPATION_NEW": "9001",
            "RACE": "099",
            "NATION": "099",
            "RELIGION": "01",
            "EDUCATION": "02",
            "FSTATUS": "2",
            "FATHER": null,
            "MOTHER": null,
            "COUPLE": "3900100155339",
            "VSTATUS": null,
            "MOVEIN": "2004-09-28",
            "DISCHARGE": "1",
            "DDISCHARGE": "2023-03-22",
            "ABOGROUP": "2",
            "RHGROUP": null,
            "LABOR": null,
            "PASSPORT": null,
            "TYPEAREA": "2",
            "D_UPDATE": "2023-11-06 14:24:04",
            "TELEPHONE": null,
            "MOBILE": null
        },
        {
            "HOSPCODE": "09437",
            "CID": "3900100155398",
            "PID": "10",
            "HID": "1121",
            "PRENAME": "005",
            "NAME": "ปุณยนุช",
            "LNAME": "อุนตรีจันทร์",
            "HN": "10",
            "SEX": "2",
            "BIRTH": "1974-04-15",
            "MSTATUS": "2",
            "OCCUPATION_OLD": "014",
            "OCCUPATION_NEW": "9001",
            "RACE": "099",
            "NATION": "099",
            "RELIGION": "01",
            "EDUCATION": "03",
            "FSTATUS": "2",
            "FATHER": "3900100155339",
            "MOTHER": "5900100005031",
            "COUPLE": "3900600205807",
            "VSTATUS": null,
            "MOVEIN": "2005-03-18",
            "DISCHARGE": "9",
            "DDISCHARGE": null,
            "ABOGROUP": "2",
            "RHGROUP": null,
            "LABOR": null,
            "PASSPORT": null,
            "TYPEAREA": "1",
            "D_UPDATE": "2022-03-22 09:33:46",
            "TELEPHONE": "0926996123",
            "MOBILE": null
        }
    ],
    "code": 200,
    "message": "success",
    "message_th": "ดึงข้อมูลสำเร็จ",
    "sql": "select * from person where 1    limit 0, 2"
}