Developer Function: JSON Data Layout: Item
## Overview
This explains the layout of the JSON data of the "Record" of the [Table](/en/manual/table) that are retrieved using the [Record Retrieval API](/en/manual/api-record-get) of the [API](/en/manual/api).
## JSON Data Layout
|No|Property name|Field name|Data type|Notes|
|:----|:----|:----|:----|:----|
|1|SiteId|"Site ID item"|long| |
|2|UpdatedTime|"「updated Datetime Item 」"|DateTime| |
|3|IssueId or ResultId|"[ID Item](/en/manual/table-management-id)"|long| |
|4|Ver|"[Version Item](/en/manual/table-management-ver)"|int| |
|5|Title|"[Title Item](/en/manual/table-management-title)"|string| |
|6|Body|"「Content Item」"|string| |
|7|StartTime|"「Start Item」"|DateTime|Only for time-limited tables|
|8|CompletionTime|"[Complete Item](/en/manual/table-management-completion-time)"|DateTime|Only for time-limited tables|
|9|WorkValue|"「Workload Item 」"|decimal|Only for time-limited tables|
|10|ProgressRate|"「Progress Rate Item」"|decimal|Only for time-limited tables|
|11|RemainingWorkValue|"「Remaining Workload Item」"|decimal|Only for time-limited tables|
|12|Status|"「Status Item」"|int| |
|13|Manager|"「Administrator Item」"|int| |
|14|Owner|"「Person In Charge Item」"|int| |
|15|Locked|"[Lock Item](/en/manual/table-management-lock)"|bool| |
|16|Comments|"[Comment Item](/en/manual/table-management-comments)"|string| |
|17|Creator|"「Creator Item」"|int|User ID|
|18|Updator|"「Updater Item」"|int|User ID|
|19|CreatedTime|"[Created Datetime Item](/en/manual/table-management-created-time)"|DateTime| |
|20|ItemTitle|"[Title Item](/en/manual/table-management-title)"|string| |
|21|ClassHash|"[Created Datetime Item](/en/manual/table-management-created-time)"|Dictionary<string, string>|See the setting example below|
|22|NumHash|"「Numerical Item」"|Dictionary<string, decimal>|See the setting example below|
|23|DateHash|"[Date Item](/en/manual/table-management-date)"|Dictionary<string, DateTime>|See the setting example below|
|24|DescriptionHash|"[Description Item](/en/manual/table-management-description)"|Dictionary<string, string>|See the setting example below|
|25|CheckHash|"[Check Item](/en/manual/table-management-check)"|Dictionary<string, bool>|See the setting example below|
|26|AttachmentsHash|"[Attachment Item](/en/manual/table-management-attachments)"|Dictionary<string, Attachments>|See the "Attachments object" and setting example below|
### Attachments Object
|Property name|Data type|Notes|
|--|--|--|
|Guid|String|Attachment GUID|
|Name|String|Attachment file name|
|ContentType|String|Content Type|
|Base64|String|File data encoded in Base64|
## Setting Example
ClassHash、NumHash、DateHash、DescriptionHash、CheckHash setting example (json)
```
"ClassHash": {
"ClassA": "Classification",
"ClassB": "Unclassified",
"ClassC": "Other"
},
"NumHash": {
"NumA": 100,
"NumB": 200
},
"DateHash": {
"DateA": "2019/01/01",
"DateB": "2020/01/01"
},
"DescriptionHash": {
"DescriptionA": "Description",
"DescriptionB": "Summary",
"DescriptionC": "Additional Information"
},
"CheckHash": {
"CheckA": true,
"CheckB": false
}
```
AttachmentsHash setting example (json)
```
AttachmentsHash: {
AttachmentsA: [
{
ContentType: 'text/plain',
Name: 'Readme.txt',
Base64: '5yY5Trfi4…'
},
{
ContentType": 'text/csv',
Name: 'data.csv',
Base64: 'Rgfc2g3ZSe…'
}
],
AttachmentsB: [
{
ContentType: 'image/jpeg',
Name: 'logo.jpeg',
Base64: 'b4yT5HJfg2…'
}
]
}
```
## Related information
<div id="ManualList"><ul><li><a href="/en/manual/table">Table Function</a><span>08.13.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-id">Table Management: Item: ID</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-ver">Table Management: Item: Version</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-title">Table Management: Item: Title</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-completion-time">Table Management: Item: Complete</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-lock">Table Management: Item: Lock</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-date">Table Management: Item: Date</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-description">Table Management: Item: Description</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-check">Table Management: Item: Check </a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-attachments">Table Management: Item: Attachment</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-comments">Table Management: Item: Comment</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-created-time">Table Management: Item: Created Datetime</a><span>08.13.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/api-record-get">Developer Function: API: Table Operation: Retrieve Single Record</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/api-record-get-multi">Developer Function: API: Table Operation: Retrieve Multiple Records</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
