## Overview You can export a specific table using the API. ## Preparation Please [Create an API Key](/manual/api-key) before performing API operations. ## Request Send json data in the following request format: |Setting item|Value| |:--|:--| |HTTP Method|POST| |Content-Type |application/json| |Character Code|UTF-8| |URL|http://{server name}/api/items/{site ID}/export (*1)| |Body|Please refer to the json data below| (*1) Please edit the {server name} and {site ID} parts suit your environment as appropriate. For pleasanter.net, the format is as follows: https\://pleasanter.net/fs/api/items/{site ID}/export ### (a) Export tables with standard export settings ##### JSON ``` { "ApiVersion": 1.1, "ApiKey": "3da0fa3a7R61faf821..." } ``` ### (b) Export tables using export settings already created in Pleasanter You can export using the export settings you created on the "[Export](/en/manual/table-record-export)" tab of "[Table Management](/en/manual/table-management)". In the JSON of the settings file, specify the API key and the ID of the export setting you created. ##### JSON ``` { "ApiVersion": 1.1, "ApiKey": "6a7D132dgssDsg04GDS73...", "ExportId": 1 } ``` ### (c) Export tables with export settings directly in the configuration file ##### JSON ``` { "ApiVersion": 1.1, "ApiKey": "60gds37dF4fds2D...", "Export": { "Name": "Test A-1", "Columns": [ { "ColumnName": "Title" }, { "ColumnName": "Body" } ], "Header": false, "Type": "csv" } } ``` - Name: Name of export setting - Columns: Name of items to be output - Header: Setting for whether to add a header row to the output CSV - Type: Specify the type of file to be output. Two types can be specified: "csv" and "json". ### (d) Export tables by specifying the filtering and sorting order of the retrieved records ##### JSON ``` { "ApiVersion": 1.1, "ApiKey": "61dsf0D8D4g2DE4df23...", "ExportId": 1, "View": { "ColumnSorterHash": { "Title": "desc" }, "ColumnFilterHash": { "Owner": "[1]" } } } ``` ## Response The json data in the following format will be returned. ##### JSON ``` { "StatusCode": 200, "LimitPerDate": 10000, "LimitRemaining": 9990, "Response": { "Name": "Time-limited table_20xx_xx_xx xx_xx_xx.Csv", "Content": "\"ID\",\"Title\",\"Content\",\"Title/Content\",\"Comment\".........." } } ``` ## Confirmation Items in Case of Error [・Precautions when using the API and things to check if an error occurs](/manual/faq-api) [・FAQ: What to check if modified configuration files or API requests (JSON format) are not recognized correctly](/manual/faq-json-format) ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-record-export">Table Function: Export Records</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management">Manage Table</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-export">Manage Table: Export</a><span>10.03.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/dept-import">Department Management Function: Import/Export</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/group-import">Group Management Function: Import/export</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />