5.1 List of tables

GET /shops/<SHOP_ID>/crm/tables?api_key=<api_key> HTTP/1.1

Response

{
  "success": true,
  "tables": [
    {
      "can_remove": false,
      "creator_id": null,
      "filters": [],
      "icon": null,
      "inserted_at": "2021-04-08T08:29:43",
      "is_removed": false,
      "label": "Contact",
      "modified_id": null,
      "name": "Contact",
      "permission_type": 1,
      "sections": [
        {
          "can_remove": false,
          "creator_id": null,
          "fields": [
            {
              "name": "Name",
              "label": "Name",
              "agg_field_id": null,
              "association_multi": true,
              "association_table": null,
              "association_type": null,
              "can_remove": false,
              "creator_id": null,
              "select_options": [],
              "summary_display_field_id": null,
              "summary_field_id": null,
              "summary_type": null,
              "type": 5,
              "order": 1,
              "quick_update": false,
              "is_require": true,
              "is_unique": false,
              "formulas": null
            },
            {
              "name": "Phone",
              "label": "Phone",
              "agg_field_id": null,
              "association_multi": true,
              "association_table": null,
              "association_type": null,
              "can_remove": false,
              "creator_id": null,
              "select_options": [],
              "summary_display_field_id": null,
              "summary_field_id": null,
              "summary_type": null,
              "type": 2,
              "order": 1,
              "quick_update": false,
              "is_require": true,
              "is_unique": false,
              "formulas": null
            }
          ]
        }
      ],
      "table_permissions": [
        {
          "id": "3f7ef102-7b45-4198-8783-7f7854b4a64a",
          "profile_id": "c25c1d3a-3dae-4877-af1e-5e71a41f6113",
          "role": 63,
          "table_id": "Contact"
        },
        {
          "id": "ea6c1d47-c230-43b8-a11e-fb61f4b611e4",
          "profile_id": "8e4d6a59-47e8-48bf-a51d-eb873ffd7eae",
          "role": 31,
          "table_id": "Contact"
        },
        {
          "id": "6963295c-fd7c-49c8-ab67-86641a800653",
          "profile_id": "58c99b60-2d8a-4edb-b7a2-a907bc874dbb",
          "role": 31,
          "table_id": "Contact"
        }
      ]
    }
 ]
}

Response Parameters

Parameter	Type	Description
label	string	Label of table
name	string	Name of table
permission_type	int	Who can see the table (1. Everyone, 2. Record owner and his manager)
sections.order	int	Order of section
sections.fields	array	Fields of section
sections.fields.order	int	Order fields in the section
sections.fields.type	int	Type of field
table_permissions	array	Permission of each group in the table