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

Returns an array of Table objects. The permissions object has the shape described in the Permissions object: members and teams hold {entity, access} grant objects, and owners holds member Ids.

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"
    },
    ...
]