Columns

This section explains how to pass values for different fields when adding or updating a record using API.

NOTE : Only columns which are currently supported by API for add or edit record are listed below. If you do not find any column that means it not available for use in API.

TEXT: Any string

MULTILINE : Any valid HTML

EMAIL: A valid email address

PHONE/FAX NO. : Any alphanumeric string

URL : A valid URL

NUMBER : Any valid number including floating point numbers.

CURRENCY : Any valid number including decimals but without any currency symbol. Currency symbol defined at the column settings will be used.

DATE:

1. DATE ONLY: Date string in the format “DD-MM-YYYY” e.g. 20-03-2030

2. DATE & TIME : Date string in the format “DD-MM-YYYY hh:mm” e.g. “20-03-2030 13:25” where hh is a two digit 24 hour time and mm is a two digit minute. The time must be in a UTC time zone.

DURATION: hh:mm format duration where hh is a two digit 24 hour time and mm is a two digit minute

CHOICE: The id of the choice value

USER: A comma-separated list of valid email addresses