WorkSmart Dev
HomeSign In
  • Introduction
  • REST Web API
    • Oauth 2.0 Authorization
      • Authorization Code Flow
      • Token (Auth Code Flow)
      • Token (Client Credentials)
    • Records
      • Create Record
      • Read Record
      • Update Record
      • Delete Record
      • Read Records By View
      • Add Comment
      • Add Attachment
      • Download Attachment
    • List Sites
    • Columns
      • List of Columns
  • Webhook
    • Configure a Webhook
Powered by GitBook
On this page

Was this helpful?

  1. REST Web API

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

PreviousList SitesNextList of Columns

Last updated 3 years ago

Was this helpful?