Get service

คำอธิบาย เป็น Api สำหรับดึง
/hdc/get?table=service

Request URL

https://sk-api.khonsongkhla.com/hdc/get?table=service?{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)
PID varchar(15)
HN varchar(15)
SEQ varchar(16)
DATE_SERV date
TIME_SERV varchar(6)
LOCATION varchar(1)
INTIME varchar(1)
INSTYPE varchar(4)
INSID varchar(18)
MAIN varchar(5)
TYPEIN varchar(1)
REFERINHOSP varchar(5)
CAUSEIN varchar(1)
CHIEFCOMP text
SERVPLACE varchar(1)
BTEMP decimal(4,1)
SBP int
DBP int
PR int
RR int
TYPEOUT varchar(1)
REFEROUTHOSP varchar(5)
CAUSEOUT varchar(1)
COST decimal(11,2)
PRICE decimal(11,2)
PAYPRICE decimal(11,2)
ACTUALPAY int
D_UPDATE datetime
HSUB varchar(5)
CID varchar(13)

Request URL Example

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

Response Example


{
    "code": 400,
    "message": "no_permission",
    "message_th": "ไม่มีสิทธิ์อ่านข้อมูล"
}