Loading...

Get the Metadata of All Tables

Description

This API enables you to retrieve the metadata of all the tables in your project from the Data Store.

Request Details

Request URL

GET

{api-domain}/baas/v1/project/{project_id}/table

copy

api-domain
URL
The DC-specific domain to access Catalyst API

project_id
Numerical
The unique ID of the project

Request Headers

Authorization: Zoho-oauthtoken {oauth_token}

Optional Headers

CATALYST-ORG: {org_id}

Environment: Development

Scope

ZohoCatalyst.tables.READ

Response Details

The response will return the metadata of all the tables which will include the table details such as the table_id and table_name of each table, and the details of the user that last modified the tables.

Sample Request
copy

curl -X GET
https://api.catalyst.zoho.com/baas/v1/project/4000000006007/table
-H “Authorization: Zoho-oauthtoken 1000.910*************************16.2f*************************57”

Sample Response
copy
{
  "status":"success",
  "data":[
    {
      "project_id":{
        "project_name":"ShipmentTracking",
        "id":4000000006007
      },
      "table_name":"CustomerInfo",
      "modified_by":{
        "zuid":1019540152,
        "is_confirmed":true,
        "email_id":"emma@zylker.com",
        "first_name":"Amelia",
        "last_name":"Burrows",
        "user_id":671930111
      },
      "modified_time":"Apr 11, 2020 10:33 PM",
      "table_id":3376000000081234
    },
    {
      "project_id":{
        "project_name":"ShipmentTracking",
        "id":3376000000061190
      },
      "table_name":"EmpInfo",
      "modified_by":{
        "zuid":1019540232,
        "is_confirmed":true,
        "email_id":"p.boyle@zylker.com",
        "first_name":"Patricia",
        "last_name":"Boyle",
        "user_id":671930455
      },
      "modified_time":"Mar 09, 2020 03:16 AM",
      "table_id":3376000000017896
    }
  ]
}
View more