> ## Documentation Index > Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt > Use this file to discover all available pages before exploring further. # Menampilkan atau menyembunyikan baris > Panggil API ini untuk mengatur visibilitas baris tertentu di lembar kerja Spreadsheet DingTalk agar tersembunyi atau tampil — kelola tampilan data secara fleksibel. Panggil API ini untuk mengatur visibilitas baris. ## Permintaan ### Informasi dasar | Bidang | Nilai | | --------------------------- | -------------------------------------------------------------------------------------------- | | URL HTTP | `https://api.dingtalk.io/v1.0/doc/workbooks/{workbookId}/sheets/{sheetId}/setRowsVisibility` | | Metode HTTP | POST | | Tipe aplikasi yang didukung | appType-Aplikasi internal　appType-Aplikasi perusahaan pihak ketiga | | Izin yang diperlukan | permission-Document.Workbook.Write-Izin tulis DingTalk Spreadsheet | ### Header permintaan | Nama | Tipe | Wajib | Deskripsi | | --------------------------- | ------ | ----- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | x-acs-dingtalk-access-token | String | Ya | Kredensial akses untuk memanggil API ini. Peroleh dengan cara berikut: - Untuk aplikasi internal, panggil API [Memperoleh access token aplikasi internal](/id/open/development/obtain-the-access-token-of-an-internal-app#). - Untuk aplikasi perusahaan pihak ketiga, panggil API [Memperoleh access token organisasi yang memberikan otorisasi kepada aplikasi pihak ketiga](https://open.dingtalk.com/document/development/obtain-the-access-token-of-the-authorized-enterprise-1#). | ### Parameter path | Nama | Tipe | Wajib | Deskripsi | | ---------- | ------ | ----- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | workbookId | String | Ya | ID file spreadsheet. `nodeId(dentryUuid)` yang dikembalikan oleh [API Knowledge Base](/id/open/development/knowledge-base-overview#) adalah `workbookId` spreadsheet. Peroleh dengan memanggil API [Memperoleh node](https://open.dingtalk.com/document/development/get-node#) dan [Membuat dokumen Knowledge Base](/id/open/development/create-team-space-document#). | | sheetId | String | Ya | ID atau judul lembar kerja. - Untuk aplikasi internal, panggil API [Memperoleh semua lembar kerja](/id/open/development/obtain-all-worksheets#) untuk mendapatkan ID, atau berikan judul lembar kerja. - Untuk aplikasi perusahaan pihak ketiga, kami sarankan untuk memberikan judul lembar kerja. Langkah untuk melihat judul lembar kerja ditunjukkan pada gambar berikut. | ### Parameter query | Nama | Tipe | Wajib | Deskripsi | | ---------- | ------ | ----- | -------------------------------------------------------------------------------------------------------------------- | | operatorId | String | Ya | unionId operator. Panggil API [Kueri detail pengguna](/id/open/development/query-user-details#) untuk memperolehnya. | ### Isi permintaan | Nama | Tipe | Wajib | Deskripsi | | ---------- | ------ | ----- | ------------------------------------------------------------------------------ | | visibility | String | Ya | Visibilitas. - **visible**: tampil. - **hidden**: tersembunyi. | | row | Long | Ya | Cursor baris pertama yang akan ditampilkan atau disembunyikan, dimulai dari 0. | | rowCount | Long | Ya | Jumlah baris yang akan ditampilkan atau disembunyikan. | ### Contoh permintaan HTTP ```http theme={"theme":{"light":"github-light","dark":"github-dark"}} POST /v1.0/doc/workbooks/e54Lq3xxx/sheets/Sheet1/setRowsVisibility?operatorId=ppgAxxx HTTP/1.1 Host:api.dingtalk.io x-acs-dingtalk-access-token:xxxxx Content-Type:application/json { "visibility" : "hidden", "row" : 0, "rowCount" : 1 } ``` Java ```java theme={"theme":{"light":"github-light","dark":"github-dark"}} // This file is auto-generated, don't edit it. Thanks. package com.aliyun.sample; import com.aliyun.tea.*; public class Sample { /** * Initialize the account Client with a Token * @return Client * @throws Exception */ public static com.aliyun.dingtalkdoc_1_0.Client createClient() throws Exception { com.aliyun.teaopenapi.models.Config config = new com.aliyun.teaopenapi.models.Config(); config.protocol = "https"; config.regionId = "central"; return new com.aliyun.dingtalkdoc_1_0.Client(config); } public static void main(String[] args_) throws Exception { java.util.List args = java.util.Arrays.asList(args_); com.aliyun.dingtalkdoc_1_0.Client client = Sample.createClient(); com.aliyun.dingtalkdoc_1_0.models.SetRowsVisibilityHeaders setRowsVisibilityHeaders = new com.aliyun.dingtalkdoc_1_0.models.SetRowsVisibilityHeaders(); setRowsVisibilityHeaders.xAcsDingtalkAccessToken = ""; com.aliyun.dingtalkdoc_1_0.models.SetRowsVisibilityRequest setRowsVisibilityRequest = new com.aliyun.dingtalkdoc_1_0.models.SetRowsVisibilityRequest() .setOperatorId("ppgAxxx") .setVisibility("hidden") .setRow(0L) .setRowCount(1L); try { client.setRowsVisibilityWithOptions("e54Lq3xxx", "Sheet1", setRowsVisibilityRequest, setRowsVisibilityHeaders, new com.aliyun.teautil.models.RuntimeOptions()); } catch (TeaException err) { if (!com.aliyun.teautil.Common.empty(err.code) && !com.aliyun.teautil.Common.empty(err.message)) { // The err contains the code and message attributes, which help you locate the issue } } catch (Exception _err) { TeaException err = new TeaException(_err.getMessage(), _err); if (!com.aliyun.teautil.Common.empty(err.code) && !com.aliyun.teautil.Common.empty(err.message)) { // The err contains the code and message attributes, which help you locate the issue } } } } ``` Python ```python theme={"theme":{"light":"github-light","dark":"github-dark"}} # -*- coding: utf-8 -*- # This file is auto-generated, don't edit it. Thanks. import sys from typing import List from alibabacloud_dingtalk.doc_1_0.client import Client as dingtalkdoc_1_0Client from alibabacloud_tea_openapi import models as open_api_models from alibabacloud_dingtalk.doc_1_0 import models as dingtalkdoc__1__0_models from alibabacloud_tea_util import models as util_models from alibabacloud_tea_util.client import Client as UtilClient class Sample: def __init__(self): pass @staticmethod def create_client() -> dingtalkdoc_1_0Client: """ Initialize the account Client with a Token @return: Client @throws Exception """ config = open_api_models.Config() config.protocol = 'https' config.region_id = 'central' return dingtalkdoc_1_0Client(config) @staticmethod def main( args: List[str], ) -> None: client = Sample.create_client() set_rows_visibility_headers = dingtalkdoc__1__0_models.SetRowsVisibilityHeaders() set_rows_visibility_headers.x_acs_dingtalk_access_token = '' set_rows_visibility_request = dingtalkdoc__1__0_models.SetRowsVisibilityRequest( operator_id='ppgAxxx', visibility='hidden', row=0, row_count=1 ) try: client.set_rows_visibility_with_options('e54Lq3xxx', 'Sheet1', set_rows_visibility_request, set_rows_visibility_headers, util_models.RuntimeOptions()) except Exception as err: if not UtilClient.empty(err.code) and not UtilClient.empty(err.message): # The err contains the code and message attributes, which help you locate the issue pass @staticmethod async def main_async( args: List[str], ) -> None: client = Sample.create_client() set_rows_visibility_headers = dingtalkdoc__1__0_models.SetRowsVisibilityHeaders() set_rows_visibility_headers.x_acs_dingtalk_access_token = '' set_rows_visibility_request = dingtalkdoc__1__0_models.SetRowsVisibilityRequest( operator_id='ppgAxxx', visibility='hidden', row=0, row_count=1 ) try: await client.set_rows_visibility_with_options_async('e54Lq3xxx', 'Sheet1', set_rows_visibility_request, set_rows_visibility_headers, util_models.RuntimeOptions()) except Exception as err: if not UtilClient.empty(err.code) and not UtilClient.empty(err.message): # The err contains the code and message attributes, which help you locate the issue pass if __name__ == '__main__': Sample.main(sys.argv[1:]) ``` PHP ```java theme={"theme":{"light":"github-light","dark":"github-dark"}} protocol = "https"; $config->regionId = "central"; return new Dingtalk($config); } /** * @param string[] $args * @return void */ public static function main($args){ $client = self::createClient(); $setRowsVisibilityHeaders = new SetRowsVisibilityHeaders([]); $setRowsVisibilityHeaders->xAcsDingtalkAccessToken = ""; $setRowsVisibilityRequest = new SetRowsVisibilityRequest([ "operatorId" => "ppgAxxx", "visibility" => "hidden", "row" => 0, "rowCount" => 1 ]); try { $client->setRowsVisibilityWithOptions("e54Lq3xxx", "Sheet1", $setRowsVisibilityRequest, $setRowsVisibilityHeaders, new RuntimeOptions([])); } catch (Exception $err) { if (!($err instanceof TeaError)) { $err = new TeaError([], $err->getMessage(), $err->getCode(), $err); } if (!Utils::empty_($err->code) && !Utils::empty_($err->message)) { // The err contains the code and message attributes, which help you locate the issue } } } } $path = __DIR__ . \DIRECTORY_SEPARATOR . '..' . \DIRECTORY_SEPARATOR . 'vendor' . \DIRECTORY_SEPARATOR . 'autoload.php'; if (file_exists($path)) { require_once $path; } Sample::main(array_slice($argv, 1)); ``` Go ```go theme={"theme":{"light":"github-light","dark":"github-dark"}} // This file is auto-generated, don't edit it. Thanks. package main import ( "os" util "github.com/alibabacloud-go/tea-utils/v2/service" dingtalkdoc_1_0 "github.com/alibabacloud-go/dingtalk/doc_1_0" openapi "github.com/alibabacloud-go/darabonba-openapi/v2/client" "github.com/alibabacloud-go/tea/tea" ) /** * Initialize the account Client with a Token * @return Client * @throws Exception */ func CreateClient () (_result *dingtalkdoc_1_0.Client, _err error) { config := &openapi.Config{} config.Protocol = tea.String("https") config.RegionId = tea.String("central") _result = &dingtalkdoc_1_0.Client{} _result, _err = dingtalkdoc_1_0.NewClient(config) return _result, _err } func _main (args []*string) (_err error) { client, _err := CreateClient() if _err != nil { return _err } setRowsVisibilityHeaders := &dingtalkdoc_1_0.SetRowsVisibilityHeaders{} setRowsVisibilityHeaders.XAcsDingtalkAccessToken = tea.String("") setRowsVisibilityRequest := &dingtalkdoc_1_0.SetRowsVisibilityRequest{ OperatorId: tea.String("ppgAxxx"), Visibility: tea.String("hidden"), Row: tea.Int64(0), RowCount: tea.Int64(1), } tryErr := func()(_e error) { defer func() { if r := tea.Recover(recover()); r != nil { _e = r } }() _, _err = client.SetRowsVisibilityWithOptions(tea.String("e54Lq3xxx"), tea.String("Sheet1"), setRowsVisibilityRequest, setRowsVisibilityHeaders, &util.RuntimeOptions{}) if _err != nil { return _err } return nil }() if tryErr != nil { var err = &tea.SDKError{} if _t, ok := tryErr.(*tea.SDKError); ok { err = _t } else { err.Message = tea.String(tryErr.Error()) } if !tea.BoolValue(util.Empty(err.Code)) && !tea.BoolValue(util.Empty(err.Message)) { // The err contains the code and message attributes, which help you locate the issue } } return _err } func main() { err := _main(tea.StringSlice(os.Args[1:])) if err != nil { panic(err) } } ``` Node.js ```python theme={"theme":{"light":"github-light","dark":"github-dark"}} // This file is auto-generated, don't edit it import Util, * as $Util from '@alicloud/tea-util'; import dingtalkdoc_1_0, * as $dingtalkdoc_1_0 from '@alicloud/dingtalk/doc_1_0'; import OpenApi, * as $OpenApi from '@alicloud/openapi-client'; import * as $tea from '@alicloud/tea-typescript'; export default class Client { /** * Initialize the account Client with a Token * @return Client * @throws Exception */ static createClient(): dingtalkdoc_1_0 { let config = new $OpenApi.Config({ }); config.protocol = "https"; config.regionId = "central"; return new dingtalkdoc_1_0(config); } static async main(args: string[]): Promise { let client = Client.createClient(); let setRowsVisibilityHeaders = new $dingtalkdoc_1_0.SetRowsVisibilityHeaders({ }); setRowsVisibilityHeaders.xAcsDingtalkAccessToken = ""; let setRowsVisibilityRequest = new $dingtalkdoc_1_0.SetRowsVisibilityRequest({ operatorId: "ppgAxxx", visibility: "hidden", row: 0, rowCount: 1, }); try { await client.setRowsVisibilityWithOptions("e54Lq3xxx", "Sheet1", setRowsVisibilityRequest, setRowsVisibilityHeaders, new $Util.RuntimeOptions({ })); } catch (err) { if (!Util.empty(err.code) && !Util.empty(err.message)) { // The err contains the code and message attributes, which help you locate the issue } } } } Client.main(process.argv.slice(2)); ``` C# ```java theme={"theme":{"light":"github-light","dark":"github-dark"}} // This file is auto-generated, don't edit it. Thanks. using System; using System.Collections; using System.Collections.Generic; using System.IO; using System.Threading.Tasks; using Tea; using Tea.Utils; namespace AlibabaCloud.SDK.Sample { public class Sample { /** * Initialize the account Client with a Token * @return Client * @throws Exception */ public static AlibabaCloud.SDK.Dingtalkdoc_1_0.Client CreateClient() { AlibabaCloud.OpenApiClient.Models.Config config = new AlibabaCloud.OpenApiClient.Models.Config(); config.Protocol = "https"; config.RegionId = "central"; return new AlibabaCloud.SDK.Dingtalkdoc_1_0.Client(config); } public static void Main(string[] args) { AlibabaCloud.SDK.Dingtalkdoc_1_0.Client client = CreateClient(); AlibabaCloud.SDK.Dingtalkdoc_1_0.Models.SetRowsVisibilityHeaders setRowsVisibilityHeaders = new AlibabaCloud.SDK.Dingtalkdoc_1_0.Models.SetRowsVisibilityHeaders(); setRowsVisibilityHeaders.XAcsDingtalkAccessToken = ""; AlibabaCloud.SDK.Dingtalkdoc_1_0.Models.SetRowsVisibilityRequest setRowsVisibilityRequest = new AlibabaCloud.SDK.Dingtalkdoc_1_0.Models.SetRowsVisibilityRequest { OperatorId = "ppgAxxx", Visibility = "hidden", Row = 0, RowCount = 1, }; try { client.SetRowsVisibilityWithOptions("e54Lq3xxx", "Sheet1", setRowsVisibilityRequest, setRowsVisibilityHeaders, new AlibabaCloud.TeaUtil.Models.RuntimeOptions()); } catch (TeaException err) { if (!AlibabaCloud.TeaUtil.Common.Empty(err.Code) && !AlibabaCloud.TeaUtil.Common.Empty(err.Message)) { // The err contains the code and message attributes, which help you locate the issue } } catch (Exception _err) { TeaException err = new TeaException(new Dictionary { { "message", _err.Message } }); if (!AlibabaCloud.TeaUtil.Common.Empty(err.Code) && !AlibabaCloud.TeaUtil.Common.Empty(err.Message)) { // The err contains the code and message attributes, which help you locate the issue } } } } } ``` ## Respons ### Isi respons | Nama | Tipe | Deskripsi | | ---- | ------ | ---------------- | | id | String | ID lembar kerja. | ### Contoh isi respons ```text theme={"theme":{"light":"github-light","dark":"github-dark"}} HTTP/1.1 200 OK Content-Type:application/json { "id" : "stxxxx" } ``` ### Kode error Jika terjadi error saat memanggil API ini, cari solusinya dalam dokumen [Kode error global](/id/open/development/server-api-error-codes-1) berdasarkan pesan error. | HttpCode | Kode error | Pesan error | Deskripsi | | -------- | ------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------- | | 400 | invalidRequest.inputArgs.invalid | %s | Parameter permintaan tidak valid. Periksa pesan error. | | 400 | invalidRequest.inputArgs.workbookIdIllegal | The workbookId is illegal. | workbookId tidak valid. | | 400 | invalidRequest.resource.notWorkbook | %s | Tipe dokumen tidak didukung. Periksa workbookId. | | 403 | forbidden.accessDenied | The operator has no permission. | Pengguna saat ini tidak memiliki izin untuk tindakan ini. | | 403 | forbidden.acrossOrg | %s | Permintaan tidak valid. Periksa apakah dokumen yang akan diakses termasuk dalam organisasi yang ditentukan oleh access token. | | 403 | forbidden.operationIllegal | %s | Tindakan yang diminta tidak valid. Periksa pesan error. | | 403 | forbidden.document.sizeOverLimit | The document size is over limit and the server is unable to complete your request. Retry is unlikely to work unless the document size is decreased. | Konten spreadsheet terlalu besar. Coba kurangi konten spreadsheet. | | 404 | invalidRequest.resource.notFound | %s | Permintaan gagal karena sumber daya yang akan diakses tidak dapat ditemukan. | | 500 | serviceBusy | The server is busy and unable to complete your request. Please try again later. | Layanan sedang sibuk. Coba lagi nanti. | | 500 | internalError | The server encountered an internal error and was unable to complete your request. Please try again later. | Terjadi error internal server. Coba lagi nanti. |