Table Store

Prerequisites

You must first activate the Alibaba Cloud Table Store service and create an instance and a table. For more information, see Usage overview.

The primary key of a Table Store table supports only integer, string, and binary data types. Ensure that your input data matches these data types.

Node configuration

The figure below shows the Table Store node configuration.

View Table Store instance information.

Parameters

You can use variables in parameters. IoT Studio provides the following built-in global variables:

• The payload object contains the output data from the previous node. Access a specific value using the format payload.key.

  For example, payload.productKey accesses the value from an output like {productKey: 'value'}.

• The query object contains data from the initial input node of the flow, such as parameters from an HTTP request or data from a device trigger. Access a specific value using the format query.parameterName.

  For example, query.deviceName accesses the value of the deviceName input parameter from an API request node.

• The node object contains the output data from any specific node in the flow, referenced by its ID (node.node_ID). Access a specific value using the format node.node_ID.key.

  For example, node.node_39***0.pageNum accesses the value of pageNum from the output of the node with the ID node_39***0.

The following sections provide the parameter structure and examples for each operation type.

• Insert

  {
    "tableName": "", // The name of the table
    "primaryKey": { // The primary key of the table
    },
    "columns": { // The data to insert
    }
  }

  Example: Inserts a new row with a specified primary key and values for fields a, b, c, and d.

  {
      "tableName": "base_info",
      "primaryKey": {
          "ds": "{{payload.ds}}"
      },
      "columns": {
          "a": "{{payload.a}}",
          "b": "{{payload.b}}",
          "c": "{{payload.c}}",
          "d": "{{payload.d}}"
      }
  }

• Query

  {
    "tableName": "",  // The name of the table
    "primaryKey": { // The primary key of the table
    }
    "condition": { // The query condition. Only equality checks are supported.
    },
    "columns": [] // The columns to query
  }

  Example: Queries for data that matches the specified values for fields a and b.

  {
      "tableName": "base_info",
      "primaryKey": {"ds": "{{node.node_4043aa20.ds}}"},
      "condition": {
          "a": "{{payload.a}}",
          "b": "{{payload.b}}"
      },
      "columns": ["ds", "a", "b", "c", "d"]
  }

• Delete

  {
    "tableName": "",  // The name of the table
    "primaryKey": { // The primary key, which specifies the row to delete
    }
  }

  Example: Deletes the row where the primary key ds has the value specified in {{query.ds}}.

  {
      "tableName": "base_info",
      "primaryKey": {
          "ds": "{{query.ds}}"
      }
  }

• Update

  {
    "tableName": "", // The name of the table
    "primaryKey": { // The primary key, which specifies the row to update
    },
    "columns": {  // The data to update
    }
  }

  Example: Updates the values of fields a, b, and d in the row where the primary key ds has the value specified in {{query.ds}}.

  {
      "tableName": "base_info",
      "primaryKey": {
          "ds": "{{query.ds}}"
      },
      "columns": {
          "a": "gasdlghasldfjksjh",
          "b": "gaksjdflkjhs",
          "d": "d"
      }
  }

Node output

The node outputs the Table Store operation result.