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

KeyDatatypeRequiredDescription
Content-Typestring
Authorizationstring

RESPONSES

status: OK

{}