查询子表权限
... 2026-2-4 大约 1 分钟
# 查询子表权限
# 接口说明
本接口用于查询智能表格子表内容权限
# 请求格式
| 描述 | 定义 |
|---|---|
| Path | /openapi/smartsheet/v2/files/{fileID}/getSheetContentPermission |
| Method | POST |
| Content-Type | application/json |
# 请求头部
详见Headers。
# 请求参数
# 路径参数
| 参数名 | 类型 | 必选 | 描述 |
|---|---|---|---|
| fileID | string | 是 | 文档唯一标识，详见fileID |
# 查询参数
# 请求体
| 参数名 | 类型 | 必选 | 描述 |
|---|---|---|---|
| type | enum RuleMemberType | 是 | 权限规则类型 |
| ruleIdList | array uint64 | 否 | 需要查询的规则id列表，查询额外权限时填写 |
# 响应参数
# 响应体
| 参数名 | 类型 | 描述 |
|---|---|---|
| ruleList | array object Rule | 权限列表 |
# 示例
curl --location --request POST 'https://{{domain}}/openapi/smartsheet/v2/files/DZVNFcEZBem1UcHhWQVNFZkdY/getSheetContentPermission' \
--header 'Access-Token: Access-Token' \
--header 'Client-Id: Client-Id' \
--header 'Content-Type: application/json' \
--data '{
"type": "RuleMemberSpec",
"ruleIdList": [
1749805489135
]
}'
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
# 响应示例
{
"ruleList": [
{
"type": "RuleMemberSpec",
"ruleId": "1749805489135",
"name": "负责人",
"privilegeList": [
{
"sheetId": "ss_8einmn",
"privilegeType": "SheetPrivEdit",
"canInsertRecord": true,
"canDeleteRecord": true,
"canCreateModifyDeleteView": true,
"fieldPrivilege": {
"fieldRangeType": "FieldRangeSpec",
"fieldRuleList": [
{
"fieldId": "f8fFi6",
"fieldType": "FIELD_TYPE_TEXT",
"canEdit": true,
"canInsert": true,
"canView": true
},
{
"fieldId": "frrJnq",
"fieldType": "FIELD_TYPE_SINGLE_SELECT",
"canInsert": true,
"canView": true
},
{
"fieldId": "f9QDqq",
"fieldType": "FIELD_TYPE_SINGLE_SELECT",
"canEdit": true,
"canInsert": true,
"canView": true
},
{
"fieldId": "f77jBW",
"fieldType": "FIELD_TYPE_IMAGE",
"canEdit": true,
"canInsert": true,
"canView": true
},
{
"fieldId": "fwjOxM",
"fieldType": "FIELD_TYPE_TEXT",
"canEdit": true,
"canInsert": true,
"canView": true
},
{
"fieldId": "feZdAa",
"fieldType": "FIELD_TYPE_TEXT",
"canEdit": true,
"canInsert": true,
"canView": true
},
{
"fieldId": "fk1Xtt",
"fieldType": "FIELD_TYPE_SINGLE_SELECT",
"canInsert": true,
"canView": true
},
{
"fieldId": "fx5KTe",
"fieldType": "FIELD_TYPE_TEXT",
"canEdit": true,
"canInsert": true,
"canView": true
}
],
"fieldDefaultRule": {}
},
"recordPrivilege": {
"recordRangeType": "RecordRangeCondOr",
"recordRuleList": [
{
"fieldId": "frrJnq",
"fieldType": "FIELD_TYPE_SINGLE_SELECT",
"logicType": "RecordOperContain",
"value": [
"olIqIf",
"ohsVTK"
]
}
],
"otherPrivilege": "RecordOtherNoView"
}
}
],
"defaultPrivilege": {
"privilegeType": "SheetPrivNo"
},
"members": [
{
"memType": "MemUid",
"id": "1323556151475830788"
},
{
"memType": "MemUid",
"id": "1323556151475830814"
}
],
"createUid": "1323556151475830814",
"updateUid": "1323556151475830814",
"createTime": "1749805489",
"modifyTime": "1749806946"
}
]
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112