## Overview This is the "Get Method" of the "「Items Object」". It gets information about the specified record or records in the specified table. If the table has "「Site Integration」" set, it also gets information about each integrated record. ## Limitations 1. The maximum number of records that can be retrieved is the PageSize (default 200) in Api.json. If you want to retrieve more than 200 records, please refer to "[FAQ: I want to retrieve data exceeding 200 records via API](/en/manual/faq-api-paging)". ## Syntax ``` items.Get(id, data) ``` ## Parameters |Parameter|Type|Required|Description| |:----------|:----------|:---:|:---------------------------| |id|object|Yes|Specify the site ID and record ID| |data|string|No|Specify the filter and sort of the records to be selected in JSON format| ## Return Value Return an array of "apiModel" for the corresponding records. ## Usage Example 1 The following example retrieves the record with record ID 123. ##### JavaScript ``` let result = items.Get(123); ``` ## Usage Example 2 The following example gets and logs information on records with a Status of 900 (completed) registered in a recorded table with a site ID of 2. ##### JavaScript ``` let data = { "View": { "ColumnFilterHash": { "Status": "[\"900\"]" } } }; let results = items.Get(2, JSON.stringify(data)); for (let item of results) { context.Log(`${item.ResultId} ${item.Title} ${item.ClassA} ${item.NumB}`); } ``` ## Notes This is a method used in "「Server Script」". It cannot be used in "「Script」". ## Related Information ・[Manage Table: Server script](/manual/table-management-server-script) ・[Execution Timing for Each Object](/manual/server-script-conditions) ・[Items Object](/manual/server-script-items)