GET /ws/rest/service/v1/level
Purpose:
Get list of level record from Unifier. This works only at project or shell level.
Input:
All parameters should be URL encoded.
URL query parameter -
- project_number(Required): specify the project/shell number to get project/shell level list.
- filter_condition
filter_condition
"filter_condition" : {
"record_fields" : "uuu_floor_id, uuu_floor_name",
"filter_criteria":{
"join":"OR",
"filter":[
{
"field":"status",
"value":"Vacant",
"condition_type":"like"
},
{
"field":"App_date",
"value":"10-09-2019 07:54:00",
"value2":"10-17-2019",
"condition_type":"range"
}
]
}
}
filter_condition key definition
- "record_fields" ( optional ) is list of fields i.e. DE names in Level , only those fields will be listed out in result.
filter_criteria key Definitions:
- "join": (optional)Specify if the filter condition has to be combined using OR or AND operator. Default is AND.
- "filter": List of filter conditions. Each condition will have "field", "value" ("value2" if condition_type is range) and condition_type.
- "field": BP form DE name for which the filter condition has to be applied.
- "value": value for the DE to filter the data.
- "value2": second value for the range condition. Not required to be specified for other conditions.
Possible value for condition_type:
condition_type | notes | Supported Data Element Types |
---|---|---|
like | For string data types. The value can contain the SQL wildcard characters when like is specified | Text ( String ) |
eq | For string, numeric and date data type. Will perform the exact match. | Text ( String ), Number, Cost, Date |
lt | For numeric values. Will perform less than value. | Number, Cost, Date |
gt | For numeric values. Will perform greater than value. | Number, Cost, Date |
lteq | For numeric values. Will perform less than or equal value. | Number, Cost, Date |
gteq | For numeric values. Will perform greater than or equal value. | Number, Cost, Date |
neq | For numeric values. Will perform not equal value. | Text ( String ), Number, Cost, Date |
range | Numeric, Date values. Will perform range search between value and value2 | Number, Cost, Date |
Note: Input Date fields should be provided in "MM-dd-yyyy HH:mm:ss" or ""MM-dd-yyyy" format in filter_criteria.
Output:
JSON object containing 'status', 'data', 'message'
Get Level List output JSON
{
"data": [
{
"App_date": "10/Oct/2019 10:00 AM",
"uuu_sp_level_name": "F-1008"
},
{
"App_date": "10/Oct/2019 12:00 AM",
"uuu_sp_level_name": "F-1009"
},
{
"App_date": "10/Oct/2019 12:00 AM",
"uuu_sp_level_name": "F-1010"
},
{
"App_date": "10/Oct/2019 12:00 AM",
"uuu_sp_level_name": "F-1011"
}
],
"message": [],
"status": 200
}
Status codes are:
1> 200 , for success