...
Page Properties | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Purpose
This WS is dedesigned to return Medications list by filters.
APIary
Input parameters (filters)
- id (optional)
- innm_id (optional)
- name (optional, as `LIKE *`)
- innm_name (optional, as `LIKE *`)
- form (optional)
Logic WS
- Verify the validity of access token
- Check user scopes in order to perform this action (scope = 'medication:read')
Search Medications by filters in payload
Code Block language sql SELECT * FROM medications MED LEFT JOIN medications INNM ON MED.ingredients.id = INNM.id AND INNM.is_active == TRUE WHERE MED.is_active == TRUE AND MED.type == MEDICATION AND (MED.id == $.id OR $.id IS NULL) AND (INNM.id == $.innm_id OR $.innm_id IS NULL) AND (MED.form == $.form OR $.form IS NULL) AND (MED.name LIKE `%$.name%` OR $.name IS NULL) AND (INNM.name LIKE `%$.innm_name%` OR $.innm_name IS NULL)
Prepare & return response data structure
- Fill response WS data structure
- Validate response using JSON schemas (!!! TBD)
- Return 422 with list of validation errors in case validation fails (422 EView)