FormLayout
Update and Query the available Form Layout in kintone.
Select
The AppId column is required in the WHERE clause. The connector will use the Kintone APIs to filter the results by this column. By default, the connector will process other filters client-side within the connector.
For example, the following queries are processed server side:
SELECT * FROM FormLayout WHERE AppId = 6 SELECT * FROM FormLayout WHERE AppId = 6 AND Lang = 'en' SELECT * FROM FormLayout WHERE AppId = 6 AND IsPreview = false
Update
For updating the FormLayout, provide the Layout as an aggregate. All fields in the form must be specified in the aggregate. The AppId column is required to update the FormLayout.
UPDATE FormLayout SET Layout = '[{"type":"ROW","fields":[{"type":"SPACER","code":"Table_0","size":{"width":"200"}}]}]' WHERE AppId = 6
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | False |
The App ID of the kintone application. | |
| Fields | String | False |
A list of fields in the row. | |
| Type | String | False |
The type of row. The allowed values are ROW, SUBTABLE, GROUP. | |
| Code | String | False |
The field code of the Table or Group field. This parameter will not be returned for other row types. | |
| Revision | String | True |
The revision number of the App settings. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| IsPreview | Boolean |
By setting this to False, you will be able to retrieve the Form Layout details of the live App. Default value is true. |
| Layout | String |
Only used for performing Insert or Update. |