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": "ไม่มีสิทธิ์อ่านข้อมูล"
}