Supported Field Types

Supported Field Types

When managing content types fields through the Administration API you need to understand what kind of fields you can have in a content type.

Cloud Content Types

The next table lists the field types that you can use in a Telerik Platform content type. The Type Number column contains the data type's number representation that is returned in the DataType property.

Type Name Type Number Description
Id n/a Unique identifier of each record.
Undefined 0 When the field is undefined.
Text 1 String able to hold both text and objects. Note: Objects won't be displayed properly in the backend interface. Use an Object field if you need to store complex nested values.
Number 2 Standard number representation. Can be integer or decimal number.
Date and Time 3 A single date-time value in ISO 8601 format. Example: 2013-01-01T12:17:30.486Z.
Yes/No 4 This type represents Boolean values that can be true or false. Null and undefined are interpreted as false.
Geo Point 5 Object with two properties: longitude and latitude, which are decimal numbers. Format: { "longitude": number, "latitude": number }
File 6 Unique identifier of a file present in the Files type.
Relation 7 Pointer to the Id of an external type.
Object 8 An object field can be used to store complex nested values (e.g. a nested object, array of objects, etc.)
Array n/a Array used to hold multiple values or objects.
Relation: multiple n/a An array of pointers to the Ids of an external type.

Content Types from Relational Database Data Connectors

The next table lists the field types that can be used in relational database Data Connectors content types. Refer to this table if you are connecting to Microsoft SQL Server, MySQL Enterprise, PostgreSQL, or Oracle Database.

Content types for data coming from relational databases support a specific set of field types. How source data types map to Telerik Platform field types is predefined and cannot be changed. The examples in the table below are provided only for reference.

Telerik Platform Type Type Number Description
Text 1 A Text field.
Example: varchar or nvarchar type from Microsoft SQL Server.
Number 2 A Numeric field.
Example: smallint, int, bigint, decimal, real, float or numeric type from Microsoft SQL Server.
Date and Time 3 A DateTime field.
Example: the datetime type from Microsoft SQL Server.
Yes/No 4 A Boolean field.
Example: the bit type from Microsoft SQL Server.
Object 8 An object field used to store complex values.
Example: the image, filestream, or binary type from Microsoft SQL Server.
Date 9 A Date field in format "yyyy-MM-dd".
Example: the date type from Microsoft SQL Server.
Time 10 A Time field in format "HH:mm:ss.FFF" without a time zone.
Example: the time type from Microsoft SQL Server.

Content Types from Salesforce Data Connectors

The next table lists the field types that can be used in Salesforce Data Connectors content types.

Content types for data coming from Salesforce support a specific set of field types. How source data types map to Telerik Platform field types is predefined and cannot be changed. The examples in the table below are provided only for reference.

Telerik Platform Type Type Number Description
Text 1 A Text field.
Example: the TEXTAREA or PHONE type from Salesforce.
Number 2 A Numeric field.
Example: the INT or NUMBER type from Salesforce.
Date and Time 3 A DateTime field.
Example: the TIME type from Salesforce.
Yes/No 4 A Boolean field.
Example: the CHECKBOX type from Salesforce.
Object 8 An object field used to store complex values.
Example: the BINARY type from Salesforce.

See Also


Start a free trial Request a demo
Contact us: +1-888-365-2779
sales@telerik.com
Copyright © 2016-2017, Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.