Get drug_ipd

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

Request URL

https://sk-api.khonsongkhla.com/hdc/get?table=drug_ipd?{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)
AN varchar(9)
DATETIME_ADMIT datetime
WARDSTAY varchar(5)
TYPEDRUG char(1)
DIDSTD varchar(24)
DNAME varchar(255)
DATESTART date
DATEFINISH date
AMOUNT decimal(12,0)
UNIT varchar(3)
UNIT_PACKING varchar(20)
DRUGPRICE decimal(11,2)
DRUGCOST decimal(11,2)
PROVIDER varchar(15)
D_UPDATE datetime
CID varchar(13)

Request URL Example

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

Response Example


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