User Manual

08.14.2024

MANUAL

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](/en/manual/table-management-start-time)"|DateTime|Only for time-limited tables| |8|CompletionTime|"「Complete Item」"|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](/en/manual/table-management-remaining-work-value)"|decimal|Only for time-limited tables| |12|Status|"[Status Item](/en/manual/table-management-status)"|int| | |13|Manager|"[Administrator Item](/en/manual/table-management-manager)"|int| | |14|Owner|"[Person In Charge Item](/en/manual/table-management-owner)"|int| | |15|Locked|"「Lock Item」"|bool| | |16|Comments|"「Comment Item」"|string| | |17|Creator|"「Creator Item」"|int|User ID| |18|Updator|"[Updater Item](/en/manual/table-management-updator)"|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」"|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">Manage Table: Items: ID</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-ver">Manage Table: Items: Version</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-title">Manage Table: Items: Title</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-start-time">Manage Table: Items: Start Time</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-remaining-work-value">Manage Table: Items: Remaining Work Volume</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-status">Manage Table: Items: Status</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-manager">Manage Table: Items: Manager</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-owner">Manage Table: Items: Owner</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-date">Manage Table: Items: Date</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-description">Manage Table: Items: Description</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-attachments">Manage Table: Items: Attachments</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-updator">Manage Table: items: Updated By</a><span>10.24.2025 up</span></li> <li><a href="/en/manual/table-management-created-time">Manage Table: Items: Created On</a><span>10.24.2025 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="" />
TOP