User Guides

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|4

and 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.net/api/v1/app/123/view/456


Sample Response

{
   "data":[
      {
         "a30":"DEMO00000"
      },
      {
         "a30":"DEMO00002"
      }
   ],
   "metadata":[
      {
         "view_id":"456",
         "field_id_in_data":"a30",
         "field_name":"Title",
         "field_description":"",
         "app_id":"123",
         "id":"1",
         "type_name":"Auto Number"
      }
   ]
}