---
title: "Obtener metadatos de tabla"
url: https://docs.catalyst.zoho.com/es/sdk/nodejs/v2/cloud-scale/data-store/get-table-meta/
description: "Esta página describe el método para obtener los metadatos de una tabla individual o de múltiples tablas en tu aplicación NodeJS con fragmentos de código de ejemplo"
last_updated: 2026-03-30T08:10:30Z
service: Cloud Scale
type: general
related_links:
  - name: "Get table meta - API"
    url: /es/api/code-reference/cloud-scale/data-store/get-table-metadata/#GetTableMetadata
  - name: "Data Store"
    url: /es/cloud-scale/help/data-store/introduction
---

# Obtener metadatos de tabla

Los metadatos de una tabla individual en [Catalyst Data
Store](https://docs.catalyst.zoho.com/es/cloud-scale/help/data-store/introduction) se pueden obtener de dos formas. La referencia `datastore` utilizada en los fragmentos de código
a continuación es la [instancia del
componente.](https://docs.catalyst.zoho.com/es/sdk/nodejs/v2/cloud-scale/data-store/get-component-instance)

### Get a Table's Metadata by Table ID

Los metadatos de una tabla se obtienen haciendo referencia al ID de la tabla, utilizando el método `getTableDetails()` como se muestra a continuación,

```javascript
//Obtener los detalles de una tabla usando el ID de tabla 
let datastore = app.datastore(); 
let tablePromise = datastore.getTableDetails(1510000000110121); 
tablePromise.then((table) => { console.log(table); 
});
```

A continuación se muestra una respuesta de ejemplo que recibirás para cada versión:

**Node JS**

```

    {
    "project_id":{
    "project_name":"AlienCity",
    "id":"2136000000007733"
    },
    "table_name":"AlienCity",
    "modified_by":{
    "zuid":"66466723",
    "is_confirmed":false,
    "email_id":"emma@zylker.com",
    "first_name":"Amelia",
    "last_name":"Burrows",
    "user_type":"Admin",
    "user_id":"2136000000006003"
    },
    "modified_time":"Aug 13, 2021 01:47 PM",
    "column_details":[
    {
    "table_id":"2136000000007781",
    "column_sequence":"1",
    "column_name":"ROWID",
    "category":1,
    "data_type":"bigint",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":false,
    "column_id":"2136000000007784"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"2",
    "column_name":"CREATORID",
    "category":1,
    "data_type":"bigint",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":"2136000000007786"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"3",
    "column_name":"CREATEDTIME",
    "category":1,
    "data_type":"datetime",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":"2136000000007788"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"4",
    "column_name":"MODIFIEDTIME",
    "category":1,
    "data_type":"datetime",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":"2136000000007790"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"5",
    "column_name":"CityName",
    "category":2,
    "data_type":"varchar",
    "max_length":"100",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":true,
    "search_index_enabled":true,
    "column_id":"2136000000008503"
    }
    ],
    "table_id":"2136000000007781"
    }

    {
    "project_id":{
    "project_name":"AlienCity",
    "id":2136000000007733
    },
    "table_name":"AlienCity",
    "modified_by":{
    "zuid":66466723,
    "is_confirmed":false,
    "email_id":"emma@zylker.com",
    "first_name":"Amelia",
    "last_name":"Burrows",
    "user_type":"Admin",
    "user_id":2136000000006003
    },
    "modified_time":"Aug 13, 2021 01:47 PM",
    "column_details":[
    {
    "table_id":2136000000007781,
    "column_sequence":1,
    "column_name":"ROWID",
    "category":1,
    "data_type":"bigint",
    "max_length":50,
    "is_mandatory":false,
    "decimal_digits":2,
    "is_unique":false,
    "search_index_enabled":false,
    "column_id":2136000000007784
    },
    {
    "table_id":2136000000007781,
    "column_sequence":2,
    "column_name":"CREATORID",
    "category":1,
    "data_type":"bigint",
    "max_length":50,
    "is_mandatory":false,
    "decimal_digits":2,
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":2136000000007786
    },
    {
    "table_id":2136000000007781,
    "column_sequence":3,
    "column_name":"CREATEDTIME",
    "category":1,
    "data_type":"datetime",
    "max_length":50,
    "is_mandatory":false,
    "decimal_digits":2,
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":2136000000007788
    },
    {
    "table_id":2136000000007781,
    "column_sequence":4,
    "column_name":"MODIFIEDTIME",
    "category":1,
    "data_type":"datetime",
    "max_length":50,
    "is_mandatory":false,
    "decimal_digits":2,
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":2136000000007790
    },
    {
    "table_id":2136000000007781,
    "column_sequence":5,
    "column_name":"CityName",
    "category":2,
    "data_type":"varchar",
    "max_length":100,
    "is_mandatory":false,
    "decimal_digits":2,
    "is_unique":true,
    "search_index_enabled":true,
    "column_id":2136000000008503
    }
    ],
    "table_id":2136000000007781
    }

```

### Get a Table's Metadata by Table Name

Cuando se necesita obtener los metadatos de la tabla haciendo referencia al nombre de la tabla, se puede utilizar el siguiente fragmento de código. Sin embargo,
ten en cuenta que cuando el nombre de la tabla se cambie en el futuro, debe reflejarse en todos los lugares donde se utilice en
el código.

En ambos casos, se devuelve una promesa, que a su vez se resuelve con los detalles de los metadatos de la tabla. Los metadatos resultantes se pueden
convertir a una salida de cadena o JSON accediendo a los métodos **.toString()** o **.toJSON()**.

```javascript
//Obtener los detalles de una tabla usando el nombre de la tabla 
let datastore = app.datastore(); 
let tablePromise =
datastore.getTableDetails('SampleTable'); 
tablePromise.then((table) => { console.log(table); 
});
```

A continuación se muestra una respuesta de ejemplo que recibirás para cada versión:

**Node JS**

```

    {
    "project_id":{
    "project_name":"AlienCity",
    "id":"2136000000007733"
    },
    "table_name":"AlienCity",
    "modified_by":{
    "zuid":"66466723",
    "is_confirmed":false,
    "email_id":"emma@zylker.com",
    "first_name":"Amelia",
    "last_name":"Burrows",
    "user_type":"Admin",
    "user_id":"2136000000006003"
    },
    "modified_time":"Aug 13, 2021 01:47 PM",
    "column_details":[
    {
    "table_id":"2136000000007781",
    "column_sequence":"1",
    "column_name":"ROWID",
    "category":1,
    "data_type":"bigint",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":false,
    "column_id":"2136000000007784"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"2",
    "column_name":"CREATORID",
    "category":1,
    "data_type":"bigint",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":"2136000000007786"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"3",
    "column_name":"CREATEDTIME",
    "category":1,
    "data_type":"datetime",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":"2136000000007788"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"4",
    "column_name":"MODIFIEDTIME",
    "category":1,
    "data_type":"datetime",
    "max_length":"50",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":false,
    "search_index_enabled":true,
    "column_id":"2136000000007790"
    },
    {
    "table_id":"2136000000007781",
    "column_sequence":"5",
    "column_name":"CityName",
    "category":2,
    "data_type":"varchar",
    "max_length":"100",
    "is_mandatory":false,
    "decimal_digits":"2",
    "is_unique":true,
    "search_index_enabled":true,
    "column_id":"2136000000008503"
    }
    ],
    "table_id":"2136000000007781"
    }

{
        "project_id":{
        "project_name":"AlienCity",
        "id":2136000000007733
        },
        "table_name":"AlienCity",
        "modified_by":{
        "zuid":66466723,
        "is_confirmed":false,
        "email_id":"emma@zylker.com",
        "first_name":"Amelia",
        "last_name":"Burrows",
        "user_type":"Admin",
        "user_id":2136000000006003
        },
        "modified_time":"Aug 13, 2021 01:47 PM",
        "column_details":[
        {
        "table_id":2136000000007781,
        "column_sequence":1,
        "column_name":"ROWID",
        "category":1,
        "data_type":"bigint",
        "max_length":50,
        "is_mandatory":false,
        "decimal_digits":2,
        "is_unique":false,
        "search_index_enabled":false,
        "column_id":2136000000007784
        },
        {
        "table_id":2136000000007781,
        "column_sequence":2,
        "column_name":"CREATORID",
        "category":1,
        "data_type":"bigint",
        "max_length":50,
        "is_mandatory":false,
        "decimal_digits":2,
        "is_unique":false,
        "search_index_enabled":true,
        "column_id":2136000000007786
        },
        {
        "table_id":2136000000007781,
        "column_sequence":3,
        "column_name":"CREATEDTIME",
        "category":1,
        "data_type":"datetime",
        "max_length":50,
        "is_mandatory":false,
        "decimal_digits":2,
        "is_unique":false,
        "search_index_enabled":true,
        "column_id":2136000000007788
        },
        {
        "table_id":2136000000007781,
        "column_sequence":4,
        "column_name":"MODIFIEDTIME",
        "category":1,
        "data_type":"datetime",
        "max_length":50,
        "is_mandatory":false,
        "decimal_digits":2,
        "is_unique":false,
        "search_index_enabled":true,
        "column_id":2136000000007790
        },
        {
        "table_id":2136000000007781,
        "column_sequence":5,
        "column_name":"CityName",
        "category":2,
        "data_type":"varchar",
        "max_length":100,
        "is_mandatory":false,
        "decimal_digits":2,
        "is_unique":true,
        "search_index_enabled":true,
        "column_id":2136000000008503
        }
        ],
        "table_id":2136000000007781
        }

```

### Get Metadata of All Tables

Además de obtener los metadatos de una tabla individual, puedes obtener los detalles de todas las tablas en un proyecto de Catalyst
utilizando el método `getAllTables()`.

La promesa devuelta aquí se resolverá con un arreglo de detalles de metadatos de tablas.

```javascript
//Obtener los metadatos de todas las tablas 
let datastore = app.datastore(); 
let allTablePromise = datastore.getAllTables();
allTablePromise.then((tables) => 
{ console.log(tables); });
```

A continuación se muestra una respuesta de ejemplo que recibirás para cada versión:

**Node JS**

```

    [
    {
    "project_id":{
    "project_name":"AlienCity",
    "id":"2136000000007733"
    },
    "table_name":"AlienCity",
    "modified_by":{
    "zuid":"66466723",
    "is_confirmed":false,
    "email_id":"emma@zylker.com",
    "first_name":"Amelia",
    "last_name":"Burrows",
    "user_type":"Admin",
    "user_id":"2136000000006003"
    },
    "modified_time":"Aug 13, 2021 01:47 PM",
    "table_id":"2136000000007781"
    },
    "table_name":"CityDetails",
    "modified_by":{
    "zuid":"66466723",
    "is_confirmed":false,
    "email_id":"emma@zylker.com",
    "first_name":"Amelia",
    "last_name":"Burrows",
    "user_type":"Admin",
    "user_id":"2136000000006003"
    },
    "modified_time":"Aug 13, 2021 01:47 PM",
    "table_id":"2136000000009090"
    }
    ]

    [
    {
    "project_id":{
    "project_name":"AlienCity",
    "id":2136000000007733
    },
    "table_name":"AlienCity",
    "modified_by":{
    "zuid":66466723,
    "is_confirmed":false,
    "email_id":"emma@zylker.com",
    "first_name":"Amelia",
    "last_name":"Burrows",
    "user_type":"Admin",
    "user_id":2136000000006003
    },
    "modified_time":"Aug 13, 2021 01:47 PM",
    "table_id":2136000000007781
    },
    "table_name":"CityDetails",
    "modified_by":{
    "zuid":66466723,
    "is_confirmed":false,
    "email_id":"emma@zylker.com",
    "first_name":"Amelia",
    "last_name":"Burrows",
    "user_type":"Admin",
    "user_id":2136000000006003
    },
    "modified_time":"Aug 13, 2021 01:47 PM",
    "table_id":2136000000009090
    }
    ]

```