Get Data by Query 4
POST {{baseUrl}}/api/v1/entities/provider/entries/query
This API functions as API over SQL. It supports SQL like queries. One can customize the query and get the required fields. There are two base models: provider and patient.
A few examples of queries:
select patientid, patientname from patient;
select provider.* from provider where provider.prov_name like
%john%
,select interactions.* from patient where patient.patient_name =
John
;
Request Body
{"query"=>"select * from provider where provider.prov_id in ('1407064009', '12345678', '1114958899', '1841368388', '1578553301');"}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string | ||
Authorization | string |
RESPONSES
status: OK
{}