Developer
Search…
Read Records By View
Get all records by a specific view:
URL : /api/v1/app/{app_id}/view/{view_id} Method : GET
Parameters:
access_token (required, header parameter) Send this as header – e.g.“Authorization: Bearer access_token”
app_id (required, header parameter) Application Id
view_id (required, header parameter) View Id

Filter Parameters (Optional) :

Method – GET – for filtering data
filter_columns Column Ids. To filter data for multiple columns, use “|” as separator e.g. filter_columns=2|3|4
filter_values Values that needs to be matched. To filter data using multiple values, use “|” as separator e.g. filter_columns=2|2|4and filter_values=Column2Text1|Column2Text2|Column4
filter_apps App Ids for the columns (only applicable for columns from Lookup App). To filter data using multiple apps, use “|” as separator
filter_operators Operators to use for filtering data. To use multiple operators, use “|” as separator e.g. filter_operators=0|0|1.
Operator codes are as below:
0 : contains
1 : does not contain
2 : equals
3 : does not equal
4 : empty
5 : not empty
6 : less than
7 : less than or equal to
8 : greater than
9 : greater than or equal to

Sample Request

curl -H "Authorization: Bearer {access_token}" https://my.worksmart.app/api/v1/app/123/view/456

Sample Response

1
{
2
"data":[
3
{
4
"a30":"DEMO00000"
5
},
6
{
7
"a30":"DEMO00002"
8
}
9
],
10
"metadata":[
11
{
12
"view_id":"456",
13
"field_id_in_data":"a30",
14
"field_name":"Title",
15
"field_description":"",
16
"app_id":"123",
17
"id":"1",
18
"type_name":"Auto Number"
19
}
20
]
21
}
Copied!