Property description
The columns property defines the columns ingested via queries.
Minimal JSON
{
"key": ""
}Nested properties
| Property | Description | Values | Mandatory |
|---|---|---|---|
key | Key of the query that needs to be defined. | string | Yes |
columnIndex | Index of the column. | integer | No |
dataType | Data type of the column in Dawiso. See supported dataType values. | string | No |
expression | Data transformation expression. Examples: CASE WHEN [HASRULES] = 'f' THEN 'NO' ELSE 'YES' END or '<pre class="language-sql"><code>' + [DEFINITION] + '</code></pre>' | string | No |
isFromKey | Marks column as the starting object in a relation. | boolean | No |
isKey | Marks column as the unique key/ID of the object. | boolean | No |
isParentKey | Marks column as the ID of the parent object. | boolean | No |
isRelationType | Marks column as a type of relation between objects. | boolean | No |
isSortOrder | boolean | No | |
isToKey | Marks column as the target object in a relation. | boolean | No |
sourceDataType | Data type of the column in the source system. See supported sourceDataType values. | string | No |
Supported dataType values
Supported values for the dataType property are, e.g.:
[BIGINT][BIT][DATETIME][DATETIME2](3)[INT][NVARCHAR](100)[NVARCHAR](1000)[NVARCHAR](255)[NVARCHAR](36)[NVARCHAR](400)[NVARCHAR](4000)[NVARCHAR](425)[NVARCHAR](850)[NVARCHAR](MAX)[SMALLINT][TINYINT][UNIQUEIDENTIFIER][VARBINARY](MAX)[VARCHAR(36)]
Supported sourceDataType values
Supported values for the sourceDataType property are, e.g.:
BooleanByteByte[]DateTimeInt32Int64ObjectString