Download record comments in CSV format

Introduction

This article introduces how to retrieve comment information from a record and output the information as a CSV file.

The sample in this article uses the Get Comments API and downloads the comment data of a record in CSV format.
Try using any app that has the record comment feature enabled.

Finished Image

Button placement for CSV output and a list of comments to be outputted:

US_01.png

 

Example of a CSV file that has been outputted (viewed through Excel):

US_02.png

Customization

Sample Code

Sample.js

The sample JavaScript code follows these 3 steps to download comments in CSV format:

(1) Retrieve comment data
(2) Convert the data format into CSV
(3) Add a button for downloading the CSV file

(1) Retrieve Comment Data

The maximum number of comments you can obtain with the Get Comments API is 10.
Therefore, recursion is used to obtain all of the comments in the record.

 

Reference: Get all records from an app

(2) Convert the data format into CSV

Convert the comment data retrieved into CSV format.

 

(3) Add a button for downloading the CSV file

Add a button to download the CSV file.

 

Finally

As Kintone does not offer a way to download comments inside records, this customization should help you store back-up data of important information that is stored inside the comments.

Was this article helpful?
0 out of 0 found this helpful
Do you have any questions or issues related to this article?
Please share your views with us in the Community forums!