创建数据 - 伙伴云OpenAPI

在指定表格中创建新数据。

请求参数

Header 参数

Open-Authorization

string

必需

授权的 API Key

默认值:

Bearer {{API_KEY}}

Body 参数application/json

table_id

string

表格ID

必需

fields

object (字段提交)

字段值

必需

{field_id}

必需

只枚举出需要提交的字段，Key为字段ID，并根据字段的数据类型（data_type）提交对应类型的字段值

watermark

object (位置)

水印位置信息

可选

图片字段需要添加水印时，需要提供位置信息来生成水印

poi

string

兴趣点名称

必需

address

string

地址

必需

name

string

全地址

必需

兴趣点名+地址

pcode

string

省编码

必需

来自高德地图

pname

string

省名称

必需

citycode

string

城市编码

必需

来自高德地图

cityname

string

城市名称

必需

adcode

string

区编码

必需

来自高德地图

adname

string

区名称

必需

coordinate

object

经纬度

必需

来自高德地图

示例

{
  "table_id": "{{TABLE_ID}}",
  "fields": {
    "2200000137788628": "单行文本",
    "2200000137788629": "多行文本1\n多行文本2\n多行文本3",
    "2200000137788630": "<p><b>富文本1</b></p><p><font color=\"#dc0000\">富文本2</font></p><ol><li>富文本3</li><li>富文本4</li></ol>",
    "2200000137788631": "18612345678",
    "2200000137788632": "6954432710706",
    "2200000137788634": 23456,
    "2200000137788635": 0.85,
    "2200000137788642": 234.56,
    "2200000137788643": "2022-03-03",
    "2200000137788644": "2022-03-03 00:00:00",
    "2200000137788645": 23456,
    "2200000137788646": 0.85,
    "2200000137788647": "2022-03-03",
    "2200000137788648": "2022-03-03 00:00:00",
    "2200000137788650": [
      "1"
    ],
    "2200000137788651": [
      "1",
      "2"
    ],
    "2200000137788652": [
      "1"
    ],
    "2200000137788653": [
      "1",
      "2"
    ],
    "2200000137788654": [
      "1000001"
    ],
    "2200000137788655": [
      "1000001",
      "1000002"
    ],
    "2200000137788659": [
      "2300000000000011"
    ],
    "2200000137788660": [
      "2300000000000011",
      "2300000000000012"
    ],
    "2200000137788661": {
      "poi": "青岛大学(浮山校区)",
      "address": "山东省青岛市崂山区宁夏路308号",
      "name": "青岛大学(浮山校区)，山东省青岛市崂山区宁夏路308号",
      "pcode": "370000",
      "pname": "山东省",
      "citycode": "0532",
      "cityname": "青岛市",
      "adcode": "370212",
      "adname": "崂山区",
      "coordinate": {
        "lat": 36.071915,
        "lon": 120.422859
      }
    },
    "2200000137788663": [
      {
        "file_id": "188000001",
        "name": "image.png"
      }
    ],
    "2200000137788666": [
      {
        "file_id": "188000002",
        "name": "file.zip"
      }
    ],
    "2200000137788667": [
      188597774,
      188597775
    ]
  },
  "watermark": {
    "poi": "青岛大学(浮山校区)",
    "address": "山东省青岛市崂山区宁夏路308号",
    "name": "青岛大学(浮山校区)，山东省青岛市崂山区宁夏路308号",
    "pcode": "370000",
    "pname": "山东省",
    "citycode": "0532",
    "cityname": "青岛市",
    "adcode": "370212",
    "adname": "崂山区",
    "coordinate": {
      "lat": 36.071915,
      "lon": 120.422859
    }
  }
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://api.huoban.com/openapi/v1/item' \
--header 'Open-Authorization;' \
--header 'Content-Type: application/json' \
--data-raw '{
    "table_id": "",
    "fields": {
        "2200000137788628": "单行文本",
        "2200000137788629": "多行文本1\n多行文本2\n多行文本3",
        "2200000137788630": "<p><b>富文本1</b></p><p><font color=\"#dc0000\">富文本2</font></p><ol><li>富文本3</li><li>富文本4</li></ol>",
        "2200000137788631": "18612345678",
        "2200000137788632": "6954432710706",
        "2200000137788634": 23456,
        "2200000137788635": 0.85,
        "2200000137788642": 234.56,
        "2200000137788643": "2022-03-03",
        "2200000137788644": "2022-03-03 00:00:00",
        "2200000137788645": 23456,
        "2200000137788646": 0.85,
        "2200000137788647": "2022-03-03",
        "2200000137788648": "2022-03-03 00:00:00",
        "2200000137788650": [
            "1"
        ],
        "2200000137788651": [
            "1",
            "2"
        ],
        "2200000137788652": [
            "1"
        ],
        "2200000137788653": [
            "1",
            "2"
        ],
        "2200000137788654": [
            "1000001"
        ],
        "2200000137788655": [
            "1000001",
            "1000002"
        ],
        "2200000137788659": [
            "2300000000000011"
        ],
        "2200000137788660": [
            "2300000000000011",
            "2300000000000012"
        ],
        "2200000137788661": {
            "poi": "青岛大学(浮山校区)",
            "address": "山东省青岛市崂山区宁夏路308号",
            "name": "青岛大学(浮山校区)，山东省青岛市崂山区宁夏路308号",
            "pcode": "370000",
            "pname": "山东省",
            "citycode": "0532",
            "cityname": "青岛市",
            "adcode": "370212",
            "adname": "崂山区",
            "coordinate": {
                "lat": 36.071915,
                "lon": 120.422859
            }
        },
        "2200000137788663": [
            {
                "file_id": "188000001",
                "name": "image.png"
            }
        ],
        "2200000137788666": [
            {
                "file_id": "188000002",
                "name": "file.zip"
            }
        ],
        "2200000137788667": [188597774,188597775]

    },
    "watermark": {
        "poi": "青岛大学(浮山校区)",
        "address": "山东省青岛市崂山区宁夏路308号",
        "name": "青岛大学(浮山校区)，山东省青岛市崂山区宁夏路308号",
        "pcode": "370000",
        "pname": "山东省",
        "citycode": "0532",
        "cityname": "青岛市",
        "adcode": "370212",
        "adname": "崂山区",
        "coordinate": {
            "lat": 36.071915,
            "lon": 120.422859
        }
    }
}'

