创建表

代码示例

1https://api.hubapi.com/cms/v3/hubdb/tables

请求参数

1import fetch from "node-fetch";
2
3const endpointUrl = new URL("https://api.hubapi.com/cms/v3/hubdb/tables");
4
5const headerParameters = {
6  Authorization: "Bearer {{ACCESS_TOKEN}}",
7  "Content-Type": "application/json",
8};
9
10// 定义请求体
11const bodyParameters = JSON.stringify({
12  name: "fruits",
13  label: "Fruits",
14  useForPages: true,
15  columns: [
16    {
17      name: "id",
18      label: "ID",
19      type: "TEXT",
20    },
21    {
22      name: "name",
23      label: "Name",
24      type: "TEXT",
25    },
26    {
27      name: "color",
28      label: "Color",
29      type: "TEXT",
30    },
31    {
32      name: "flavor",
33      label: "Flavor",
34      type: "TEXT",
35    },
36  ],
37});
38
39const options = {
40  method: "POST",
41  headers: headerParameters,
42  body: bodyParameters,
43};
44
45async function createTable() {
46  try {
47    const response = await fetch(endpointUrl, options);
48    printResponse(response);
49  } catch (error) {
50    printError(error);
51  }
52}
53
54createTable();

响应字段

代码示例

1https://api.hubspot.com/cms/v3/hubdb/tables/{tableIdOrName}/rows

请求参数

1import fetch from "node-fetch";
2
3const endpointUrl = new URL("https://api.hubspot.com/cms/v3/hubdb/tables/{{TABLE_ID}}/rows");
4
5const headerParameters = {
6  Authorization: "Bearer {{ACCESS_TOKEN}}",
7  "Content-Type": "application/json",
8};
9
10// 定义请求体
11const bodyParameters = JSON.stringify({
12  values: {
13      id: "1",
14      name: "mango",
15      color: "yellow",
16      flavor: "sweet",
17  },
18});
19
20const options = {
21  method: "POST",
22  headers: headerParameters,
23  body: bodyParameters,
24};
25
26async function addRow() {
27  try {
28    const response = await fetch(endpointUrl, options);
29    printResponse(response);
30  } catch (error) {
31    printError(error);
32  }
33}
34
35addRow();

响应字段

代码示例

1https://api.hubapi.com/cms/v3/hubdb/tables/{tableIdOrName}/draft/publish

请求参数

1import fetch from "node-fetch";
2
3const endpointUrl = new URL("https://api.hubapi.com/cms/v3/hubdb/tables/{{TABLE_ID}}/draft/publish");
4
5const headerParameters = {
6  Authorization: "Bearer {{ACCESS_TOKEN}}",
7  "Content-Type": "application/json",
8};
9
10const options = {
11  method: "POST",
12  headers: headerParameters,
13};
14
15async function PublishTable() {
16  try {
17    const response = await fetch(endpointUrl, options);
18    printResponse(response);
19  } catch (error) {
20    printError(error);
21  }
22}
23
24PublishTable();

响应字段