List Tables
GET
https://app.smartsuite.com/api/v1/applications/
Lists all Tables (Apps) in the Workspace.
Example Request
curl -X GET https://app.smartsuite.com/api/v1/applications/ \
-H "Authorization: Token YOUR_API_KEY" \
-H "ACCOUNT-ID: WORKSPACE_ID" \
-H "Content-Type: application/json"
Query Parameters
| Param | Type | Optional | Description |
|---|---|---|---|
| fields | string | Yes | Specifies a field slug to include in the response. This parameter can be repeated to add multiple fields. If at least one field is specified, the response will only contain fields referenced by the fields parameter. |
| solution | string | Yes | Specifies a Solution Id to limit the returned Tables by. |
Response Format
| Param | Type | Optional | Description |
|---|---|---|---|
| id | string | No | The Id of the App. |
| name | string | No | The name of the App. |
| solution | string | No | The new App's Solution Id. |
| slug | string | No | The slug value of the App (SmartSuite internal use). |
| order | number | No | Number used for ordering app in list of Tables. |
| structure | array of app objects | No | An array of app objects. |
200 Response - Example
[
{
"first_created": {
"on": "2022-12-20T17:52:22.646000Z",
"by": "63a1f65723aaf6bcb564b1f1"
},
"solution": "63a1f65523aaf6bcb564b00a",
"name": "Teams",
"slug": "teams",
"order": 100,
"show_all_reports_members": [],
"fields_metadata": {},
"permissions": {
"level": "all_members",
"members": [],
"teams": []
},
"id": "63a1f65623aaf6bcb564b00b",
"structure": [
{
"slug": "name",
"label": "Name",
"field_type": "textfield",
"params": {
"primary": true,
"restore_application_id": null,
"linked_field_slug": null,
"max_length": null,
"composite": null,
"delimiter": ", ",
"required": true,
"unique": true,
"hidden": false,
"help_text": "",
"placeholder": "Write here",
"default_value": null,
"width": 1,
"system": false,
"valid": true,
"is_migrating": false,
"system_label": "Name"
}
},
{
"slug": "color",
"label": "Color",
"field_type": "colorpickerfield",
"params": {
"required": true,
"unique": false,
"hidden": false,
"help_text": "",
"placeholder": "Select color",
"default_value": [],
"width": 1,
"system": false,
"valid": true,
"is_migrating": false,
"system_label": "Availability Status",
"display_format": "hex",
"entries_allowed": "single"
}
},
{
"slug": "type",
"label": "Type",
"field_type": "singleselectfield",
"params": {
"display_format": "importance",
"control_type": "dropdown",
"edit_values": false,
"edit_help_texts": false,
"new_choices_allowed": true,
"choices": [
{
"value": "2",
"label": "Public",
"value_help_text": null,
"value_color": "#0C41F3",
"value_order": 0
}
],
"required": true,
"unique": false,
"hidden": false,
"help_text": "",
"placeholder": "Select Value",
"default_value": "",
"width": 1,
"system": false,
"valid": true,
"is_migrating": false,
"system_label": "Type"
}
},
{
"slug": "status",
"label": "Status",
"field_type": "statusfield",
"params": {
"choices": [
{
"value": "1",
"label": "Active",
"value_help_text": null,
"value_color": "#0C41F3",
"value_order": 0,
"is_complete": false
},
{
"value": "2",
"label": "Inactive",
"value_help_text": null,
"value_color": "#00B3FA",
"value_order": 1,
"is_complete": false
}
],
"required": true,
"unique": false,
"hidden": false,
"help_text": "",
"placeholder": "",
"default_value": {
"value": "",
"updated_on": null
},
"width": 1,
"system": false,
"valid": true,
"is_migrating": false,
"system_label": "Status"
}
},
{
"slug": "owners",
"label": "Owners",
"field_type": "userfield",
"params": {
"include_filter": false,
"field_filter": {},
"display_format": "image_name",
"linked_application": "members",
"entries_allowed": "multiple",
"linked_field_slug": null,
"required": true,
"unique": false,
"hidden": false,
"help_text": "",
"placeholder": "Enter assign to",
"default_value": [],
"width": 1,
"system": false,
"valid": true,
"is_migrating": false,
"system_label": "Owners"
}
},
{
"slug": "members",
"label": "Members",
"field_type": "userfield",
"params": {
"include_filter": false,
"field_filter": {},
"display_format": "image_name",
"linked_application": "members",
"entries_allowed": "multiple",
"linked_field_slug": null,
"required": false,
"unique": false,
"hidden": false,
"help_text": "",
"placeholder": "Enter assign to",
"default_value": [],
"width": 1,
"system": false,
"valid": true,
"is_migrating": false,
"system_label": "Members"
}
},
{
"slug": "first_created",
"label": "First Created",
"field_type": "firstcreatedfield",
"params": {
"display_format": "avatar_date",
"date_format": "standard",
"include_time": false,
"required": false,
"unique": false,
"hidden": false,
"help_text": "",
"placeholder": "",
"default_value": null,
"width": null,
"system": true,
"valid": true,
"is_migrating": false
}
},
{
"slug": "last_updated",
"label": "Last Updated",
"field_type": "lastupdatedfield",
"params": {
"display_format": "avatar_date",
"date_format": "standard",
"include_time": false,
"required": false,
"unique": false,
"hidden": false,
"help_text": "",
"placeholder": "",
"default_value": null,
"width": null,
"system": true,
"valid": true,
"is_migrating": false
}
}
],
"structure_layout": {
"single_column": {
"rows": null
}
},
"primary_field": "name"
},
...
}