Developer Function: JSON Data Layout: Comment

2026-09-182026-09-18

Overview¶

This is a JSON format data layout that is specified for "comments" when performing import operations.

Restrictions¶

The "comments" should be set to a string in JSON format. If the syntax is incorrect, it will be imported into "comments" as a string.
Only available for import operations; not available for API.

Data Layout¶

Column name/type	Property name	Data type	Notes
Created Datetime	CreatedTime	Date and time string *1	If a date/time string cannot be converted to a date/time or is omitted, the import execution date/time is registered.
Creator	Creator	Numeric or String	If a string is set, the user ID associated with the corresponding user name is registered. If a numerical value for a non-existent user ID or a string for a non-existent user name, “0” will be registered. On the screen, “(Not set)” is displayed. If omitted, the user ID of the user executing import is registered.
comment	Body	String

*1 The following are the main formats that can be set for date/time strings. In addition to the formats listed below, date/time strings that can be converted to date/time can also be set.

Date format	Setting example
yyyy-MM-dd	2025-07-01
yyyy/MM/dd	2025/07/01
yyyy年M月d日	2025年07月01日

Time format	Setting example
H:mm	12:30
Hss	12:30:00

How To Specify comment¶

Set as a comment item in the Csv file

JSON format string¶

[{""CreatedTime"": ""2025-07-01 12:30:00"",""Creator"": 10,""Body"": ""comment""}]

JSON¶

[
    {
        "CreatedTime": "2025-07-01 12:30:00",
        "Creator": 10,
        "Body": "comment"
    }
]

When you want to set a string as the value of Creator

JSON format string¶

[{""CreatedTime"": ""2025-07-01 12:30:00"",""Creator"": ""HAYATO"",""Body"": ""comment""}]

JSON¶

[
    {
        "CreatedTime": "2025-07-01 12:30:00",
        "Creator": "HAYATO",
        "Body": "comment"
    }
]

When you want to set multiple comments

JSON format string¶

[{""CreatedTime"": ""2025-07-01 12:30:00"",""Creator"": 10,""Body"": ""comment1""},{""CreatedTime"": ""2025-07-02 12:30:00"",""Creator"": 11,""Body"": ""comment2""}]

JSON¶

[
    {
        "CreatedTime": "2025-07-01 12:30:00",
        "Creator": 10,
        "Body": "comment1"
    },
    {
        "CreatedTime": "2025-07-02 12:30:00",
        "Creator": 11,
        "Body": "comment2"
    }
]

Supported Versions¶

Supported Versions	Body
1.4.18.0 and later	Added the ability to update comments when updating records in CSV import