Get dental

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

Request URL

https://sk-api.khonsongkhla.com/hdc/get?table=dental?{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)
SEQ varchar(16)
DATE_SERV date
DENTTYPE varchar(1)
SERVPLACE varchar(1)
PTEETH decimal(2,0)
PCARIES decimal(2,0)
PFILLING decimal(2,0)
PEXTRACT decimal(2,0)
DTEETH decimal(2,0)
DCARIES decimal(2,0)
DFILLING decimal(2,0)
DEXTRACT decimal(2,0)
NEED_FLUORIDE char(1)
NEED_SCALING char(1)
NEED_SEALANT decimal(2,0)
NEED_PFILLING decimal(2,0)
NEED_DFILLING decimal(2,0)
NEED_PEXTRACT decimal(2,0)
NEED_DEXTRACT decimal(2,0)
NPROSTHESIS char(1)
PERMANENT_PERMANENT decimal(6,0)
PERMANENT_PROSTHESIS decimal(6,0)
PROSTHESIS_PROSTHESIS decimal(6,0)
GUM varchar(6)
SCHOOLTYPE char(1)
CLASS char(1)
PROVIDER varchar(15)
D_UPDATE datetime
CID varchar(13)

Request URL Example

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

Response Example


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