返回响应

🟢200成功

application/json

Body

code

integer

错误码

必需

0 为成功，小于 10000 为系统异常，其他为业务异常

message

string

错误信息

必需

具体的错误原因，code 为 0 时返回“success”

data

object

返回数据

必需

返回具体数据的结构

item

object (数据)

必需

meta

object

元数据

必需

用来描述返回数据原始信息

trace_id

string

请求ID

必需

每次请求接口会返回唯一的ID

示例

{
  "code": 0,
  "message": "success",
  "data": {
    "item": {
      "item_id": "2300000000000001",
      "title": "数据标题",
      "created_by": {
        "user_id": "1024",
        "name": "接口",
        "avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/317474452/0?imageMogr2/thumbnail/128x128>"
      },
      "created_on": "2021-12-15 20:45:25",
      "updated_by": {
        "user_id": "1024",
        "name": "接口",
        "avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/317474452/0?imageMogr2/thumbnail/128x128>"
      },
      "updated_on": "2022-03-31 18:33:15",
      "fields": {
        "2200000137788628": "单行文本",
        "2200000137788629": "多行文本1<br>多行文本2<br>多行文本3",
        "2200000137788630": "<p><b>富文本1</b></p><p><font color=\"#dc0000\">富文本2</font></p><ol><li>富文本3</li><li>富文本4</li></ol>",
        "2200000137788631": "18612345678",
        "2200000137788632": "6954432710706",
        "2200000137788634": 23456,
        "2200000137788635": 0.85,
        "2200000137788642": 234.56,
        "2200000137788643": "2022-03-03",
        "2200000137788644": "2022-03-03 00:00:00",
        "2200000137788645": 23456,
        "2200000137788646": 0.85,
        "2200000137788647": "2022-03-03",
        "2200000137788648": "2022-03-03 00:00:00",
        "2200000137788650": [
          {
            "id": 1,
            "name": "选项1"
          }
        ],
        "2200000137788651": [
          {
            "id": 1,
            "name": "选项1"
          },
          {
            "id": 2,
            "name": "选项2"
          }
        ],
        "2200000137788652": [
          {
            "id": 1,
            "name": "选项1"
          }
        ],
        "2200000137788653": [
          {
            "id": 1,
            "name": "选项1"
          },
          {
            "id": 2,
            "name": "选项2"
          }
        ],
        "2200000137788654": [
          {
            "user_id": "1000001",
            "name": "张三",
            "avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000001/0?imageMogr2/thumbnail/128x128>"
          }
        ],
        "2200000137788655": [
          {
            "user_id": "1000001",
            "name": "张三",
            "avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000001/0?imageMogr2/thumbnail/128x128>"
          },
          {
            "user_id": "1000002",
            "name": "李四",
            "avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000002/0?imageMogr2/thumbnail/128x128>"
          }
        ],
        "2200000137788659": [
          {
            "item_id": "2300000000000011",
            "title": "数据标题1"
          }
        ],
        "2200000137788660": [
          {
            "item_id": "2300000000000011",
            "title": "数据标题1"
          },
          {
            "item_id": "2300000000000012",
            "title": "数据标题2"
          }
        ],
        "2200000137788661": {
          "poi": "青岛大学(浮山校区)",
          "address": "山东省青岛市崂山区宁夏路308号",
          "name": "青岛大学(浮山校区)，山东省青岛市崂山区宁夏路308号",
          "pcode": "370000",
          "pname": "山东省",
          "citycode": "0532",
          "cityname": "青岛市",
          "adcode": "370212",
          "adname": "崂山区",
          "coordinate": {
            "lat": 36.071915,
            "lon": 120.422859
          }
        },
        "2200000137788663": [
          {
            "file_id": 188000001,
            "name": "image.png",
            "size": 300,
            "link": {
              "source": "https://hb-v4-attachment-oss.huoban.com/attachment/188000001/0",
              "square": "https://hb-v4-attachment-oss.huoban.com/attachment/188000001/0?imageMogr2/thumbnail/!320x320r|imageMogr2/crop/320x320/gravity/center"
            }
          }
        ],
        "2200000137788666": [
          {
            "file_id": 188000002,
            "name": "file.zip",
            "size": 500,
            "link": {
              "source": "https://hb-v4-attachment-oss.huoban.com/attachment/188000002/0"
            }
          }
        ],
        "2200000137788667": {
          "user": {
            "user_id": "1000001",
            "name": "张三",
            "avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000001/0?imageMogr2/thumbnail/128x128>"
          },
          "signature": {
            "time": "2022-03-31 17:06:05",
            "file": {
              "file_id": 188000003,
              "name": "signature.png",
              "size": 9450,
              "link": {
                "source": "https://hb-v4-attachment-oss.huoban.com/attachment/188000003/0",
                "square": "https://hb-v4-attachment-oss.huoban.com/attachment/188000003/0?imageMogr2/thumbnail/!320x320r|imageMogr2/crop/320x320/gravity/center"
              }
            }
          }
        }
      }
    }
  },
  "meta": {
    "trace_id": "1650349377817634"
  }
}